Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI Bootcamp: Zero to Mastery
Introduction
Power BI Bootcamp: Zero to Mastery (2:38)
Exercise: Meet Your Classmates and Instructor
ZTM Plugin + Understanding Your Video Player
Course Resources
Set Your Learning Streak Goal
Section 1: Power BI 101
Introducing Power BI (7:16)
Navigating the Power BI Interface (4:51)
Installing and Configuring Power BI (4:42)
ETL with Power BI (9:37)
Fetching Data from Databases (7:33)
Introducing Power Query (9:37)
Applying Basic Transformations (7:59)
Editing Transformations (10:57)
Introducing the UFO Sightings Project (1:13)
Exercise: UFO Sightings Project - Part 1
Solution: UFO Sightings Project - Part I (6:02)
Numeric Transformations (12:29)
Date Transformations (3:30)
Text Transformations (15:15)
Conditional Transformations (13:31)
Exercise: UFO Sightings Project - Part 2
Solution: UFO Sightings Project - Part 2 (11:38)
Introducing Matrix Visualizations (15:37)
Adding Layers to Matrix Visualizations (11:07)
Navigating Matrix Visualizations (5:31)
Formatting Visualizations (8:29)
Data Bars (6:06)
Conditional Formatting Rules (9:53)
Exercise: UFO Sightings Project - Part 3
Solution: UFO Sightings Project - Part 3 (12:46)
Introducing Measures (4:45)
Creating Your First Measure (10:30)
Customizing Measures (9:33)
Exercise: UFO Sightings Project - Part 4
Solution: UFO Sightings Project - Part 4 (7:12)
Let's Have Some Fun (+ Free Resources)
Section 2: Visualizing Data with Power BI
Column Charts (9:35)
Column Chart Variations (5:04)
Bar Charts (8:05)
Line and Area Charts (7:22)
Combo Charts (13:14)
Visualizing Proportionality (11:00)
Exercise: UFO Sightings Project - Part 5
Solution: UFO Sightings Project - Part 5 (7:46)
Unlimited Updates
Customizing Chart Interactions (11:08)
Customizing Chart Formatting (11:02)
Map Charts (11:19)
Building Dashboards (13:47)
Formatting the Report Environment. (6:17)
Exercise: UFO Sightings Project - Part 6
Solution: UFO Sightings Project - Part 6 (12:31)
Filtering Individual Visualizations (11:18)
Filtering Multiple Visualizations (11:29)
Slicers (8:18)
Date Slicers (6:28)
Exercise: UFO Sightings Project - Part 7
Solution: UFO Sightings Project - Part 7 (10:04)
Course Check-In
Section 3: Advanced Power Query
Previewing Data (11:57)
Configuring Refresh Options (4:33)
Merging Datasets (15:10)
Appending Datasets (6:28)
Aggregate Calculations (13:00)
Introducing Oodles of Noodles (Meal Kit Delivery Service Project) (1:25)
Exercise: Meal Kit Delivery Service Project - Part 1
Solution: Meal Kit Delivery Service Project - Part 1 (10:41)
Introducing the M Language (11:16)
M Behind the Scenes (4:33)
Creating Custom Columns with M (11:59)
Creating Custom Filters with M (7:23)
Using M Functions (Build a Calendar Table) (10:57)
Exercise: Meal Kit Delivery Service Project - Part 2
Solution: Meal Kit Delivery Service Project - Part 2 (13:10)
Implement a New Life System
Section 4: Modeling Data in Power BI
Introducing the Model View (12:44)
Understanding Relationships (10:46)
Relationships in Power BI - Part 1 (9:57)
Relationships in Power BI - Part 2 (10:00)
Using Related Data in Visuals (8:30)
Exploring Filter Context (11:08)
Calendar Tables (11:00)
Data Modeling Pitfalls (9:47)
Multiple Data Tables (8:24)
Two-Way Relationships (14:09)
Exercise: Meal Kit Delivery Service Project - Part 3
Solution: Meal Kit Delivery Service Project - Part 3 (8:34)
Exercise: Imposter Syndrome (2:55)
Section 5: Analyzing Data with DAX
Calculated Columns with DAX (14:03)
The IF Function (5:26)
SWITCH 101 (7:53)
SWITCH 201 (10:59)
The RELATED Function (11:32)
Exercise: Meal Kit Delivery Service Project - Part 4
Solution: Meal Kit Delivery Service Project - Part 4
Using DAX Functions in Measures (15:33)
The CALCULATE Function (12:02)
Going Deeper with CALCULATE (9:31)
The ALL Function (14:14)
Exercise: Meal Kit Delivery Service Project - Part 5
Solution: Meal Kit Delivery Service Project - Part 5
Section 6: Advanced DAX
Introducing Time Intelligence Functions (14:37)
The ISBLANK Function (5:05)
The DATEADD Function (14:40)
The DATESINPERIOD Function (17:40)
Solution: Meal Kit Delivery Service Project - Part 6
Exercise: Meal Kit Delivery Service Project - Part 6
Formatting and Commenting Code (12:20)
Variables (12:06)
The X Functions (13:17)
The RANKX Function (7:25)
The TOPN Function (11:35)
Creating a Measure Table (13:52)
Data Modeling and Analysis Best Practices (8:06)
Exercise: Meal Kit Delivery Service Project - Part 7
Solution: Meal Kit Delivery Service Project - Part 7
Section 7: Advanced Visualizations
Card Visuals (10:13)
Single-Value Cards (6:19)
KPI Cards (7:48)
Gauge Charts (15:58)
Analyzing Time Series Data (12:15)
Changing Measures Dynamically (14:08)
What-If Parameters (14:58)
Bookmarks (10:58)
Drillthrough (11:13)
Mobile View (6:53)
Exercise: Meal Kit Delivery Service Project - Part 8
Solution #1: Meal Kit Subscription Service Project - Part 8 (13:16)
Solution #2: Meal Kit Subscription Service Project - Part 8 (9:50)
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Adding Layers to Matrix Visualizations
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures