Power BI – Intermediate

Zero to Hero Level 2.0
expert trainers follow-up support high-quality training material certificate

This training is for anyone who already has quite some experience working with Power BI. You will be able to use more advanced features for handling complex cases on data cleaning, modeling, DAX, and visualisation challenges.

...

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 course and materials were excellent.

...

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

...

I really like the training and it will definitely be helpful for my job.

Get Offer

Objectives


  • Prepare data for modeling and analytics
  • Create a deeper understanding of the Query Language M
  • Understand all relationship requirements and implement the right relationship
  • Set up more complex data models
  • Expand your knowledge on DAX expressions
  • Create custom and advanced visualisations
  • Build more effective dashboards and reports

Topics


  • Visualization best practices
  • Custom visualizations and custom themes
  • Map visualizations
  • Building advanced reports and dashboards

  • DAX calculation engine and filter context
  • Filter context and CALCULATE
  • Iterator functions

  • Data modeling
  • Many-to-many relatio
  • Custom calendar table
  • Working with snapshot data
  • Tracking slowly changing dimensions

  • Returning filtered tables and creating new tables
  • Working with unique values
  • Time intelligence functions

  • Measure parameters
  • Measure selection
  • Forecasting

  • M Syntax
  • Reusing entire or parts of other queries
  • M Functions

  • Dynamic titles and variable declaration
  • Generating data table with DAX
  • Storing measures and staying organized

  • Connect to data
  • Calculate KPIs
  • Create advanced visualizations
  • Create a report control dashboard with slicers

Training Formats


In Person
At Your Office
Online
Real Time
Online
Zero to Hero
Location Your Office. Our trainer comes over to you. Online, you connect with the trainer and your team real time. Online, you get access to the complete training. Topics include all levels 1.0 + 2.0 + 3.0.
Duration 2 consecutive days 4 sessions x 3h over 18h of content, 4 self study assignments
Date Flexible, we will align with you to find the best date. Flexible, we will align with you to find the best date. Self paced, access renewed monthly.
Materials provision Printout
USB stick
Download Link
Download Link Download Link
Number of participants Up to 12 Up to 10 1
Follow-up 12 InFocus Videos 2h of support 12 InFocus Videos 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 Most customizable and intense version of the team training. Best remote option to conduct a team training. Universal online training for individuals focused on implementation.

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

Impressions


Agenda Onsite Training


Day 1

09:00 – 11:00
Advanced Reports and Geo-Mapping
11:00 – 12:30
Filter Context, Calculate, and Iterators
12:30 – 13:30
Lunch
13:30 – 15:30
Combining Data with Power Query
15:30 – 17:00
Filter and table functions

Day 2

09:00 – 10:30
Disconnected tables
10:30 – 12:30
Power Query Advanced Editor
12:30 – 13:30
Lunch
13:30 – 14:30
Dax Tricks and Tips
14:30 – 17:00
End-to-End Case Study

FAQ


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.

Everything. Really- no tricks here, it is the price excluding VAT. And it is the end price, no extra travel cost or allowance cost for the trainer, no location charges or other hidden traps. What you see is what you get.

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.

Inhouse training (at your office) and Open registration 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.

Inhouse 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 Open Registration means you join a training in one of our locations and join participants from different companies at a designated training location.

  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