CHAPTER 23

image

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?

  1. Gathering user requirements
  2. Writing formulas and building pivot tables
  3. Creating and formatting charts
  4. 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.