Example Curriculum
Introduction
Available in
days
days
after you enroll
Section 1: Power BI 101
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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?
Available in
days
days
after you enroll