CHAPTER 23
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 ...
Get Dashboards for Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
