×

TLGPBIE16DAX - Introduction to DAX for Excel 2016 Users - Level 4

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

Click here to print this page »

Prerequisites


Data Model Design using Excel 2016 - Level 3

Detailed Class Syllabus


Lesson 1 : Basic DAX Functionality


Review Of Calculated Columns
PivotTable Functions
Review Of Measures
Rules Of DAX Measures
Evaluation Context
Formatting DAX Code

Lesson 2 : Controlling Content & Values


Controlling Values
Switch Function
Error Handling

Lesson 3 : Context Control Functions


Iterative Functions
Filter Function
All Function
Earlier Function
Calculate Function

Lesson 4 : Contexts In Relationships


Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Values Function

Lesson 5 : Time Intelligence Calculations


Working with Date Tables
Calculating Operating Periods
Working With Missing Periods
DAX Date Functions
Advanced Date Functions
Prior Year Functions
Moving Averages

Lesson 6 : Appendix: Advanced Concepts


Circular Dependencies
Controlling Totals
Advanced Hierarchy Concept
Additional uses of the ALL function

Lesson 7 : Appendix: DAX Dashboard Techniques


Parameter Tables
Banding
Ranking
Advanced Slicer Techniques