Introduction to DAX

This session will introduce the foundational concepts of the DAX (Data Analysis Expressions) functional language and provide examples of implementing DAX in business intelligence and analytics projects. As DAX is the primary language for defining metrics and queries in Microsoft Power BI, SQL Server Analysis Services, and Power Pivot for Excel it’s important to be familiar with all common use cases as well as design practices to ensure the performance and sustainability of solutions. Topics in this session include where DAX fits in the Microsoft data platform, data types, use cases of implementing DAX, most common DAX functions, filter context evaluation, DAX variables, date/time intelligent metrics, and the new DAX functions available in Power BI, Excel 2016, and SQL Server Analysis Services 2016. High level guidance on design practices and performance tuning will also be provided.