DAX and Data Modelling
Delivered by housing experts who are passionate about what data can deliver for the sector.
Find out more
Improving skills and unlocking the potential of your people.
DAX and Data Modelling
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX perform 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, 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
To book your place visit our events page.
For more information about our data training courses, please contact imogen.fowler@housemark.co.uk.
Work with Housemark
Our expert partners are here to provide support to boost your in-house capabilities. By presenting data in a clear way, we’ll show you what the numbers mean to your customers, your people, and your business.
Contact us