17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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 SSAS Multidimensional Models" and "Programming Microsoft LINQ in .NET 4".

He has been a speaker at previously editions of SQLBits, SQLRally Nordic, PASS Summit and Microsoft TechEd.

http://sqlblog.com/blogs/marco_russo http://sqlblog.com/blogs/marco_russo/rss.aspx
Marco Russo has submitted 5 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending 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.

Previous Sessions

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.
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Explore Power Query features to import data from existing Corporate BI systems.

Blog posts RSS

The ISEMPTY function in #dax #powerpivot #tabular 22 Apr 2014
Microsoft silently added the ISEMPTY function to the DAX language in Analysis Services build 11.00.3368 (SQL Server 2012 SP1 CU4). This function is particularly important in DAXMD (when you use DAX to query a Multidimensional model), because produces a much better execution plan in OLAP than the ...

ABC Analysis in #dax: complete pattern and other links #powerpivot #tabular 17 Apr 2014
I recently published the ABC Classification article in www.daxpatterns.com, which is a more structured and organized way that recap what I already described in this blog a few years ago (see ABC Analysis in PowerPivot). The pattern describe how to implement the classification through calculated ...

Create Excel Dashboards working on Excel for iPad #excel #ipad #dashboard 15 Apr 2014
I recently tried Excel for iPad and tried opening several workbooks. The results are pretty good, but I’ve found that it wasn’t possible to display certain workbooks. For example, opening a workbook that contains many CUBEVALUE formulas, I should have seen this result: However, sometime I’ve got ...

Create Custom Time Intelligence Calculations in #dax #powerpivot #tabular 03 Apr 2014
The recent Time Patterns article published in www.daxpatterns.com contains many DAX formulas that I hope will be useful to anyone is interest in implementing time-related calculations in DAX without relying on the Time Intelligence functions. There are several reasons for doing that: Custom ...

Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi 31 Mar 2014
The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the Power Query window. Consider the following table in Excel: You want to obtain a table ...