Power BI Expert DAX Training Course
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Power BI Expert DAX Training Course
This Power BI Expert DAX training course is aimed at proficient Power BI users who want to master the DAX language in depth, the key to advanced business-intelligence analyses. Over two intensive and highly practical days, you will consolidate your understanding of filter and row contexts, then use advanced DAX functions and Time Intelligence to create powerful, reliable measures. You will also learn to optimise your models and calculations. By the end, you will be able to design complex business indicators and high-performing Power BI reports.
Complementary courses: to go further, also discover Power Pivot Training Course, Data Analysis & Business Intelligence Learning Path and Excel Data Visualisation & Dashboards Training Course.
Good to know
The sessions are guaranteed from the first registration (except in cases of force majeure).
A preliminary interview takes place between the participant and/or a company contact in order to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment: during the course, the trainer assesses participants’ learning progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the course.
This training course is part of our Power Platform Training Courses catalogue. Explore all our Power Platform courses to automate, analyse and build your business applications without code.
Objectives of the training: Power BI Expert DAX Training Course
By the end of the course, participants will be able to:
- master filter and row contexts;
- use advanced DAX functions (CALCULATE, FILTER, iterators);
- use VAR/RETURN variables;
- carry out time-based calculations (Time Intelligence);
- optimise measures and the data model;
- design complex business indicators.
Prerequisites of the training: Power BI Expert DAX Training Course
To follow this course under the best conditions, it is recommended to have completed an advanced-skills Power BI course or to have solid practice with Power BI Desktop (modelling, simple DAX measures). Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.
Detailed programme of the training: Power BI Expert DAX Training Course
Data model and DAX refresher
- Refresher on the data model and relationships. Calculated columns and measures. Difference between a measure and a column. Best practices for organising calculations.
Filter and row context
- Gain a deep understanding of filter context and row context. Context transition. The CALCULATE function and modifying filters. FILTER, ALL, ALLEXCEPT functions.
Advanced DAX functions
- Aggregation functions and iterators (SUMX, AVERAGEX). Table functions (SUMMARIZE, ADDCOLUMNS, RELATED). VAR/RETURN variables. Handle edge cases and errors.
Time Intelligence and time-based calculations
- Create a date table. Running totals and moving totals. Period comparisons (previous year, YTD, MTD). Variation and growth analyses. Advanced Time Intelligence functions.
Optimisation and best practices
- Optimise measures and reduce calculation times. Modelling best practices. Audit and document DAX calculations. Keep reports reliable over time.
The highlights of this training course
- This course: focuses on practice with around 60% of hands-on exercises in Power BI; lets you work on your own data; takes place in a small group of 1 to 3 participants; is led by an expert trainer; leads to a certificate of completion.
FAQ
What is the DAX language?
DAX (Data Analysis Expressions) is the formula language of Power BI, Power Pivot and Analysis Services. It lets you create measures, calculated columns and derived tables. Mastery of DAX (CALCULATE, FILTER, variables, Time Intelligence) is the key to advanced business analyses — it is at the heart of this course.
Who is the Power BI Expert DAX training course for?
It is aimed at proficient Power BI users (data analysts, BI consultants, management controllers) who want to go beyond simple measures and master advanced DAX to build complex indicators and high-performing reports.
Do you already need to know Power BI to take this course?
Yes. It is recommended to have completed an advanced-skills Power BI course or to be well versed in Power BI Desktop (modelling and simple DAX measures). A preliminary interview helps confirm your level.
How long does the Power BI Expert DAX training course last?
The course lasts 2 days, i.e. 14 hours. Sessions are guaranteed from the first registration and take place in a small group of 1 to 3 participants. The programme can be customised and organised at your premises.
Is this course eligible for CPF or OPCO funding?
This course is funded directly by the company and is not eligible for CPF. Depending on your situation, funding by your OPCO may be considered: contact us to explore the funding options suited to your project.
.elementor-accordion .elementor-tab-title .elementor-accordion-icon{margin-right:10px}.elementor-accordion .elementor-tab-title .elementor-accordion-icon + a,.elementor-accordion .elementor-tab-title .elementor-accordion-title{padding-left:4px}