Power BI Data Modeling with DAX

Description

In this course, you will :

• covers the fundamentals of working with DAX, while also sharing best practises for data model design and optimization.
• Learn how to use DAX aggregate functions, how to add calculated columns, how to create measures, and how to use DAX logical and filter functions.

Syllabus :

1. Set Up the Data Model

• Data modeling: The basics
• Get data for your model
• Check relationships

 

2. DAX Aggregate Functions

• Create a measure with SUM
• Understanding DAX syntax
• Display the measure in a matrix
• Format a measure
• Create measures with COUNT and COUNTROWS
• Delete or edit a measure
• Check your data with COUNTBLANK
• Create a measure with DISTINCTCOUNT

 

3. Measures and Calculated Columns

• Add a calculated column
• Understand explicit vs. implicit measures
• Create a measure with operators
• Create a measure with DIVIDE
• Iterators and row context: SUMX
• Basic DAX date and time functions

 

4. DAX Logical and Filter Functions

• Use FIND
• Use IF
• Use OR to handle case sensitivity
• Use CALCULATE to create a simple filter

Show more