Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Power BI Beyond the Basics: Power BI Intermediate Online Course
Section 1: Introduction
Welcome to Master of Project Academy (1:19)
How to Utilize Power BI Training?
Course Introduction (3:11)
Setting Up for Success (8:18)
Course Files
Quiz
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
Troubleshooting Relationship Issues (6:21)
Relationship Types (5:28)
Cross Filter Direction (4:36)
Interactive: Advanced Power Query & Data Modelling for TrueNorth Freight Case Study
Quiz
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
Changing Context with FILTER (3:37)
The CALCULATE Function (4:33)
Using ALL with CALCULATE (5:26)
Interactive: DAX Mastery: CALCULATE, ALL & SUMX for BrightWave Digital Case Study
Quiz
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)
Interactive: Advanced Visualizations for CrestView Properties Portfolio Case Study
Quiz
Section 7: The Power BI Service
Inviting Others to a Shared Workspace (1:53)
Creating a Shared Workspace in Power BI Service (4:51)
Reports vs Dashboards (1:59)
Pinning Visualizations to the Dashboard (7:10)
Setting up Scheduled Refreshes (5:14)
Quiz
Section 8: Orders Dashboard Example - Preparation
Report Requirements (3:59)
Orders Dashboard Example (3:30)
Importing Order Data (1:25)
Quiz
Section 9: Orders Dashboard Example - Transformation
Creating Lookup Tables (5:38)
Transforming Order Data in Power Query (1:55)
Merging Queries (5:36)
Creating a Dates Table (11:10)
Creating DAX Measures (10:57)
Quiz
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
Publishing the Report to the Power BI Service (3:15)
Pinning Media Tiles to Dashboard (6:32)
Interactive: Capstone: End-to-End Dashboard: Ember & Vine Restaurant Chain
Quiz
Section 12: Course Close
Course Close (1:50)
Tip #1 - Join LinkedIn Community
Join LinkedIn Community & Follow Latest Updates
How to Submit a PDU Claim (For Retaining PMP Certificate)
How to Submit PDUs
Bonus Lecture - Discount for our paid courses
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
Important Notice About Certificate of Completion
Interactive: Advanced Power Query & Data Modelling for TrueNorth Freight Case Study
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock