Training schedule

Join waiting list

IN-COMPANY TRAINING PROGRAMS

Contact Gert-Jan Steltenpool, if you want to know more about custom data & AI training for your teams. He’ll be happy to help you!
Check out more

Apply Power BI in more challenging scenarios.

This training is an advanced training for experienced Power BI users. After following this training, you will provide both a theoretical background on the inner workings of Power BI and hands-on experience with the tool.

Clients we've helped

  • DSM is a GoDataDriven customer
  • Dupont - GoDataDriven customer
  • Logo-Booking.com
  • lego-logo
  • Airbus-logo
  • Merck-logo
  • Ahold Delhaize
  • Credit-Suisse-Logo
  • Shell-Logo
  • ING Bank
  • Danone logo
  • Nike-logo
  • tomtom_logo
  • Verizon-logo

What you'll learn

  • How to extract, transform and load data into Power BI from various sources
  • How to describe storage options using Power BI when connecting to a database
  • How to perform various types of data transformations in the Power Query Editor
  • How to mash up data by integrating different sources

  • How to describe Power BI desktop data modeling
  • About the relationships between tables and how to create them
  • How to create visualizations to explore data
  • How to build an interactive dashboard
  • How to share a dashboard with colleagues

The schedule

  • Introduction to the Power Query Editor
  • Introduction to M
  • Creating functions in M
  • How create and maintain a large amount of tables, columns and measures with the Tabular Editor
  • Diagnosing performance issues
  • Introducing DAX Studio
  • How to analyze how the PowerBI Engine processes DAX code

 

learning journey

Data Analyst Learning Journey

After this training

During this training you will learn how to perform advanced data transformations not available in the Query Editor. We will discuss how to leverage 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.


The Advanced Power BI training is perfect 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.

 

 

meet your trainer

Juan Manuel Perafan

Analytics Engineer

Juan is an Analytics Engineer with a passion for data visualization and programmatic solutions. His mission is to make organizations become data-driven using user-friendly tools like Tableau, Power BI, or Fivetran.

Flexible delivery

The Right Format For Your Preferred Learning Style

In-Classroom & In-Company Training
Online, Instructor-Led Training
Hybrid and Blended Learning
Self-Paced Training
Get in touch with the experts

Have any questions?

Contact Gert-Jan Steltenpool, the sales director of GoDataDriven Academy if you want to know more. He’ll be happy to help you!

You can reach him by phone as well at +31 6 4214 0783

Course: Advanced Power BI – DAX & Data Modeling Training

Book now