IIRF Online > Business > Business Analytics & Intelligence > Data Analysis Expressions (DAX) > Microsoft Power BI Desktop: Advanced DAX for Data Analysis
Microsoft Power BI Desktop: Advanced DAX for Data Analysis by Udemy
Master advanced DAX in Power BI for data modeling, analytics & business intelligence, with a top Power BI instructor!
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)
Skills you will learn!
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
Microsoft Power BI Desktop: Advanced DAX for Data Analysis
Related Data Analysis Expressions (DAX) Courses
Thank You!
Your review has been submitted successfully.