Introduction to Power Query
I have a quick question for you: Which of the following activities takes up the majority of analysts’ time when building dashboards?
- Gathering user requirements
- Writing formulas and building pivot tables
- Creating and formatting charts
- Presenting the reports to the boss/CEO and winning accolades
For me, the answer is none of the above. That’s because most of my time is spent on collecting and cleaning data. Everything else—writing formulas, coding VBA, creating charts, presenting the dashboard—would be a breeze if I had all the data cleaned and in one place.
Microsoft Power Query for Excel, a new add-in ...