All courses
Advanced
Power Pivot & DAX
Model millions of rows inside Excel with relationships, hierarchies and DAX measures.
Duration
2 days (14 hours)
Fee
KES 26,500
per participant
About this course
Power Pivot turns Excel into a serious data modelling engine. In this two-day Power Pivot and DAX course in Nairobi, finance and analytics professionals learn to load millions of rows, build star-schema data models, write DAX measures for time intelligence and ratios, and produce PivotTable reports that refresh in seconds. The perfect bridge between advanced Excel and Power BI.
Class goals
- Load and model data well beyond Excel's row limit
- Design clean star-schema relationships for fast analysis
- Write DAX measures: CALCULATE, FILTER, time intelligence, ratios
- Build PivotTable dashboards on top of a Power Pivot model
- Move models from Excel into Power BI when you outgrow it
Course outline
- 1Power Pivot data model fundamentals
- 2Relationships, hierarchies & calculated columns
- 3DAX measures & CALCULATE deep dive
- 4Time intelligence: YTD, QTD, prior-period analysis
- 5Bridging to Power BI
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.