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 Building Data Models with Microsoft Excel 2013 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.

Very basic usage of Power BI / Power Pivot / AS Tabular. No prior knowledge of DAX is required
Laptop Required: Optional

  • Software: Power BI Desktop. There will be no exercise, but they might want to test the examples on their laptop. In any case, the laptop is NOT mandatory, it is just an option
  • Subscriptions: None

Presented by Alberto Ferrari at SQLBits XVIII