Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI - Beyond the Basics
Section 1: Introduction
Course Introduction (3:11)
Setting Up for Success (8:18)
DOWNLOAD ME: Course Instructor Files
Section 2: Importing and Transforming Data in Power Query
Importing Excel Data Files from a Folder (4:21)
Combining Files and Removing Columns (4:33)
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)
Section 3: Data Modelling
Troubleshooting Relationship Issues (6:21)
Relationship Types (5:28)
Cross Filter Direction (4:36)
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)
Section 5: DAX - CALCULATE Function
The CALCULATE Function (4:33)
Changing Context with FILTER (3:37)
Using ALL with CALCULATE (5:26)
Section 6: Visualizations
Visualizations (8:37)
Tables vs Matrix Tables (6:24)
Formatting Visualizations - Part 1 (6:46)
Formatting Visualizations - Part 2 (3:07)
Conditional Formatting (12:41)
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)
Section 7: The Power BI Service
Creating a Shared Workspace in Power BI Service (4:51)
Inviting Others to a Shared Workspace (1:53)
Reports vs Dashboards (1:58)
Pinning Visualizations to the Dashboard (7:09)
Setting up Scheduled Refreshes (5:14)
Section 8: Orders Dashboard Example - Preparation
Orders Dashboard Example (3:30)
Report Requirements (3:59)
Importing Order Data (1:25)
Section 9: Orders Dashboard Example - Transformation
Transforming Order Data in Power Query (1:54)
Creating Lookup Tables (5:38)
Merging Queries (5:36)
Creating a Dates Table (11:10)
Creating DAX Measures (10:57)
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:17)
Matrix Table: Count of Customers by Type and Status (4:31)
Adding Conditional Formatting (2:16)
Section 11: Orders Dashboard Example: Dashboard
Publishing the Report to the Power BI Service (3:15)
Pinning Media Tiles to Dashboard (6:32)
Section 12: Course Close
Course Close (1:50)
Course Quiz & Certificate of Completion
Splitting and Merging Columns
Complete and Continue