Solving Complex Business Problems with DAX

Sign in to queue

Description

DAX (Data Analysis eXpressions) formulas are at the core of every analytical application, whether you use Microsoft Excel to create a PowerPivot workbook or Visual Studio to create Microsoft SQL Server Analysis Services tabular models. In this demo-heavy session, we dive deep into several more complex DAX solutions that will help you solve some common business problems like running totals, year-over-year comparison, sales predictions, 4-5-4 calendars, automatic time filters, and tool tables. In this level 400 session we take a look at what is actually happening inside the Power Pivot formula engine and how we get to the result, mostly looking at evaluation context.
For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Session Type:

Breakout

Code:

DBI-B312

Room:

Room 330

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents