- Module 1: In this module, you'll learn about the Power BI Desktop model structure, star schema design basics, analytics queries, and report visual configuration. This module provides a strong foundation on which you can learn to optimize model designs and add model calculations.
- Describe the structure of a Power BI Desktop model.
- Explain star schema design basics.
- Define the term analytic query and its phases.
- Describe how fields can be used to configure a report visual, which then generates an analytic query.
- Module 2: In this module, you'll learn how to write DAX formulas to create calculated tables, calculated columns, and measures, which are different types of model calculations. Additionally, you'll learn how to write and format DAX formulas, which consist of expressions that use functions, operators, references to model objects, constants, and variables.
- Describe the different DAX calculation types.
- Write DAX formulas.
- Describe DAX data types.
- Work with DAX functions.
- Use DAX operators.
- Use DAX variables.
- Module 3: By the end of this module, you'll be able to add calculated tables and calculated columns to your data model. You'll also be able to describe row context, which is used to evaluated calculated column formulas. Because it's possible to add columns to a table using Power Query, you'll also learn when it's best to create calculated columns instead of Power Query computed columns.
- Create calculated tables.
- Create calculated columns.
- Identify row context.
- Determine when to use a calculated column in place of a Power Query custom column.
- Add a date table to your model by using DAX calculations.
- Module 4: In this module, you'll learn how to work with implicit and explicit measures. You'll start by creating simple measures, which summarize a single column or table. Then, you'll create more detailed measures based on other measures in the model. Additionally, you'll learn about the similarities of, and differences between, a calculated column and a measure.
- Determine when to use implicit and explicit measures.
- Create simple measures.
- Create compound measures.
- Create quick measures.
- Describe similarities of, and differences between, a calculated column and a measure.
- Module 5: By the end of this module, you’ll learn about what the family of iterator functions can do and how to use them in your DAX calculations. Calculations will include custom summarizations, ranking, and concatenation.
- Describe iterator functions.
- Use aggregation iterator functions.
- Calculate rankings.
- Module 6: By the end of this module, you’ll be able to describe filter context, which is used to evaluate measure formulas. You’ll then learn why some calculations need to modify filter context and that it can be achieved by using the CALCULATE function. Additionally, you’ll learn how to configure the CALCULATE function with filters and filter modifiers.
- Describe filter context.
- Use the CALCULATE function to modify filter context.
- Pass filters to the CALCULATE function.
- Pass filter modifiers to the CALCULATE function.
- Perform context transition.
- Module 7: By the end of this module, you’ll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model. These calculations will include year-to-date (YTD), year-over-year (YoY) growth, and others.
- Define time intelligence.
- Use common DAX time intelligence functions.
- Create useful intelligence calculations.
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
By the end of this module, you'll be able to:
