Master the basics of DAX fast on this 1-day introduction to DAX course.
This is a hands-on course. It 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 very comfortable using DAX.
✔ 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?
Our expert instructors will have you creating your own functions in no time.
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
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?
You do not need any prior experience with DAX to attend this course.
In order to attend this course, you need to be an advanced Excel user and have a reasonable understanding of Power BI, equivalent to that reached on our beginners Power BI course.
If you already have experience with DAX, it is likely that our advanced DAX course will be most appropriate for you.
Please note that there is overlap between our Advanced Power BI course and this course. Our advanced course introduces DAX and so you will have covered approximately 60% of this course already.
This one day course covers the following areas:
- Overview of the Language
- Common DAX Functions
- Defining Calculated Columns
- Defining Measures
- Aggregate Functions
- Cross Table Lookups
- Evaluation Context in Relationships
- Defining Filters with Table Functions
- Using Filters with the CALCULATE Function
The Training Day
We provide everything you need for a really fun productive day of Power BI training. You don’t need to bring anything.
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.