Power Pivot & DAX
Model millions of rows inside Excel with relationships, hierarchies and DAX measures.
2 days (14 hours)
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.
Frequently asked questions
Related courses
More Microsoft & data training delivered in Nairobi and live online across Kenya.
- Beginner
Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)KES 10,000 - Intermediate
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)KES 15,500 - Advanced
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)KES 22,500