Introduction

Learn to use DAX’s most powerful tools on this Advanced DAX training course.

This is a hands-on course. There is plenty of time to experiment with the techniques you are being taught and ask questions.

By the time you finish, you’ll be comfortable using all of DAX’s most powerful tools.

✔ An advanced course that covers DAX’s most powerful features.
✔ Plenty of one-to-one attention and time to ask questions.
✔ Friendly, certified trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with any issues you have after the course.

What Will I Learn?

By the end of this course, you will be able to confidently:

  • Create a Measures table
  • Use variables
  • Use the DAX studio
  • Define and use What If scenarios and parameters

Am I Ready For This Course?

This course is for existing users of DAX who want to develop their understanding of DAX.

Before coming on this course you need to have attended our introduction to DAX course or have equivalent skills.

Course Detail

This one day course covers the following areas:

  1. Creating a Measure Table
  2. Using Variables
  3. Time Intelligence Calculations
  4. DAX as a Query Language: EVALUATE Function
  5. Introduction to DAX Studio
  6. Advanced Table Functions
  7. Advanced Evaluation Context: Cross Filters, Nested Row Context
  8. Exploring the Evaluation Context with Information Functions
  9. Defining and Using Parameters
  10. Defining and Using What-If scenarios

The Training Day

Our courses run from 9.30 am to roughly 4.30 pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned facilities, and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.