Slicers and Filter | Master of Project Academy

Autoplay
Autocomplete

Previous Lesson 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

Teach online with

Slicers and Filter

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll to Unlock