Advanced Power BI – DAX and Data Modeling

15 augustus, 2024Amsterdam, The Netherlands

2 days
In Person
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

Registreer je nu

Looking to upskill your team(s) or organization?

Rozaliia will gladly help you further with custom training solutions.

Rozaliia Khafizova
Data and AI Training Advisor

+31 6 11 58 19 37

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 & DAX

Apply best practices while working with Power BI

Perform transformations that are impossible to do just by clicking


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, you 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.

  • Power Query beyond the GUI
  • Introduction to M, the embedded Power BI programming language
  • Creating custom functions in M
  • Performing transformations that are impossible to do just by clicking
  • DAX Tips & Tricks
  • Understanding evaluation context
  • DAX formulas vs DAX queries
  • Mastering calculation groups
  • Power Apps
  • Enable dashboard users to write back to a source through Power Apps
  • How to create a Power App
  • Adding a Power App as a visual on a Power BI dashboard
  • Performance Tuning
  • Introducing DAX Studio and Vertpag Analyzer
  • Diagnosing performance issues
  • DAX Tips & Tricks
  • Optimizing DAX formulas
  • Working with Tabular Editor
  • Analyzing the processing of DAX code

This training is for you if:

You’ve been working with Power BI for a while and would like to take your skills to the next level

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

This training is not for you if:

You’ve never worked with Power BI before. (Check out our Power BI in a Day training instead.)

You want to be certified in the Microsoft PL-300 exam: Analyzing Data with Microsoft Power BI. (Check out our Microsoft PL-300 training instead.

You want to learn more about creating better visualizations and data storytelling (Check out our Data Storytelling course instead).

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

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
Microsoft PL-300 Exam Training

Th Microsoft PL-300 Exam Training prepares you, not surprisingly, for the Microsoft PL-300 exam. Read more!

Data Analytics
7 days


26 aug, 2024



Bekijk training
Data Storytelling

Create compelling visuals and engaging data stories that inform, entertain, and drive action.

Data Analytics
data visualization
2 days
In Person


15 – 16 aug, 2024



Bekijk training
Python for Data Analysis

Learn how to code in Python and perform data analysis with our Python for Data Analysis training.

Gegevens en AI
Data Science
2 days
In Person


12 – 13 aug, 2024



Bekijk training
Analyzing and Visualizing Data in Looker

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
Bekijk 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
Bekijk training

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