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

DAX Studio 2.1 helps you optimizing #dax queries for #powerpivot #powerbi #ssas #tabular 17 Mar 2015
After the initial release of DAX Studio 2.0, in December 2014, I started working on a few features to analyze performance of DAX queries. Darren Gosbell implemented many other features, and Daniele Perilli helped us with the graphics of the UI. We certainly can do more, but I think that the current ...

The preview of Power BI is now available worldwide #powerbi 16 Mar 2015
Today Microsoft announced the availability of Power BI preview also outside United States. http://blogs.msdn.com/b/powerbi/archive/2015/03/16/power-bi-preview-now-available-worldwide.aspxOne important thing to note is that also the mobile app for iPad and iPhone are also available worldwide. ...

New article in the From SQL to DAX series: IN and EXISTS functions in #DAX 11 Mar 2015
I published another article in the “From SQL to DAX” series I launched many months ago on www.sqlbi.com. This time, the goal is to analyze DAX alternatives for IN and EXISTS operators that you have in SQL. The name of the article is From SQL to DAX: IN and EXISTS. I hope that a syntax ...

Use FIRSTNONBLANK and LASTNONBLANK instead of MIN and MAX #dax 24 Feb 2015
You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures). However, these functions have a syntax and a behavior that can be useful in other scenarios. For example: you might be aware that MIN ...

New DAX Courses from SQLBI and conference updates #dax #powerpivot #tabular 18 Feb 2015
In the last two years, I and Alberto Ferrari delivered many courses about Power Pivot, SSAS Tabular, and DAX. We had DAX content in many of the courses, and this created some overlapping and the lack of a clear guidance for studying DAX, regardless of the tool you were using. With the ...