Marco Russo has submitted 5 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions
Optimize distinct count measures in DAX/Tabular using partitioning, distinct value reduction, rephrasing of the DAX query, analysis of query plans.
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
In this session, you will learn the best practices in data modeling for Power Pivot in order to improve the browsing experience in Excel and Power View.
Explore Power Query features to import data from existing Corporate BI systems.
Business scenarios solved in DAX, sometime in unconventional (but very effective) way. Includes time intelligence with custom calendar, same period last year with non-contiguous periods, budget analysis and comparisons, distinct count over SCD.
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.