DAX Formulas in Action

Explore the power of DAX formulas in action through this 57-minute conference talk from PASS Data Community Summit. Dive into a demo-heavy session led by Alberto Ferrari, where you'll learn to build a working prototype of a Business Intelligence solution using the DAX language in Excel and SQL Server Management Studio. Begin with the Contoso database in Excel, performing basic analysis using DAX to create calculated columns and measures for effective PivotTable analysis. Follow the progression as the prototype is promoted to a SQL Server Analysis Services database, running queries that serve as the source for a Reporting Services report. Gain insights into the analytical capabilities achievable with a fundamental understanding of the DAX language. The talk covers topics such as DAX hierarchy, calculate columns, time intelligence calculations, previous year sales, growth percentages, and pivot tables, while also comparing DAX to Excel and providing valuable resources for further learning.

Introduction
What is DAX
DAX Hierarchy
Calculate Column
Time Intelligence Calculation
Previous Year Sales
Growth
Percentage of Growth
Pivot Table
Personal Preference
Why DAX
DAX vs Excel
Resources
Questions