Advanced Power BI – DAX and Data Modeling

15 August, 2024Amsterdam, The Netherlands

2 days
In Person
Data Analytics
Microsoft
PowerBI

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?

Diego will gladly help you further with custom training solutions.

Get in touch

Duration

2 days

Time

09:00 – 17:00

Language

English

Lunch

Included

Certification

No

Level

Professional

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

Program

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.

  • 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

This training is for you if:

You’ve been working with Power BI 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 visualisations 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

What else should I know?

After registering for this training, you will receive a confirmation email with practical information. A week before the training, the trainer will get in touch to ask you about any requirements you may have and any pre-course tasks you will need to do.

See you soon!

Training information

All literature and course materials are included in the price

Information on the software and tooling will be shared before the start date

This course requires a laptop

Online courses are delivered via Zoom or Microsoft Teams

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
Tableau in a Day 

Get started with Tableau and build your first dashboard! This Tableau training will launch your Data Analytics journey.

Data Analytics
Data Visualization
Tableau
Virtual

From:

€680

View training
Data Storytelling

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

Lysanne van Beek

Data Analytics
Data Visualization
2 days
Virtual

Next:

27 – 30 May, 2024

From:

€1310

View training
Power BI in a Day

Share quality data insights with Microsoft Power BI

Lysanne van Beek

Data Analytics
Data Visualization
Microsoft
PowerBI
1 day
Virtual

Next:

1 Jul, 2024

From:

€645

View training
Introduction to Deep Learning for Computer Vision

Master neural networks and deep learning and understand AI’s visual capabilities with our two-day introductionary Deep Learning course.

Enrico Erler

Deep Learning
2 days
Virtual

Next:

15 – 16 Jul, 2024

From:

€1415

View training
Introduction to Generative AI

Get a non-technical introduction to the field of Generative AI and learn best practices when using Generative AI tools.

Lysanne van Beek

Generative AI
0.5 days
Virtual

Next:

25 Jun, 2024

From:

€350

View training

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