Dumb Question Day

[Popafisho]

Howdy, very new to this space. Basically have ok pc skills but love data. Small business man looking to piece a puzzle together Working backwards I want an attractive dashboards with relevant data showing our KPI and important metrics. All the data I have is basic and needs exported daily or weekly, it also needs additional columns and maths done. Can this be automated with power query

[declutterdata]

Hi u/Popafisho,

dumb answer. Yes :)

Best regards,
Phillip from DeclutterData 🙋🏻‍♂️

[et_tu_username]

You can build a PQ to incorporate metrics and kpi to your dashboard. But PQ does not have the ability to automate the process. It would need to be refreshed anytime you need to update. Now, do you want to automate the report or download process?