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

Download this episode

Download Video

Description

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".
For more information, check out this course on Microsoft Virtual Academy:

Day:

4

Level:

400 - Expert

Code:

DBI408

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.