You will learn how to mine and expose hidden information with the DAX language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. There is an emphasis on practical applications of DAX to enable delegates to be productive right from the word go after attending this course.
You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises.
This course is aimed at existing users of Power BI, or those who have attended our Power BI Desktop Level 1 course and who need to take their data analysis skills to the next level.
No previous knowledge of DAX is assumed.
Upon successful completion of this course, students will be able to:
Introduction to DAX
Calculated Columns
DAX Measures
Data Modelling 101
The CALCULATE Function
The FILTER Function
Working with Dates and Time Intelligence
Conditional and Branching Logic
Iterator Functions
Complex Table Relationships
Custom Date Tables
Enhanced DAX Functionality
Group discount | ||
1 place | £ 790 | n/a |
2 places | £ 1580 | n/a |
3 places | £ 2370 | £ 2170 |
4 places | £ 3160 | £ 2670 |
5 places | £ 3950 | £ 3170 |
6 places | £ 4740 | £ 3670 |
7 places | £ 5530 | £ 4170 |
8 places | £ 6320 | £ 4670 |