Duration: 2 Days
Hands-On
All lessons will include hands-on activities that the students can perform designed to reinforce the concepts delivered in the course by using query examples including outputs with descriptions.
Course Outline
Lesson 1 : DAX Concepts – A Review
- What is DAX?
- Basic DAX Functionality
- Controlling Content & Values
- Context Control Functions
Lesson 2 : Time Intelligence Calculations
- Introduction to Time Intelligence
- Building a Data Table
- Using CALENDAR and CALENDARAUTO
- Working with Multiple Dates
- Time Intelligence Functions
- Aggregating and Comparing Over Time
- Advanced Time Intelligence
Lesson 3 : Advanced Table Functions
- Understanding EVALUATE
- Understanding FILTER Functions
- Understanding PROJECTION Functions
- Understanding Grouping/Joining Functions
Lesson 4 : Advanced Evaluation Context
- Understanding ALLSELECTED
- Understanding KEEPFILTERS
- Understanding AUTOEXISTS
- Understanding Expanded Tables
- Understanding the ALL Function
- Understanding Linage
- Using Advanced SETFILTER
Lesson 5 : Handling hierarchies
- Computing Percentages Over Hierarchies
- Handling Parent-Child Hierarchies
- Handling Unary Operators
Lesson 6 : Advanced Performance
- Optimizing Data Models
- Gathering Information About the Data Model
- Denormalization
- Columns Cardinality
- Calculated Columns
- Optimizing Column Storage
To Hire a proven AMS Course Author and or Subject Matter Expert who teaches this class, Call 800-798-3901 Today!