Dashboards with Pivot Charts, Power Query and Power Maps

A dashboard is the holy grail of data. You allow non-data users to interact with your data in a way that provides meaningful button-driven interfaces with visual Pivot Charts and Power Maps. Power Query is the behind the scenes beast that makes all of this possible, and even provides you with fresh ways to clean up dirty data you inherit from other people.

  1. Turning on the Tools you Need
  2. Linking to Folders of Data
  3. Importing Data with Power Query
  4. Working with HUGE Data Sets
  5. Power Relationships
  6. Building the Dashboard
  7. Building Power Pivot Charts and Tables
  8. Adding Slicers and Timelines
  9. Create a Refresh Button with Macros
  10. Hide the Backend