Data Modelling & Power Pivot
What you will be able to do
- Build a data model with relationships
- Write DAX measures
- Use CALCULATE and time intelligence
- Report budget against actual
19 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: The data model
- Why a data model beats one big tableReal Excel
- Fact and dimension tablesReal Excel
- Adding tables to the data modelReal Excel
- Creating relationshipsReal Excel
- The date tableReal Excel
- PivotTables from the data modelReal Excel
Module 2: DAX basics
- Calculated columns vs measuresReal Excel
- SUM, COUNTROWS and DISTINCTCOUNT measuresReal Excel
- DIVIDE and safe ratiosReal Excel
- RELATEDReal Excel
- CALCULATE basicsReal Excel
- CALCULATE with FILTER and ALLReal Excel
- % of totalReal Excel
Module 3: Time intelligence and reporting
- TOTALYTDReal Excel
- SAMEPERIODLASTYEARReal Excel
- Budget vs actual in the modelReal Excel
- CUBEVALUE for formatted reportsReal Excel
- Model tidinessReal Excel
Project: sales and budget model
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free