4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


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 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
This session shows several approaches to Inventory Valuation, using Analysis Services Tabular as a calculation engine to speed-up complete recalculation of Inventory Valuation.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.

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

Rename table, columns, and measures in #ssas #tabular without breaking existing #dax 16 Dec 2014
A feature that many people require in SSAS Tabular is the ability to refactor existing names, doing a correspondent rename in all existing objects in the model. I agree that this is an important feature that should be added in the development environment, but this will help only the development ...

DAX Studio 2.0 finally available! #dax #ssas #tabular #powerpivot 08 Dec 2014
Darren Gosbell announced on his blog that DAX Studio 2.0 is available. This new release has a completely new user interface, a renewed architecture and also work as a standalone executable without Excel. Yes, you read it right. You can use DAX Studio on a server without having to run it in Excel. ...

Power Query now connects to Analysis Services #ssas #mdx #dax 26 Nov 2014
The last update of Power Query finally supports Analysis Services Multidimensional and Tabular. I waited this version for a very long time, but now it's finally here!Chris Webb already wrote an interesting blog post with several useful link and informations. You can connect to both ...

What are useful tools and resources for DAX developers? #dax #powerpivot #tabular 20 Nov 2014
At the last PASS Summit I received an interesting question: is there a list of all the useful (I would say necessary…) tools for DAX developers? My answer was… “no, but this is an interesting topic for a blog post”. In the meantime, I thought that a page to keep updated would have been better, and ...

Don’t use SUMMARIZE to sum your data–or just be careful #dax #ssas #powerpivot 18 Nov 2014
During the last PASS Summit I and Alberto Ferrari had long discussions at SQL Clinic with some of the developers of our loved tools. Sometime you really have to dig in the internals of certain feature to understand why there are some “unexpected” behaviors for certain functions. One of the ...