• Course Introduction Free
  • Course Structure & Outline Free
  • Introducing the Course Project Free
  • Setting Expectations Free

  • Benchmark Assessment Free

  • Section Introduction Free
  • Meet Power BI Desktop Free
  • Downloading Power BI Pro
  • IMPORTANT: Adjusting Settings Pro
  • Power BI Desktop Interface & Workflow Pro
  • Resources & Monthly Updates Pro
  • QUIZ: Introducing Power BI Desktop Pro

  • Section Introduction Pro
  • Power BI Front-End vs. Back-End Pro
  • Types of Data Connectors Pro
  • The Power Query Editor Pro
  • Basic Table Transformations Pro
  • ASSIGNMENT: Table Transformations Pro
  • SOLUTION: Table Transformations Pro
  • PRO TIP: Storage & Connection Modes Pro
  • Connecting to a Database Pro
  • Extracting Data from the Web Pro
  • Data QA & Profiling Tools Pro
  • Text Tools Pro
  • ASSIGNMENT: Text-Specific Tools Pro
  • SOLUTION: Text-Specific Tools Pro
  • Numerical Tools Pro
  • ASSIGNMENT: Numerical Tools Pro
  • SOLUTION: Numerical Tools Pro
  • Date & Time Tools Pro
  • Change Type with Locale Pro
  • PRO TIP: Rolling Calendars Pro
  • ASSIGNMENT: Calendar Tables Pro
  • SOLUTION: Calendar Tables Pro
  • Index & Conditional Columns Pro
  • Calculated Column Best Practices Pro
  • Grouping & Aggregating Pro
  • Pivoting & Unpivoting Pro
  • Merging Queries Pro
  • Appending Queries Pro
  • PRO TIP: Appending Files from a Folder Pro
  • Data Source Settings Pro
  • PRO TIP: Data Source Parameters Pro
  • Refreshing Queries Pro
  • PRO TIP: Importing Excel Models Pro
  • Power Query Best Practices Pro
  • QUIZ: Connecting & Shaping Data Pro

  • Section Introduction Pro
  • Data Modeling 101 Pro
  • Database Normalization Pro
  • Fact & Dimension Tables Pro
  • Primary & Foreign Keys Pro
  • Relationships vs. Merged Tables Pro
  • Creating Table Relationships Pro
  • Managing & Editing Relationships Pro
  • Star & Snowflake Schemas Pro
  • ASSIGNMENT: Table Relationships Pro
  • SOLUTION: Table Relationships Pro
  • PRO TIP: Active & Inactive Relationships Pro
  • Relationship Cardinality Pro
  • Connecting Multiple Fact Tables Pro
  • Filter Context & Filter Flow Pro
  • Bi-Directional Filters & Ambiguity Pro
  • Hiding Fields from Report View Pro
  • ASSIGNMENT: Filter Flow Pro
  • SOLUTION: Filter Flow Pro
  • PRO TIP: Model Layouts Pro
  • Data Formats & Categories Pro
  • Creating Hierarchies Pro
  • ASSIGNMENT: Hierarchies Pro
  • SOLUTION: Hierarchies Pro
  • Data Model Best Practices Pro
  • QUIZ: Creating a Data Model Pro

  • Section Introduction Pro
  • Data Analysis Expressions 101 Pro
  • DAX vs. M Languages Pro
  • Intro to DAX Calculated Columns Pro
  • Intro to DAX Measures Pro
  • Implicit vs. Explicit Measures Pro
  • Quick Measures Pro
  • RECAP: Calculated Columns vs. Measures Pro
  • PRO TIP: Dedicated Measure Tables Pro
  • Understanding Filter Context Pro
  • Step-by-Step DAX Measure Calculation Pro
  • DAX Syntax & Operators Pro
  • Common DAX Function Categories Pro
  • Basic Math & Stats Functions Pro
  • Counting Functions Pro
  • ASSIGNMENT: Math & Stats Functions Pro
  • SOLUTION: Math & Stats Functions Pro
  • Conditional & Logical Functions Pro
  • The SWITCH Function Pro
  • ASSIGNMENT: Logical Functions Pro
  • SOLUTION: Logical Functions Pro
  • Common Text Functions Pro
  • ASSIGNMENT: Text Functions Pro
  • SOLUTION: Text Functions Pro
  • Basic Date & Time Functions Pro
  • ASSIGNMENT: Date & Time Pro
  • SOLUTION: Date & Time Pro
  • Joining Data with RELATED Pro
  • The CALCULATE Function Pro
  • DAX Measure Totals Pro
  • ASSIGNMENT: CALCULATE Pro
  • SOLUTION: CALCULATE Pro
  • The ALL Function Pro
  • ASSIGNMENT: CALCULATE & ALL Pro
  • SOLUTION: CALCULATE & ALL Pro
  • The FILTER Function Pro
  • Iterator (X) Functions Pro
  • ASSIGNMENT: Iterators Pro
  • SOLUTION: Iterators Pro
  • Time Intelligence Patterns Pro
  • ASSIGNMENT: Time Intelligence Pro
  • SOLUTION: Time Intelligence Pro
  • DAX Best Practices Pro
  • QUIZ: Calculated Fields with DAX Pro

  • Section Introduction Pro
  • The 3 Key Questions Pro
  • Dashboard Design Framework Pro
  • Sketching the Dashboard Layout Pro
  • Adding Report Pages & Objects Pro
  • Naming & Grouping Objects Pro
  • Cards & Multi-Row Cards Pro
  • ASSIGNMENT: Cards Pro
  • SOLUTION: Cards Pro
  • Building & Formatting Charts Pro
  • Line Charts Pro
  • PRO TIP: Trend Lines & Forecasts Pro
  • ASSIGNMENT: Line Chart & Trend Pro
  • SOLUTION: Line Chart & Trend Pro
  • KPI Cards Pro
  • Bar & Donut Charts Pro
  • Basic Filtering Options Pro
  • ASSIGNMENT: Donuts & Filters Pro
  • SOLUTION: Donuts & Filters Pro
  • Table & Matrix Visuals Pro
  • Conditional formatting Pro
  • Top N Filtering Pro
  • ASSIGNMENT: Tables Pro
  • SOLUTION: Tables Pro
  • Top N Text Cards Pro
  • ASSIGNMENT: Top N Text Cards Pro
  • SOLUTION: Top N Text Cards Pro
  • Map Visuals Pro
  • Report Slicers Pro
  • ASSIGNMENT: Slicers Pro
  • SOLUTION: Slicers Pro
  • PRO TIP: HASONEVALUE Pro
  • Gauge Charts Pro
  • PRO TIP: Advanced Conditional Formatting Pro
  • Area Charts Pro
  • Drill Up & Drill Down Pro
  • ASSIGNMENT: Drill Up & Drill Down Pro
  • SOLUTION: Drill Up & Drill Down Pro
  • Drillthrough Filters Pro
  • Editing Report Interactions Pro
  • ASSIGNMENT: Report Interactions Pro
  • SOLUTION: Report Interactions Pro
  • Adding Bookmarks Pro
  • ASSIGNMENT: Bookmarks Pro
  • SOLUTION: Bookmarks Pro
  • PRO TIP: Custom Navigation Buttons Pro
  • PRO TIP: Slicer Panels Pro
  • Numeric Range Parameters Pro
  • Fields Parameters Pro
  • ASSIGNMENT: Fields Parameters Pro
  • SOLUTION: Fields Parameters Pro
  • PRO TIP: Custom Tool Tips Pro
  • Importing Custom Visuals Pro
  • Managing & Viewing Roles Pro
  • Mobile Layouts Pro
  • PREVIEW: Publishing to Power BI Service Pro
  • Data Visualization Best Practices Pro
  • QUIZ: Visualizing Data with Reports Pro

  • Section Introduction Pro
  • Anomaly Detection Pro
  • Smart Narratives Pro
  • Q&A Visuals Pro
  • Decomposition Trees Pro
  • Key Influencers Pro
  • ASSIGNMENT: Upload the Project to Showcase Pro

  • Section Introduction Pro
  • The Optimize Ribbon Pro
  • Pausing Visuals Pro
  • Optimization Presets Pro
  • Applying All Slicers Pro
  • Performance Analyzer Pro
  • External Tools Pro

  • About this Section Pro
  • Calculation Groups (Oct 2023) Pro
  • New Card Visual (Nov 2023) Pro
  • DAX Query View (Nov 2023) Pro
  • Button Slicer (Nov 2023) Pro
  • List Slicer (May 2025) Pro
  • Visual Calculations (Feb 2024) Pro
  • DAX INFO.VIEW Functions (Oct 2024) Pro
  • AI Documentation with TMDL (Jan 2025) Pro

  • Project Introduction Pro
  • Part 1: Connecting & Shaping Data Pro
  • Part 2: Creating the Data Model Pro
  • Part 3: Adding DAX Measures Pro
  • Part 4: Building the Report Pro

  • Final Assessment Pro

  • Course Feedback Survey Pro
  • Share the Love Pro
  • Next Steps Pro