This course will walk through parsing data modeling formulas, using DAX to create calculations, consequences of data model design decisions, concepts of calculated columns and measures, with particular focus on design patterns.
Overview
COURSE DIFFICULTY
COURSE DURATION
6h 23m
Skills Learned
After completing this online training course, students will be able to:
Write advanced DAX formulas using CALCULATE and filter context
Implement time intelligence calculations for period comparisons
Master filter context and context transition concepts
Design efficient data models with proper relationships
BI Developers, Data Analysts
Basic Power BI knowledge
01. Class Introduction
02. Data Modeling Basics and Power BI Desktop Internals (Overview Part 1))
03. Data Modeling Basics and Power BI Desktop Internals (Overview Part 2))
04. Data Modeling Basics And Power Bi Desktop Internals (Lab 1)
05. Data Modeling Best Practices
06. Dax Calculated Columns & Measures (Calculated Columns)
07. Dax Calculated Columns & Measures (Calculated Measures)
08. Dax Calculated Columns & Measures (Lab 2)
09. Calculate
10. Evaluation Context (Row And Filter Context)
11. Evaluation Context (Table Functions)
12. Evaluation Context (Lab 3)
13. Advanced Dax Time Intelligence Functions
14. Dax Best Practices
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Write advanced DAX formulas using CALCULATE and filter context
Implement time intelligence calculations for period comparisons
Master filter context and context transition concepts
Design efficient data models with proper relationships
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
Basic Power BI knowledge
COURSE OUTLINE
01. Class Introduction
02. Data Modeling Basics and Power BI Desktop Internals (Overview Part 1))
03. Data Modeling Basics and Power BI Desktop Internals (Overview Part 2))
04. Data Modeling Basics And Power Bi Desktop Internals (Lab 1)
05. Data Modeling Best Practices
06. Dax Calculated Columns & Measures (Calculated Columns)
07. Dax Calculated Columns & Measures (Calculated Measures)
08. Dax Calculated Columns & Measures (Lab 2)
09. Calculate
10. Evaluation Context (Row And Filter Context)
11. Evaluation Context (Table Functions)
12. Evaluation Context (Lab 3)
13. Advanced Dax Time Intelligence Functions
14. Dax Best Practices
