Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX performs advanced calculations, therefore enabling the user to create detailed data reports or informed comparisons between data and having a good data model is key to improve usability and performance. 

This two-day course is aimed at those with basic experience of Power BI (equivalent to our Power BI Part Two training). The course will cover the components of DAX and Data Modelling and provide you with the knowledge to understand how to take your Power BI reports to the next level, for example with growth percentage across product categories or to calculate year-over-year growth compared to market trends. 

The course is split into two parts and delivered over two full days.  

Part 1 includes: CALCULATE function, table functions such as RELATEDTABLE, evaluation contexts such as ALLSELECTED 

Part 2 includes: Hierarchies, multiple fact tables, many-to-many relationships, Time intelligence 

Who is this course for? 

This two-day course is aimed at people working at all levels of reporting and analysis who work with multiple data sources. It is ideal for those with foundational Power BI experience, (equivalent to our Power BI Part Two training).

Entry requirements 

We recommend that you’ve practised and embedded your learning from Power BI Part One and Two before taking this course. 

Contact us 

We can also deliver dedicated courses for your organisation either online or at your premises. 

If you have any questions, please contact Imogen Fowler imogen.fowler@housemark.co.uk. 

Book Now