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

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

BI Announcements at PASS Summit 2014 #sqlpass #powerbi #powerpivot 05 Nov 2014
This morning the PASS Summit 2014 started in Seattle and during the keynote there was several announcements from Microsoft. I’m considering here only the ones about Business Intelligence (you will find other blogs around about SQL Server). In the coming months, Azure SQL Database will ...

Power Query support for Analysis Services (MDX) 28 Oct 2014
Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services.This is still not available, but it should be released soon (hopefully it will be our Christmas gift!).Here is a list of features shown:It should be able to query both Multidimensional ...