Power BI Data Modeling with DAX (2019)
1h 22mIntermediate2022-03-14
Authors
Gini von Courter
Teaching computer classes on Microsoft Office for 20+ years
Course details
Power BI Desktop makes it easy to create basic data models. But if you need to report across time periods—for example, visualize year-over-year growth or compare sales or other data by month or quarter—you need Data Analysis Expressions (DAX). DAX is a language you can use to create formulas for Power BI that extend your data model. In this course, Gini von Courter covers the essentials of working with DAX, sharing best practices for data model design and optimization along the way. Learn how to work with DAX aggregate functions, add calculated columns, create measures, and work with DAX logical and filter functions.
Learning objectives
Data modeling basics
Creating a measure with operators
Formatting, deleting, and editing measures
Adding a calculated column
Basic DAX date and time functions
Creating a measure with DIVIDE
Using DAX logical and filter functions
Learning objectives
Data modeling basics
Creating a measure with operators
Formatting, deleting, and editing measures
Adding a calculated column
Basic DAX date and time functions
Creating a measure with DIVIDE
Using DAX logical and filter functions
Skills covered
Data ModelingPower BIData ScienceMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Build powerful data models with DAX
- 02 - What you will need
1. Set Up the Data Model
- 03 - Data modeling - The basics
- 04 - Get data for your model
- 05 - Check relationships
2. DAX Aggregate Functions
- 06 - Create a measure with SUM
- 07 - Understanding DAX syntax
- 08 - Display the measure in a matrix
- 09 - Format a measure
- 10 - Create measures with COUNT and COUNTROWS
- 11 - Delete or edit a measure
- 12 - Check your data with COUNTBLANK
- 13 - Create a measure with DISTINCTCOUNT
3. Measures and Calculated Columns
- 14 - Add a calculated column
- 15 - Understand explicit vs. implicit measures
- 16 - Create a measure with operators
- 17 - Create a measure with DIVIDE
- 18 - Iterators and row context - SUMX
- 19 - Basic DAX date and time functions
4. DAX Logical and Filter Functions
- 20 - Use FIND
- 21 - Use IF
- 22 - Use OR to handle case sensitivity
- 23 - Use CALCULATE to create a simple filter
- 24 - Use SWITCH
5. Using DAX Time Intelligence Functions
- 25 - DAX time intelligence functions
- 26 - Summarize year-to-date with DATESYTD
- 27 - Visualize cumulative YTD data
- 28 - Compare totals with SAMEPERIODLASTYEAR
Conclusion
- 29 - Next steps