Data Analysis Expressions (DAX)
Course Objective:
This course is intended to expose the students to the technology of DAX and to familiarize them with functionality of DAX at an advanced level to produce sophisticated DAX calculations by use of the functions of DAX. This course is based on Excel Professional 2013 or higher.
Target Audience
This course is intended for Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling.
Training Methodologies
- Training is hands-on using easy-to-follow step-by-step instructions.
- Instructor-Led Training (ILT) on live exercises of each topic.
Trainer
Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
Course Content
Lesson 1: Introduction to DAX
- DAX Syntax
- DAX Data Types and Operator Overloading
- DAX Operators
- DAX Values
Lesson 2: Using DAX Functions
- Mathematical Functions
- Statistical Functions
- Logical Functions
- Information Functions
- Text Functions
- Conversion Functions
- Aggregation Functions
- elational Functions
Lesson 3: Understanding Evaluation Contexts
- The CALCULATE Function
- Filter Functions
- Single Table Evaluation Context
- Multiple Table Evaluation Context
Lesson 4: Working with Dates
- Date Functions
- Working with Calendars
- Using Multiple Calendars