Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Up & Running with Power BI Desktop
Getting Started
Course Structure & Outline (1:43)
DOWNLOAD: Course Resources
Introducing the Adventure Works Project (3:02)
Setting Expectations (2:21)
Introducing Power BI Desktop
Introduction (0:26)
Meet Power BI (5:30)
Downloading Power BI & Adjusting Settings (4:05)
IMPORTANT: Regional Settings
The Power BI Interface & Workflow (2:34)
Helpful Resources (1:44)
UPDATE: New Power BI Ribbon (2020) (7:15)
QUIZ: Introducing Power BI Desktop
Connecting & Shaping Data
Introduction (0:30)
Types of Data Connectors (3:53)
The Query Editor (4:28)
Basic Table Transformations (10:03)
Text-Specific Tools (14:54)
Number-Specific Tools (8:37)
Date-Specific Tools (8:53)
PRO TIP: Creating a Rolling Calendar (7:08)
Index & Conditional Columns (8:30)
Grouping & Aggregating Data (7:33)
Pivoting & Unpivoting (8:04)
Merging Queries (6:41)
Appending Queries (6:29)
PRO TIP: Appending Files from a Folder (7:38)
Data Source Settings (5:05)
Query Refresh Settings (3:06)
Additional Data Types & Categories (7:19)
Defining Hierarchies (4:35)
PRO TIP: Importing Models from Excel (5:40)
Data Connection Best Practices (2:09)
QUIZ: Connecting & Shaping Data
HOMEWORK: Connecting & Shaping Data
HOMEWORK SOLUTION: Connecting & Shaping Data (12:36)
Creating a Data Model
Introduction (0:19)
What is a "Data Model"? (5:17)
Database Normalization (4:07)
Data Tables vs. Lookup Tables (7:25)
Relationships vs. Merged Tables (2:31)
Creating Table Relationships (4:34)
"Snowflake" Schemas (3:09)
Managing & Editing Relationships (2:44)
Active vs. Inactive Relationships (2:45)
Relationship Cardinality (5:08)
Connecting Multiple Data Tables (8:26)
Understanding Filter Flow (6:33)
Two-Way Filters (Use with Caution!) (13:16)
Hiding Fields from Report View (4:15)
UPDATE: New Model View (8:32)
Data Model Best Practices (1:34)
QUIZ: Creating a Data Model
HOMEWORK: Creating a Data Model
HOMEWORK SOLUTION: Creating a Data Model (14:09)
Adding Calculated Fields with DAX
Introduction (0:32)
Meet DAX (1:03)
Intro to Calculated Columns (7:33)
Intro to Measures (2:51)
RECAP: Calculated Columns vs. Measures (1:34)
Adding Columns & Measures (3:12)
Implicit vs. Explicit Measures (6:27)
Filter Context Examples (8:07)
Step-by-Step Measure Calculation (2:39)
DAX Syntax & Operators (3:49)
Common DAX Function Categories (3:16)
Basic Date & Time Functions (12:24)
Logical Functions (10:06)
Text Functions (9:24)
Joining Data with RELATED (8:54)
Basic Math & Stats Functions (14:01)
COUNT Functions (7:46)
IMPORTANT: Order Line Items (6:21)
The CALCULATE Function (13:06)
CALCULATE & ALL (9:25)
CALCULATE & FILTER (9:37)
Iterator ("X") Functions (12:27)
DAX Time Intelligence Formulas (12:29)
DAX Best Practices (2:57)
QUIZ: Adding Calculated Fields
HOMEWORK: Adding Calculated Fields
HOMEWORK SOLUTION: Adding Calculated Fields (15:05)
Visualizing Data with Reports
Introduction (0:29)
The "Report" View (5:33)
Adding Simple Objects (3:07)
Inserting Basic Charts & Visuals (5:47)
UPDATE: Conditional Formatting (2:58)
Formatting Options (9:51)
Report Filtering Options (11:09)
DEMO: Matrix Visuals (6:38)
DEMO: Date Slicers (7:14)
DEMO: Cards & KPIs (9:24)
DEMO: Text Cards (6:14)
DEMO: Map Visuals (7:15)
DEMO: Treemaps (3:21)
DEMO: Line & Area Charts (6:23)
DEMO: Trend Lines & Forecasts (5:36)
DEMO: Gauge Charts (6:43)
Editing Report Interactions (6:38)
Adding Drillthrough Filters (5:08)
Adding Report Bookmarks (5:49)
"What-If" Parameters (11:47)
Managing & Viewing Roles (5:27)
PREVIEW: Custom Visuals (Log-In Required) (2:05)
PREVIEW: Designing for Phone vs. Desktop (2:54)
PREVIEW: Publishing to Power BI Service (2:27)
Data Visualization Best Practices (1:35)
QUIZ: Visualizing Data with Reports
HOMEWORK: Visualizing Data with Reports
HOMEWORK SOLUTION: Visualizing Data with Reports (7:22)
NEW: Artificial Intelligence (AI) Visuals
The Q&A Visual (10:54)
The Key Influencers Visual (Part 1) (12:34)
The Key Influencers Visual (Part 2) (5:11)
IMPORTANT: Correlation vs. Causation (4:24)
The Decomposition Tree Visual (8:59)
Wrapping Up
Resources & Next Steps (1:41)
More from Maven Analytics
REFERENCE: Monthly Power BI Updates
The CALCULATE Function
Complete and Continue