From 0 to DAX
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.
Marco Russo
Marco Russo is a consultant and trainer in Business Intelligence and software development, recently certified as SSAS Maestro.
He has particular competence and experience of BI solutions in sectors like financial services (including complex OLAP designs in banking area), manufacturing and commercial distribution.
Marco wrote "The many-to-many revolution" about multidimensional modeling, is one of the authors of the SQLBI Methodology and of the books "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model", "Microsoft PowerPivot for Excel 2010: Give Your Data Meaning", Expert Cube Development with Microsoft SQL Server 2008 Analysis Services" and "Programming Microsoft LINQ in .NET 4".
He has been a speaker at previously editions of SQLBits, SQLRally Nordic, PASS Summit and Microsoft TechEd.