Course Description
This 2-day class is focused on getting students the proper skills to create advanced reports in Power BI using the DAX language for data calculations. DAX is a language that allows business users to make reports in Power BI using “Pseudo SQL queries and calcs” based functions similar to Excel for business users.
This learning path introduces Data Analysis Expressions (DAX) and provides foundational skills required to enhance semantic models with calculations. Allows to students to understand how functions and formulas should be written creating advanced calculations on data and its significance in data analysis.
Course Outcomes
At the end of the course, learners will have an understanding of:
- Model Structure: Understand the Power BI Desktop model structure and how it can be enhanced with DAX calculations.
- DAX Formulas: Learn to write DAX formulas for calculated tables, calculated columns, and measures.
- Evaluation Contexts: Explore evaluation contexts and how to modify filter context in DAX formulas.
- Time Intelligence Functions: Use DAX expressions with time intelligence functions.
- Iterator Functions: Learn about iterator functions for custom summarizations, ranking, and concatenation.
- How Evaluation Contexts, Relationships and Schemas affect formulas and models.
Course Summary
Next Public Course Dates | |
| Prerequisites (Not Mandatory) |
|
| Duration |
|
| Available Formats |
|
Course Modules
In this section, we provide the basics of the DAX language: the basic syntax, the concepts of columns and calculated measures, and an introduction to using variables.
