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
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.
- Blaine Clark, KPERS
