Power BI DAX Foundations

Power BI DAX Foundations is a one-day Power BI training course suitable for those who want to learn the foundational concepts of the DAX (Data Analysis eXpressions) language, equipping them with the skills to enrich their Power BI data models and reports.

Please review the Course Outline below to ensure this Power BI DAX Foundations training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Introduction & DAX Overview
• Variables, when and how to use them
• An introduction to the Table Functions you need to know
• Row Context and Filter Context, why they’re important, and how to use them
• Making the most of the powerful and versatile CALCULATE function
• How to leverage Relationships in DAX
• Using Time Intelligence functions such as SAMEPERIODLASTYEAR, PREVIOUSQUARTER, etc.

Please review the Course Prerequisites below to ensure this Power BI Data Visualisation training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Have the latest version of Power BI Desktop installed.
• Have a base level of Power BI skills equivalent to having attended the Power BI Dashboard in a Day course.
• This course is appropriate for those involved in building data models and/or data visualisations in Power BI.

Private training

• Please contact your local regional office for pricing for private training.
• Private Power BI DAX Foundations training delivered in the UK, remotely or at your offices.
• 1-day course that can also be delivered as 2 x consecutive half-days.
• Capped at 15 attendees to ensure maximum personal attention.
• Training can be customised to suit your needs.
• We can also provide follow-on consulting to help students develop their first best-practice Power BI reports/dashboards. This can be an effective way to help students successfully transition from the classroom to the real world.

Public training (schedule at bottom of page)

• £400 per person ex. VAT.
• 20% discount when you book 3 or more people on the same course.
• 20% discount when an individual enrols in 3 or more courses.

Based in London, we provide best practice Power BI training courses.

• “Chris was a great trainer, he is super passionate which makes for a very engaging training day! He goes above and beyond to explain complicated concepts and constantly checks in and is very helpful”
• “Small group size allowed for lots of questions and also context – thank you”
• “I think it was really well planned and organised and resources were shared freely and I am so grateful for that thank you!”
• “Chris did a couple of show & tell pieces with the exercise dataset not sure if everyone does that, very insightful and hope the other trainers do this”
• “Lots of practical examples and had to work some stuff out for myself which is a good learning experience”
• “I found the pacing was good, I enjoyed having an overview followed by a practical application.”
• “Insightful and practical training”
• “The instructor was very engaging and knowledgeable. The workbook/practice exercises are of high quality and not trivial. The sample Power BI reports will be a very useful resource in the future.”

We recommend all students attend Data Visualisation Best Practices. It’s one thing to know how to build a Power BI report, but it’s another to know which chart types to use for different data scenarios, how to make it look good, and most importantly, how to make it easy for people to consume the information. This course will teach you how to design attractive reports that best convey the intended story to your audience.