Advanced Power BI – DAX and Data Modeling

11 December, 2023Virtual

2 days
Data Analytics

This is a follow-up training for experienced Power BI users. After completion, you will have increased your knowledge of DAX and Data Modeling with Microsoft PowerBI.

Book this training

Book now

Looking to upskill your team(s) or organization?

Nico will gladly help you further with custom training solutions.

Get in touch


2 days


09:00 – 17:00









What will you learn?

After the training, you will be able to: 

Explain the theoretical background and inner workings of Power BI.

Work from different data sources with Power BI.

Perform advanced Power BI techniques, including working with M and DAX.

Key takeaways

  1. Introduction to M code.
  2. Creating M functions.
  3. Performing transformations that are impossible to do just by clicking.
  4. Introduction to DAX studio.
  5. Speeding up models.
  6. Optimizing DAX formulas.
  7. Understanding evaluation context.
  8. Introduction to Tabular Editor.
  9. DAX formulas vs DAX queries.
  10. Mastering calculation groups.


During this training, you will learn how to perform advanced data transformations unavailable in the Query Editor. We will discuss leveraging the embedded PowerBI programming language (M) to achieve this. The M basics will be covered as well as how to write custom functions empowering participants to work with poorly structured data and to prepare it for a star structure.

In addition, participants will learn how to enable dashboard users to write back to a source through Power Apps. We will cover Power Apps fundamentals, including how to create a Power App and add it as a visual on a Power BI dashboard.

Finally, as performance problems might occur when models grow larger and more complex, we will address the Vertpaq Analyzer and DAX studio, two powerful tools to diagnose and fix performance issues.

  • Introduction to M
  • Creating functions in M
  • DAX tips & tricks
  • Working with Tabular Editor
  • Diagnosing performance issues
  • Introducing DAX Studio
  • Analyzing the processing of DAX code

Who is it for?

Power BI Key users with over a year of Power BI experience who want to bring their Data Modeling and DAX knowledge to the next level.

This training is for you if:

You’ve been working with Power BI and want to take your skills to the next level.

You want to learn about M, DAX, external tools, and performance tuning of Power BI reports.

Why should I do this training?

Elevate your Power BI skills with expert guidance in M & DAX languages

Unlock advanced data analysis and visualization capabilities

Excel in Power BI and boost your career prospects with comprehensive training

What else
should I know?

After registering for this training, you will receive a confirmation email with practical information. We will share literature a week before the training if there’s a need to prepare.

See you soon!​

Course information

All literature and course materials are included in the price. 

The training requires DAX Studio and Tabular Editor. These can be downloaded for free but for installation (temporary) admin rights are required.

Meet the trainers

Juan Manuel Perafan

Meet Juan Manuel Parafan, trainer at Xebia Academy. Juan is a Data Science trainer and trains on behalf of Xebia and GoDataDriven the DA-100 Exam training: Analyzing Data with Microsoft Power BI. View Juan’s full profile and training courses on Xebia Academy.

Also interesting for you

View all trainings
MLOps on Azure

This MLOps on Azure training is then a perfect next step if you’d like like to take your Machine Learning models further.

Machine Learning
3 days
In Person


7 Feb, 2024



View training
Developing Data Models with LookML

This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.

Data Analytics
View training
Analyzing and Visualizing Data in Looker

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completing this course, you will be able to leverage Looker’s modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions about your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.

Data Analytics
View training
Data Science Bootcamp

Transform into a certified Data Scientist in just 12 weeks. This boot camp will kick-start your Data Science career with Python.

Lysanne van Beek

Data Science
11 days


25 Jan, 2024



View training
Time Series Analysis & Forecasting

Learn how to extract insights, interpret seasonality and build forecasting models from time series data.

Data Science
4 days


4 Mar, 2024



View training

Can’t find the course you’re looking for? There’s more!