Power BI Advanced
Training Level 3.0
Do 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 Power BI by integrating R.
Watch us on YouTube (100k+ subscribers):
Watch us on YouTube (100k+ subscribers):
Objectives
Get Offer
FOR TEAMS
FOR INDIVIDUALS
Learning PathPower BI
29€ /mo
Design Program
Power BI
2750€ p.p.
Topics
Advanced Power Query
- Parameters in M
- Incremental refresh
- List generation
- Duration functions
- Table functions
- Query optimization
- M custom functions
- Error handling
Advanced Data Modeling
- Advanced relationships
- Bi-directional filtering
- Static and dynamic segmentation
- Table granularity
- Many-to-many relationships
Advanced DAX
- Advanced filter context
- Querying with DAX
- Optimizing formula engine
Integrating R in Power BI
- Connecting R and Power BI
- Scripts for R Integration
- Statistical Modeling in Power BI with R
- Pitfalls when integrating R
Integrating Python in Power BI
- Python-enabled visualizations
- Regression analysis
Impressions
Training Formats
In Person
Team Training
At Your Office
Real-Time
Team Training
Online
Self-Paced
for Individuals
Online
FAQ
Who is my trainer?
We do not guarantee a specific instructor per course but we make sure your training is led by an expert in the field. We are able to indicate your instructor's name before booking the training as we see their availability for given dates. Please not that our trainers have experience across different industries and unique knowledge of applications of the analytical tools.
Will we need and NDA (non-disclosure agreement)?
It is common for the course participants to approach us with their specific problems based on the 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. However, it is not required.
What is the language of instruction?
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.
Will we receive a certificate of completion?
At the end of the training you will receive a certificate of completion, which specifies the learned contents of the seminar.
Can my training be customized?
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.
The level within my team varies. What can we do?
Before the training all participants are asked to take a short survey. This helps us in understanding better the level across your team beforehand. Additionally, we are flexible and will adjust to your needs as we go. The instructor can quickly recognize learning curve of the group and adjust the pace during the training. Usually 10% of the course outline is moderated during the training.
What is the difference between in-person training and real-time training?
In-person training means our trainer comes to your office to host the 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 as scheduled online sessions either via Zoom, MS Teams, Webex, Hangouts or another software of your choice. This setup allows for scheduling flexibility, trainings of remote teams and direct screen sharing for the questions. Training content is the same for both.
What happens after I send a training request?
Once you inquire for the training offer, we will send you a pdf document with exact course outline and our offer.
If you like it, you confirm the booking via email and we block the training dates that suit you.
We follow-up with pre-training preparation, access links and all detailed information so that the training can run smoothly.
