Welcome to our comprehensive training program designed to assist you every step of the way of learning and 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 1.0
Enrollment closed
Course Contents
Sneak Peek
Topics covered
From a normal pivot table to Power Pivot
Working with tables
Combining data the old way
Creating relationships in Power Pivot
Connecting a pivot table to the data model
Creating a dashboard using Power Pivot
Importing data Data modeling Quick checks Report structure Report filters
Building a data model in Power Pivot
Importing data into Power Pivot
Data modeling and relationships
Creating a pivot table connected to a data model
Building a report in Power BI
Introduction to Power BI
Loading data into Power BI
Creating relationships
Creating a date table
Visualizations- Area charts
Visualizations- Bar charts
Visualizations- Maps
Visualizations- Cards
Power Query - Data transformations
Connecting to data with Power Query
Quick overview
Data types
Grouping
Unpivoting
Transposing and filling down
Power Query Implementation
Connecting to data with Power Query Date cleaning and deflattening Appending and custom columns Splitting columns Merging columns Running the queries and loading into Power Pivot Resolving errors Creating the data model and report
Combining data with Power Query
Appending data sets
Merging data sets
Visualizations
Tooltips
Slicers and filters
Conditional formatting
Drilldown and drillthrough
Bookmarks
DAX Fundamentals
Quick measures
Calculated columns
Explicit vs implicit measures
Filter context and the CALCULATE function
Row context and iterator functions
Power BI Service
Publishing and sharing reports Creating dashboards Mobile layouts
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.
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.