Introduction

Master the basics of DAX on this 1-day introduction to DAX course.

This is a hands-on course that includes plenty of time to play with what you are being taught and ask questions.

Our expert instructors break the course into easily digestible sections and ensure that no-one is left behind.

By the time you finish, you’ll be a comfortable, capable DAX user.

✔ A complete introduction to DAX.
✔ Plenty of time to ask questions and one-to-one attention.
✔ Friendly expert trainers who make sure no-one is left behind.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support for 6 months after the course.

What Will I Learn?

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

– Work with common DAX functions
– Define calculated columns and measures
– Use cross table lookups
– Define filters with tables functions

Am I Ready For This Course?

In order to attend this course, you need to be an advanced Excel user.

You don’t need experience of using DAX but do need a reasonable understanding of Power BI, equivalent to that reached on our intermediate Power BI course.

Course Detail

This one day course covers the following areas:

  1. Overview of the Language
  2. Common DAX Functions
  3. Defining Calculated Columns
  4. Defining Measures
  5. Aggregate Functions
  6. Cross Table Lookups
  7. Evaluation Context in Relationships
  8. Defining Filters with Table Functions
  9. Using Filters with the CALCULATE Function

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.