Automating Business Reporting: Combining Power Query and Power Pivot

In the modern office, we’re constantly receiving updated information and integrating that into our reports. By leveraging the newest, most powerful tools in Excel – Power Query and Power Pivot – we can drive dynamic reports built with Pivot Tables in seconds. In this session, we’ll tackle real-world scenarios to aggregate new information and add it to a live dashboard with a click of a button.

Topics include:

• Importing multiple files automatically with Power Query
• Cleaning and organizing data into a star schema
• Building relationships between data tables
• Building dynamic dashboards with Pivot Charts and Slicers

Experience with Pivot Tables in Excel