Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

From 0 to DAX

Description

This session will be presented by Marco Russo and Alberto Ferrari. The DAX language is the foundation of self-service Business Intelligence using the Microsoft stack. It is the language used to query and program both PowerPivot for Excel 2013 and the new SQL Server Analysis Services Tabular model. Learning the basics of DAX is very simple, but mastering it is a different story because it requires a mindset that requires some study, for both BI Professionals and Information Workers.

During this one-day workshop, the authors of the best seller books Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model and Microsoft PowerPivot for Excel 2010: Give your Data Meaning will guide you in the process of learning the DAX language, through many examples and scenarios that will help you understand what are the important concepts of DAX and how to leverage them in the everyday work.

The workshop is useful to many profiles: Information Workers interested in exploiting the many interesting features of PowerPivot for Excel 2013 and BI developers who want to learn the DAX language.

Learning Objectives

Previous Experience

Tech Covered

SSAS, BI, DAX, Power Pivot