Masterclass
Power BI 1.0
15.06.2020

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

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.

Check out

Register

Payment

Review order

Masterclass Power BI 1.0 Jump Start: Our comprehensive training program designed to assist you every step of the way of learning and implementing your Power BI project.

€ 500

Have a coupon?

Yes, I have!

Total: €500

I accept the Terms & Conditions

Continue

Your country?

Your company size?

Your Profession?

I accept the Terms & Conditions

I would like to receive news, tips and tricks, and other promotional material

Forgot your password?

Masterclass
Power BI 1.0
15.06.2020

Course Contents

Sneak Peek

Topics covered

From a normal pivot table to Power Pivot

Creating a dashboard using Power Pivot

Creating a dashboard using Power Pivot

Building a data model in Power Pivot

Building a report in Power BI

Power Query - Data transformations

Power Query Implementation

Combining data with Power Query

Visualizations

DAX Fundamentals

Power BI Service

Frequently Asked Questions

All Power BI Trainings

Click "Edit Contents" and start uploading your learning material.

Select a course first to display its contents.

No available contents for

Registro y Pago

Registro

Producto

There are no free, paid or coming soon courses in your school yet.
Why don't you create one?

The school owner is working hard preparing the courses for you.

Oops, you haven't created any courses yet.

No blog posts found in your blog. Why don't you create one?

Masterclass Power BI 1.015.06.2020

Course Contents

Sneak Peek

Topics covered

From a normal pivot table to Power Pivot

Creating a dashboard using Power Pivot

Creating a dashboard using Power Pivot

Building a data model in Power Pivot

Building a report in Power BI

Power Query - Data transformations

Power Query Implementation

Combining data with Power Query

Visualizations

DAX Fundamentals

Power BI Service

Frequently Asked Questions

Check out

Register

Payment

All Power BI Trainings

Click "Edit Contents" and start uploading your learning material.

Select a course first to display its contents.

No available contents for

Registro y Pago

Registro

Producto

There are no free, paid or coming soon courses in your school yet.Why don't you create one?

The school owner is working hard preparing the courses for you.

Oops, you haven't created any courses yet.

No blog posts found in your blog. Why don't you create one?

Masterclass
Power BI 1.0
15.06.2020

There are no free, paid or coming soon courses in your school yet.
Why don't you create one?