FormulaCamp
Completed
← Full curriculum
Track 10 · Analyst

Power Pivot and DAX

Data models, relationships, the star schema, DAX measures, filter context, and time intelligence.

2 free lessons

0 of 8 completed · about 3.4 h

Start

8 lessons left until your certificate

Model and Measures

  1. 1Power Pivot and DAX: The Data ModelFreetheory and quiz15 min
  2. 2First Measures: SUM, COUNTROWS, DIVIDEFreelesson25 min
  3. 3CALCULATE and FILTERlesson30 min
  4. 4ALL and REMOVEFILTERS: Shareslesson25 min
  5. 5RELATED and the SUMX Iteratorlesson25 min

Time and Model Quality

  1. 6Time Intelligence: YTD, Prior Year, Growthlesson30 min
  2. 7A Good Model: Star Schema, Measures, and Speedtheory and quiz15 min

Project

  1. 8Project: A Sales Analytics Modelproject40 min