Section 1: Introduction
Section 2: Importing and Transforming Data in Power Query
-
Combining Files and Removing Columns (4:33)
-
Importing Excel Data Files from a Folder (4:21)
-
Splitting and Merging Columns (4:55)
-
Applying Data Types (3:47)
-
Importing Text and CSV Files (7:11)
-
Relationships and Lookup Tables (6:41)
-
Duplicate vs Reference (7:07)
-
Creating a Lookup Table (3:28)
-
Creating Index Columns (3:43)
-
Merging Queries (5:19)
-
Enable/Disable Load and Report Refresh (3:22)
-
Advanced Editor (4:49)
-
Resolving Data Import Errors (5:07)
-
Organizing Queries into Groups (3:00)
-
Quiz
Section 3: Data Modelling
Section 4: DAX - Essential Skills
-
Measures vs Calculated Columns (10:56)
-
Creating a Date Table with DAX (6:45)
-
Creating Additional Columns (5:16)
-
Creating Conditional Columns (2:21)
-
Marking Table as a Date Table (2:48)
-
Using ROUNDUP to Extract Quarters (2:06)
-
Creating Quick Measures (5:41)
-
Creating a Key Measures Table (3:27)
-
Aggregation Methods (5:12)
-
Using SUMX (5:47)
-
Quiz
Section 5: DAX - CALCULATE Function
Section 6: Visualizations
-
Tables vs Matrix Tables (6:24)
-
Visualizations (8:37)
-
Formatting Visualizations - Part 1 (6:46)
-
Formatting Visualizations - Part 2 (3:07)
-
Conditional Formatting (12:42)
-
Column and Line Charts (13:55)
-
Card Visualizations (5:51)
-
Map Charts (9:41)
-
The Gauge Visualization (9:38)
-
Slicers and Filter (8:28)
-
Applying Design Elements (7:54)
-
Quiz
Section 7: The Power BI Service
Section 8: Orders Dashboard Example - Preparation
Section 9: Orders Dashboard Example - Transformation
Section 10: Orders Dashboard Example: Report
-
Adding a Report Title (9:50)
-
Report Navigation with Buttons and Bookmarks (10:23)
-
Card Visualizations and Filtering (12:39)
-
Line Chart: Count of Male vs Female Customers (7:13)
-
Stacked Column Chart: Total Revenue by Region (6:00)
-
Treemap Chart: Count of Orders by Year/Month (5:59)
-
Funnel Chart: Age Distribution (6:18)
-
Matrix Table: Count of Customers by Type and Status (4:32)
-
Adding Conditional Formatting (2:16)
-
Quiz
Section 11: Orders Dashboard Example: Dashboard
Section 12: Course Close
Tip #1 - Join LinkedIn Community
How to Submit a PDU Claim (For Retaining PMP Certificate)
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
