Course Description
This 2-day advanced Power BI training 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.
Testimonials
Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.
- Blaine Clark, KPERS
Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.
- Chris, Cirrus Aircraft
Absolutely loved the enthusiasm and appreciate the knowledge he brought to class!!!
- Shelly Fruits, KPERS
