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
“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
“ExistBI has provided multiple Microsoft Power BI training to our HR, Product and Sales teams. We’ve now engaged them to assist with complex Financial reports”
- Jena Bomboy, HR Director, The Giant Company
“Mahesh was an EXCELLENT trainer. Very gifted instructor. Able to clearly communicate and teach objectives. Very engaging made you want to keep learning, and was so patient and kind to all students. Would love to be taught by him anytime.
- Jackie Calvo, Quality Improvement Manager, Horizon Health Center
