Module 1 - Welcome To Microsoft Power BI Training 1.0
Module 2 - Connecting A Dataset To Microsoft Power BI Desktop
-
How To Get Data From A Website (10:44)
-
How To Get Data From A CSV File (5:55)
-
How To Get Data From A TEXT File (3:58)
-
How To Get Data From A Excel File (4:23)
-
How To Add Additional Data And Rrefresh The Dataset (6:57)
-
Recap: What did we learn in this module? (2:03)
-
Module 2: Challenge and Solution (11:46)
Module 3 - Introduction to MYSQL
-
How To Create And Drop A Database (5:32)
-
How To Create And Drop A Table (5:25)
-
How To Populate a Table And Create A Select Statement (7:14)
-
Creating A Database And Tables For A Dashboard (9:56)
-
Connecting A MYSQL Dataset To Microsoft Power BI Desktop (5:03)
-
How To Add Additional Data To A MYSQL Table (7:10)
-
Editing The Connection Between MYSQL And Power BI Desktop (2:59)
-
Recap: What did we learn in this module? (3:52)
-
Module 3: Challenge and Solution (12:51)
Module 4 - Preparing And Transforming The Dataset In The Power Query Editor
-
DO NOT SKIP THIS: Introduction (2:50)
-
Promoting First Rows To Headers (2:15)
-
How To Work With Columns (4:33)
-
Editing Different Rows Of The Dataset (4:53)
-
Assigning A Data Type To A Column (9:42)
-
How To Replace Values In A Cell (5:07)
-
Pivot and Unpivot Columns In A Table (13:08)
-
How To Use The Format Function (8:59)
-
How To Extract Values From A Specific Cell (8:18)
-
Using The Statistics Functions (6:31)
-
Rounding The Values Of A Column (4:54)
-
Creating Custom Columns (6:22)
-
How To Duplicate Columns, Add An Index And A Conditional Column (8:50)
-
Introducing The View Tab In Power BI Desktop (4:57)
-
How To Merge Tables (20:39)
-
How To Append Tables (10:44)
-
Creating Relationships Between Tables (10:38)
-
Recap: What did we learn in this module? (4:28)
-
Module 4: Challenge and solution
Module 5 - Creating Measures And Calculations With DAX Formula's
-
Setting Up The Dataset For The DAX Foluma's (5:23)
-
How To Use The COUNT functions (16:11)
-
Dividing Columns (4:07)
-
How To Use SUM And SUMX (10:56)
-
Calculating With The Different AVERAGE Functions (2:42)
-
Calculating The MIN And MAX In A DAX Function (3:21)
-
Introduction To The CALCULATE Function In DAX (9:00)
-
How To Use The ALL Function (12:06)
-
Calculations With The RELATE Function (8:46)
-
How To Use LOOKUPVALUE (3:11)
-
Using IF Functions In Calculations (3:54)
-
Recap: What did we learn in this module? (3:51)
Module 6 - Creating Visualisations In Power BI Desktop
-
Creating Your First Visualisation (14:47)
-
Adding A Bar Chart (16:55)
-
How To Create A Line And Area Chart (12:21)
-
Creating Column Charts (13:01)
-
How To Create A Ribbon Chart (7:09)
-
Creating A Waterfall Chart (3:20)
-
How To Use The Scatter Chart (11:01)
-
Designing A Funnel (6:02)
-
How To Create A Pie And Donut Chart (13:25)
-
Creating A Treemap (13:25)
-
Using The Map Visualisations (14:12)
-
How To Create A Gauge (9:22)
-
Using Cards (11:04)
-
Creating KPI's (Key Performance Indicators) (7:10)
-
Adding A Filter To A Dashboard (13:12)
-
How To Use Tables And The Matrix (10:06)
-
Recap: What did we learn in this module? (3:46)
Module 7 - How To Style A Dashboard
Module 8 - How To Publish And Share A Dashboard
Module 9 - Building A Dashboard From Scratch
-
Starting With The End Result (7:05)
-
Getting The Data (7:26)
-
Creating Relationships Between Tables (2:32)
-
Creating The Measures For The Dashboard (12:35)
-
Formatting The Measures (5:45)
-
Creating The Pages And Add A Top Bar (10:22)
-
How To create A KPI (Key Performance Indicators) Bar (9:14)
-
Creating The Visualisations On Each Page (17:59)
-
How To Create A Drill Through To Another Page (7:05)
-
Fine Tuning The Dashboard (15:17)
-
Recap: What did we learn in this module? (4:02)
