Day 1: Power Pivot
Analyse more than 1 million rows of data
Analyse more than 1 million rows of data;
Load data into PowerPivot;
Filter data with Slicers;
Easily create Relationships between tables of data;
Create easy to use Dashboard view from PowerPivot;
Learn the principles of the DAX formula language to create powerful new calculations;
Create powerful new DAX measures in PivotTables;
Create dashboards with PowerPivot data.
Day 2: Power Query and Interactive Dashboards
Introduction to Power Query;
Benefits of Power Query;
Loading data into Power Query (Microsoft Access Tables, CSV files, online data sources, modifying tables);
Using the Group function;
Creating Custom Calculations.
Creating Interactive Dashboards with Power Pivot Data;
Advanced Dax Calculations.