This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Power BI Training: Introduction Course
Module 1 - Welcome To Microsoft Power BI Training 1.0
Get Acces To The Stella Data Analytics Private Student Community (2:49)
Prepare Power Bi Desktop For The Course (3:15)
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
How to add a theme (9:06)
Adding More Flexible Titles To The Visualisation (4:09)
Creating Buttons, Images and Text Boxes (17:15)
Recap: What did we learn in this module? (1:37)
Module 8 - How To Publish And Share A Dashboard
How To Publish A Report To The Workspace (4:02)
Pushing Your Report To The Power BI App (7:04)
Recap: What did we learn in this module? (1:45)
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)
Adding A Filter To A Dashboard
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock