Learn how to use DAX, Power BI's powerful expression language that enables users to enhance reports with complex calculations, much more simply than with SQL or Excel formulas.
CMBI's "DAX Fundamentals" course will give you a solid understanding of the most commonly used DAX functions, expressions and patterns, allowing you to take your Power BI reports and dashboards to the next level.
How it works
|
We come to yousaving you travel time |
|
Interactive workshopgiving you valuable hands-on experience with personalised support |
|
One day course from 9am-5pmTeam can't spare a full day? Ask us about splitting the course across two sessions. |
|
Training Materials providedso you can recap after the session. See full details below |
|
$2,499 + GST per teamIncludes a day of training with optional Q&A, plus supporting course guide. |
|
Want more info?Contact us today |
Is this Course for me?
CMBI's "Power BI DAX Fundamentals" training course demystifies some of the more challenging concepts of Power BI.
If you have ever asked questions like:
- When should I use the CALCULATE statement?
- What is a filter context and a row context?
- How does Time Intelligence work?
- How do I make my reports faster?
...then CMBI's Power BI DAX Fundamentals course is for you. This hands-on and interactive course will introduce you to the most commonly used DAX functions and design patterns. At the end of the training session you will come away with a solid understanding of DAX fundamentals and hands-on experience writing DAX formulas.
Topics Covered
|
Introduction to DAXLearn about DAX and how even a small amount of DAX knowledge can make your reports more insightful and less complex to build and maintain. |
|
Filtering and LoopingExplore the two core concepts at the heart of all DAX development: filter context and iterating over data items. |
|
Time IntelligenceLearn how to use DAX Time Intelligence functions to implement time-based analysis with both standard and non-standard calendars. |
|
Relationships and DAXGet hands-on experience using DAX to manipulate non-standard relationships to extend the flexibility of reporting models. |
|
Calculated Columns & TablesLearn how to use DAX calculated columns and tables to extend the data model and verify measures. |
|
DAX OptimisationLearn strategies for improving query and reporting performance and responsiveness. |
More Detail
Want more info?
Download a detailed agenda
Interact with this live Power BI report from our course materials
The report below is a live Power BI report and is fully interactive. Click on the drop down parameters and observe the behaviour of the different DAX expressions. This report is just one of many examples that attendees build during the during the course to illustrate some of the key Power BI DAX features
Delivery Method
We present each workshop as a series of practical exercises, giving attendees hands-on experience in each session. All our workshop exercises are supported by detailed course materials for reference during and after the training day.
Materials and support
Our course materials support learning and re-enforcement well beyond the workshop.
Each session includes an associated set of support materials to help attendees complete the tasks on the day, as well as provide support after course completion:
- Supporting course notes PDF document (approx 80 pages, printed on request)
- Complete Power BI models for all exercises
- Datasets for all examples
- Optional Q&A time at the end of the session for anyone interested in asking specific questions
More Training Options
Don't see what you're looking for? CMBI offer a variety of training to suit all levels of experience:
See CMBI's training page for details of all courses we offer.