Enriching Your BI Semantic Models Using Data Analysis Expressions (DAX)

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

Right click “Save as…”

Slides (view online)
Data Analysis Expressions (DAX) is a new calculation language introduced in Microsoft SQL Server 2008 R2 within PowerPivot. DAX is an extension to the Excel formula syntax and offers information workers an intuitive yet powerful tool to add business logic to their PowerPivot applications. In SQL Server code-named “Denali”, with the introduction of the BI Semantic Model, DAX becomes a key component of any Corporate Business Intelligence application built on the Microsoft Business Intelligence stack. The goal of this session is to introduce you to the concepts in DAX, how to add calculated columns and measure to your model, and the new DAX features coming in "Denali".

Comment on this Session

Already have a Channel 9 account? Please sign in