Learn to use DAX’s most powerful functions 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.
✔ 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
Oakley is our usual trainer for this course. He has been a Microsoft certified trainer for 8 years.
He has been training Microsoft applications for 19 years and focuses on Power BI and Project.
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.
This one day course covers the following areas:
- Creating a Measure Table
- Using Variables
- Time Intelligence Calculations
- DAX as a Query Language: EVALUATE Function
- Introduction to DAX Studio
- Advanced Table Functions
- Advanced Evaluation Context: Cross Filters, Nested Row Context
- Exploring the Evaluation Context with Information Functions
- Defining and Using Parameters
- Defining and Using What-If scenarios
During the course, the trainer will briefly introduce you to ChatGPT and its possibility when using DAX. This section will not be covered in course materials or post-course support.
The Training Day
You don’t need to bring anything to our courses. We provide everything that you’ll need for a really fun and productive day of Power BI training.
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.
Online Training Requirements
To attend this Power BI course online, you will need:
✔ Power BI on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.