• Course Structure & Outline Free
  • Setting Expectations Free
  • Helpful Resources Free

  • Benchmark Assessment Free

  • Introduction Free
  • Data Modeling Fundamentals Free
  • Basic DAX Free
  • QUIZ: Prerequisite Skills Review Free

  • Introducing the Course Project Free
  • NOTE: Power BI Options & Settings Free
  • Maven Roasters Data Model Setup Free
  • ASSIGNMENT: Getting to Know Maven Roasters Free

  • Introduction Free
  • Formula & Storage Engines Pro
  • Query Evaluation In Depth Pro
  • Data & Storage Types Pro
  • VertiPaq Columnar Data Structure Pro
  • VertiPaq Compression & Encoding Pro
  • Value Encoding Pro
  • Hash Encoding Pro
  • Run Length Encoding Pro
  • VertiPaq Relationships Pro
  • Summary: DAX Engines Pro
  • QUIZ: The DAX Engines Pro

  • Introduction Pro
  • Shortcuts Pro
  • Formatting Best Practices Pro
  • DAX Evaluation Order Pro
  • Commenting Code Pro
  • PRO TIP: Dedicated Measure Table Pro
  • Error Handling Pro
  • Creating & Using Variables Pro
  • Variable Evaluation Order Pro
  • PRO TIP: Using Variables for Debugging Pro
  • QUIZ: Tips & Best Practices Pro

  • Introduction Pro
  • Common Scalar Functions Pro
  • Aggregation Functions Pro
  • PRO TIP: SUM & SUMX Pro
  • Rounding Functions Pro
  • ASSIGNMENT: Rounding Functions Pro
  • SOLUTION: Rounding Functions Pro
  • Information Functions Pro
  • Conversion Functions Pro
  • ASSIGNMENT: Conversion Functions Pro
  • SOLUTION: Conversion Functions Pro
  • Logical Functions: SWITCH Pro
  • Logical Functions: COALESCE Pro
  • ASSIGNMENT: Logical Functions Pro
  • SOLUTION: Logical Functions Pro
  • QUIZ: Scalar Functions Pro

  • Introduction Pro
  • Expanded Tables Pro
  • Context Transition Pro
  • Evaluation Order Pro
  • CALCULATE Modifiers Pro
  • REMOVEFILTERS Pro
  • KEEPFILTERS Pro
  • ASSIGNMENT: Advanced CALCULATE Pro
  • SOLUTION: Advanced CALCULATE Pro
  • PRO TIP: Common CALCULATE Patterns Pro
  • QUIZ: Advanced CALCULATE Pro

  • Introduction Pro
  • Common Table & Filter Functions Pro
  • Review: Calculated Tables Pro
  • DISTINCT Pro
  • VALUES Pro
  • ASSIGNMENT: VALUES & DISTINCT Pro
  • SOLUTION: VALUES & DISTINCT Pro
  • SELECTEDVALUE Pro
  • ALLEXCEPT Pro
  • ASSIGNMENT: ALLEXCEPT Pro
  • SOLUTION: ALLEXCEPT Pro
  • ALLSELECTED Pro
  • ASSIGNMENT: ALLSELECTED Pro
  • SOLUTION: ALLSELECTED Pro
  • SELECTCOLUMNS Pro
  • ADDCOLUMNS Pro
  • SUMMARIZE Pro
  • ASSIGNMENT: SUMMARIZE Pro
  • SOLUTION: SUMMARIZE Pro
  • Generating Data Pro
  • ROW Pro
  • DATATABLE Pro
  • GENERATESERIES Pro
  • Table Constructor Pro
  • ASSIGNMENT: Generating Data Pro
  • SOLUTION: Generating Data Pro
  • QUIZ: Table & Filter Functions Pro

  • Introduction Pro
  • CROSSJOIN Pro
  • UNION Pro
  • EXCEPT Pro
  • INTERSECT Pro
  • ASSIGNMENT: Calculated Table Joins Pro
  • SOLUTION: Calculated Table Joins Pro
  • QUIZ: Calculated Table Joins Pro

  • Introduction Pro
  • Physical vs. Virtual Relationships Pro
  • RELATED Pro
  • RELATEDTABLE Pro
  • ASSIGNMENT: RELATED & RELATEDTABLE Pro
  • SOLUTION: RELATED & RELATEDTABLE Pro
  • USERELATIONSHIP Pro
  • CROSSFILTER Pro
  • ASSIGNMENT: CROSSFILTER Pro
  • SOLUTION: CROSSFILTER Pro
  • TREATAS Pro
  • ASSIGNMENT: Sales Targets (TREATAS) Pro
  • SOLUTION: Sales Targets (TREATAS) Pro
  • QUIZ: Relationship Functions Pro

  • Introduction Pro
  • Review: Basic Iterators Pro
  • Iterator Cardinality Pro
  • CONCATENATEX Pro
  • PRO TIP: Adding Dynamic Labels Pro
  • ASSIGNMENT: CONCATENATEX Pro
  • SOLUTION: CONCATENATEX Pro
  • AVERAGEX Pro
  • PRO TIP: Moving Averages Pro
  • ASSIGNMENT: Moving Averages Pro
  • SOLUTION: Moving Averages Pro
  • RANKX Pro
  • ASSIGNMENT: RANKX Pro
  • SOLUTION: RANKX Pro
  • QUIZ: Iterator Functions Pro

  • Introduction Pro
  • Automatic Date Tables Pro
  • Date Table Requirements Pro
  • CALENDAR Pro
  • CALENDARAUTO Pro
  • PRO TIP: Building a Reusable Date Table Pro
  • Date Formatting Pro
  • ASSIGNMENT: Date Formatting Pro
  • SOLUTION: Date Formatting Pro
  • Common Time Intelligence Functions Pro
  • PARALLELPERIOD Pro
  • PREVIOUSQUARTER Pro
  • SAMEPERIODLASTYEAR Pro
  • ASSIGNMENT: Time Periods Pro
  • SOLUTION: Time Periods Pro
  • Week-based Calculations Pro
  • Previous Fiscal Week Pro
  • Fiscal Period to Date Pro
  • Fiscal Previous Period Pro
  • ASSIGNMENT: 4-5-4 Calendar Pro
  • SOLUTION: 4-5-4 Calendar Pro
  • QUIZ: Advanced Time Intelligence Pro

  • Introduction Pro
  • Performance Analyzer Pro
  • PRO TIP: Copy Query Pro
  • DAX Studio Pro
  • Optimization Workflow Pro

  • Final Assessment Pro

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