Welcome to our comprehensive training program designed to further develop your knowledge and improve implementing your Power BI project. It includes:
4 x 3h real-time online sessions
4 x 1h self study
12 x followup Power BI InFocus videos
16 x 1h expert Q&A session
We enable you to quickly connect with the trainer even weeks after the training to help you remove roadblocks.
Non editable automatic button
Level 2.0
Topics covered
Advanced Report and Geo-Mapping
Visualization best practices
Custom visualizations and custom themes
Map visualizations
Building advanced reports and dashboards
Loading Data and Data Modeling
Data modeling
Many-to-many relations
Custom calendar table
Working with snapshot data
Tracking slowly changing dimensions
Filter Context, Calculate and Iterators
DAX calculation engine and filter context
Filter context and CALCULATE
Iterator functions
Filter and table functions
Returning filtered tables and creating new tables
Working with unique values
Time intelligence functions
Disconnected tables
Measure parameters
Measure selection
Forecasting
DAX Tips and Tricks
Dynamic titles and variable declaration
Generating data table with DAX
Storing measures and staying organized
Power Query Advanced Editor
M Syntax
Reusing entire or parts of other queries
M Functions
End-to-End Case Study
Connect to data
Calculate KPIs
Create advanced visualizations
Create a report control dashboard with slicers
Bas Dohmen
Consultancy, training and development of analytical solutions in Power BI, Tableau, R, VBA, Excel, and SQL.
Frequently Asked Questions
Do I need to prepare before the first session?
There are a few important points that you should consider before the training: - Please fill out our Check In (first learning point). - You need stable internet connection and calm space (separate room, headphones). - Our training uses Zoom for the call itself. Please download the Desktop Client before the training: https://zoom.us/download#client_4meeting - It is good to refresh your Excel skills beforehand, but not required. - Previous knowledge of Power BI is required. Please have a look at our Level 1.0 training for topics that should be familiar to you before joining.
What to expect?
REAL TIME SESSIONS Our training uses Zoom meetings to connect participants and the trainer. All participants will introduce themselves, can ask questions and share their screen during the real time session. Materials will be ready to download from the course page 24h before the training starts. The 3 h session has one short break (10-15min) to refill on coffee :).
SELF STUDY After each real time session you will receive an assignment that takes 1h to complete. You work on your own and submit results via course page.
Q&A Every week you can join an optional Q&A and ask questions about the assignment, your own data or training topics.
AFTER THE PROGRAM This is not the end! For 12 weeks we release a new InFocus Video with tips and best practices in Power BI. Additionally you will still have access to our Q&A weekly sessions where you can turn to with your pending questions.
Certificate
If you attend all Real Time sessions and submit Self Study assignements you will receive a Certificate of Completion.