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
The CALCULATE Function
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