Wortell E-learning

Welkom

Download slides and files

Power BI history + Star schema's

Power BI Overview

Power Query Import Excel Sheet

Exercise 01A Start – Power Query – Import Customers

Exercise 01A - Power Query - Import Customers

Exercise 01B Start – Power Query – Import Products

Exercise 01B – Power Query – Import Products.xlsx

Optional Exercise 01B – Power Query – Import Products.xlsx

Exercise 01B Solution – Power Query – Import Products

Import a CSV file - regional settings

Exercise 01C Start – Power Query – Import Orders.csv

Exercise 01C – Power Query – Import Orders.csv

Exercise 01C Solution – Power Query – Import Orders.csv

Star schema 1 to many relationships

Exercise 01D – Modelling – Relationships

Exercise 01D – Modelling – Relationships

Table Step by step

Exercise 02A – Reports – Table

Exercise 02A – Reports – Table

Matrix step by step

Exercise 02B Start – Reports – Matrix

Exercise 02B – Reports – Matrix

Exercise 02C Start – Reports

Exercise 02C – Reports – Chart

Chart step by step

Slicer step by step

Filters step by step

Exercise 02D Start – Reports – Dashboard

Exercise 02D – Reports – Dashboard

Maps Step by Step

Exercise 03A, 03B, 03C Start - Maps - Group By Region

Exercise 03A – Reports – Map

Exercise 03B: Import Regions from WorldPopulation.xlsx

Exercise 03C – Reports – Map

Exercise 03A, 03B, 03C Solution - Maps - Group By Region

Unpivot Step by step

Exercise 04A Start - Power Query Import from WorldPopulation.xlsx

Exercise 04A: Power Query Import from WorldPopulation.xlsx

Exercise 04A Solution - Power Query Import from WorldPopulation.xlsx

Exercise 04B Start - Reports Chart of population, slicer _ top 10 filter

Exercise 04B: Reports Chart of population, slicer + top 10 filter

Exercise 04B Solution - Reports Chart of population, slicer _ top 10 filter