Course Highlights
  • Master Data Analysis Expressions (DAX) for Power BI Desktop
  • Analyze real-world projects & business intelligence use cases
  • Learn the same tools used by top analytics & business intelligence professionals
  • Test your skills with hands-on demos & assignments (with step-by-step solutions)
Curriculum

5 Topics
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Setting Expectations
Helpful Resources

4 Topics
Introduction
Data Modeling Fundamentals
Basic DAX Review
QUIZ: Prerequisite Skills Review

4 Topics
Introducing the Course Project
NOTE: Power BI Options & Settings
Maven Roasters Data Model Setup
ASSIGNMENT: Getting Familiar with the Data Model

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

11 Topics
Introduction
DAX Shortcuts
Formatting Best Practices
DAX Evaluation Order
Commenting Your Code
PRO TIP: Dedicated Measure Table
Error Handling
Creating & Using DAX Variables
Variable Evaluation Order
PRO TIP: Using Variables to Test & Debug DAX
QUIZ: Tips & Best Practices

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

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

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

8 Topics
Introduction
CROSSJOIN
UNION
EXCEPT
INTERSECT
ASSIGNMENT: Calculated Table Joins
SOLUTION: Calculated Table Joins
QUIZ: Calculated Table Joins

14 Topics
Introduction
Physical vs. Virtual Relationships
RELATED
RELATEDTABLE
ASSIGNMENT: RELATED & RELATEDTABLE
SOLUTION: RELATED & RELATEDTABLE
USERELATIONSHIPS
CROSSFILTER
ASSIGNMENT: CROSSFILTER
SOLUTION: CROSSFILTER
TREATAS
ASSIGNMENT: Sales Targets (TREATAS)
SOLUTION: Sales Targets (TREATAS)
QUIZ: Relationship Functions

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

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

5 Topics
Introduction
Power BI Performance Analyzer
PRO TIP: Copy Query
DAX Studio
DAX Optimization Workflow

1 Topic
BONUS LESSON

  Write a Review

Microsoft Power BI Desktop: Advanced DAX for Data Analysis

Go to Paid Course