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)
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)
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)
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)
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
Creating Additional Columns
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock