marco_russo.jpg

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

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.
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.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.

Blog posts RSS

Power BI Desktop & Excel 31 Aug 2015
The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit ...

Large Dimensions in SSAS Tabular #ssas #vertipaq 20 Aug 2015
After many years of helping several companies around the world creating small and large data models using SQL Server Analysis Services Tabular, I’ve seen a common performance issue that is underestimated at design time. The VertiPaq engine in SSAS Tabular is amazingly fast, you can have billion of ...

DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi 18 Aug 2015
If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016. There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the second group). DAX Formatter also supports the ...

Zero Inbox 17 Aug 2015
This is a blog post completely unrelated to the technical content I’m used to cover. But I’ve been asked so many times how I do handle my mail that I thought having a blog post will save me time to explain. So, if you are not interested, wait for the next blog post, which will be about Business ...

The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi 05 Aug 2015
I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are ...