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.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


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
Advanced Slicer Techniques