Power BI – Advanced

Training Level 3.0
expert trainers follow-up support high-quality training material certificate

You want to be a Power BI expert? Then this training is for you. In two days you learn to master M scripting, DAX, data modelling and you learn how to extend the capabilities of PowerBI by integrating R.


DataTraining.io has transformed the way we do our analysis and reporting.


The instructors were first rate professionals and extremely skilled. They answered all questions very thoroughly and handled the different levels of experience among the participants very well.


The team from DataTrainingio was very flexible and organised a training last minute for us. They are very professional and friendly and provided a great two-day training.


I’d highly recommend DataTraining.io for anyone interested in developing their analytical skill set – you’re in great hands.


Our trainer was first rate and helped us hugely throughout the course. I wouldn’t hesitate to use DataTraining.io in the future.

Get Offer


  • Optimise performance of queries
  • Discover new features with M scripting
  • Machine learning and visualisation with R in Power BI
  • Mastering DAX calculations
  • Power BI architecture and administration


  • Parameters in M
  • Incremental refresh
  • List generation
  • Duration functions
  • Table functions
  • Query optimization
  • M custom functions
  • Error handling

  • Advanced relationships
  • Bi-directional filtering
  • Static and dynamic segmentation
  • Table granularity
  • Many-to-many relationships

  • Advanced filter context
  • Querying with DAX
  • Optimizing formula engine

  • Connecting R and Power BI
  • Scripts for R Integration
  • Statistical Modeling in Power BI with R
  • Pitfalls when integrating R

  • Python-enabled visualizations
  • Regression analysis

Training Formats

In Person
At Your Office
Real Time
Location Your Office. Our trainer comes over to you. Online, you connect with the trainer and your team real time.
Duration 2 consecutive days 4 sessions x 3.5h
Date Flexible, we will align with you to find the best date. Flexible, we will align with you to find the best date.
Materials provision Printout
USB stick
Download Link
Download Link
Number of participants Up to 12 Up to 10
Follow-up Power BI Learning Path Access + 2h of support Power BI Learning Path Access + 2h of support
Certificate + +
Price range $$$ $$
Customization +++ +++
Focus Topics Marketing, Finance, HR, Operations, Cross-Functional, Health Care, Sales Marketing, Finance, HR, Operations, Cross-Functional, Health Care, Sales
Advantage In-person, intense version of the team training. Best remote option to conduct a team training.

At Your Office

expert trainers tailored content follow-up support high-quality training material certificate

Open Session

expert trainers follow-up support high-quality training material certificate

2 Days

Price: 950 euro (excl. VAT)

Dates do not fit your schedule? No worries- we will find a solution. Just choose your location and click I’m interested – we will be in touch shortly!

Real Time Online

expert trainers follow-up support high-quality training material certificate



Day 1

09:00 – 12:30
Advanced Power Query
12:30 – 13:30
13:30 – 17:00
Advanced Data Modeling

Day 2

09:00 – 12:30
Advanced DAX
12:30 – 13:30
13:30 – 17:00
Integrating R and Python in Power BI


We do not guarantee a specific instructor per course but we make sure your training is led by an expert in the field. Our trainers have experience across different industries and unique knowledge of applications of the analytical tools.

It is common for the course participants to approach us with their specific problems based on company data. It is often sensitive data and we would like to make sure you can feel save and secure about it. Therefore, we always recommend signing an NDA and send it along as our pre training preparation package.

As we mostly train international companies, all our trainings are conducted in English unless specifically agreed otherwise; however, support is provided in English, Dutch, Polish, and German.

At the end of the training you will receive a certificate of completion, which specifies the learned contents of the seminar.

Yes it is possible, however it may generate additional cost depending on the magnitude of changes. We would like to discuss it case by case to find an optimal solution. If you are interested in developing a training based on your data drop us a line.

We are flexible and will adjust to your needs as we go. The instructor can quickly recognize the level and learning curve of the group and adjust the pace, cases and topics as needed during the training. Usually 10% of the course outline is moderated during the training.

In-person training means we come to your office to conduct training. Therefore, having a dedicated room where all participants feel comfortable is important. Alternatively, in extraordinary circumstances, we could arrange a training location for your team but this would come at additional expense. The Real-Time Training takes place online either via Zoom, MS Teams, Webex, Hangouts or another software of your choice.

  1. Once you inquire offer, we will send you a pdf document with exact course outline and our offer.
  2. If you like it, you confirm the booking via email and we block the training dates that suit you.
  3. We follow-up with pre-training preparation and setting up all the details so that the training can run smoothly.

Other Power BI and Support Packages