Creative DAX

Did you know the DAX language is far more capable than merely running a SUM over a column, or counting rows in a table? DAX sits on top of one of the fastest databases around, and this session will explore some unusual and creative scenarios that you previously would have thought as not possible using only DAX. This session will aim to reset your understanding of what is possible in DAX by walking through some interesting code highlights from a recent series of games built using DAX (Blackjack, Tic Tac Toe, Hangman, Minesweeper & some maze games). Each game pushes and explores different boundaries in DAX and will attempt to show just where those lines are. The session will hopefully inspire you to add some creative and exciting techniques to your own DAX based data models.

Philip Seamark

Data Platform MVP. An experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft BI stack. I have extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. - Expertise in client facing and technical roles such as Senior Architect as well as Technical Team Leader. - Expert knowledge in all facets of BI/DW including project management, dimensional modelling, performance tuning, ETL design, development and optimisation, report and dashboard design as well as installation and administration.