Course Description
Take your Microsoft Power BI expertise to the next level with ExistBI’s comprehensive two-day Advanced Power BI and DAX Training course.
Designed for experienced Power BI users, business intelligence developers, data analysts and reporting professionals, this live instructor-led course focuses on mastering Data Analysis Expressions (DAX) to develop sophisticated calculations, advanced reports and powerful analytical solutions.
Participants learn how to create calculated columns, measures and calculated tables, understand row and filter contexts, and apply advanced DAX functions to solve complex business reporting challenges.
The course explores essential DAX concepts, including the CALCULATE function, advanced filtering techniques, table functions, iterator functions, time intelligence, calculation groups and visual calculations.
Through practical demonstrations and hands-on exercises, participants develop the skills to create more flexible Power BI semantic models, analyse complex datasets and deliver meaningful business insights.
Our experienced Microsoft Power BI instructors provide comprehensive course materials, practical exercises and expert guidance throughout the training.
Prerequisites: Previous experience using Power BI Desktop, creating reports and working with basic DAX calculations is recommended.
Flexible Training Options
Choose from regularly scheduled public online classes or private corporate training delivered virtually or onsite.
Private Advanced Power BI training can be customised to your organisation’s requirements, including course content, training duration, hands-on exercises and the use of your own business data.
Course Outcomes
After completing this two-day Advanced Power BI and DAX training course, you will be able to:
- Understand the structure of Power BI semantic models and how DAX enhances analytical capabilities.
- Create calculated columns, calculated tables and measures using DAX.
- Write more sophisticated DAX expressions using variables, functions and formulas.
- Understand row context, filter context and context transition.
- Apply the CALCULATE function to modify filter contexts and develop advanced calculations.
- Use DAX table functions and iterator functions to perform complex aggregations and analysis.
- Apply time intelligence functions to analyse trends across days, months, quarters and years.
- Understand how relationships and data model structures affect DAX calculations.
- Create and use calculation groups to simplify repetitive analytical calculations.
- Develop visual calculations to enhance Power BI reports.
- Apply advanced DAX techniques to solve practical business reporting challenges.
Course Summary
Next Public Course Dates | |
| Course Name | Advanced Power BI & DAX Training |
| Level | Advanced |
| Duration |
|
| Audience | Power BI Developers, Data Analysts, BI Professionals, Report Developers |
| Prerequisites | Power BI Desktop experience and basic DAX knowledge recommended |
| Delivery | Live Instructor-Led Online or Private Onsite |
| Hands-On Labs | Included |
| Public Training | UK, Europe, USA and Canada |
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
