Session room

The Agenda

Agenda Home

SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.

2024 Training Days

Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.

  • 08:00 Registration opens and breakfast served.

  • All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
  • All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
  • No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.

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