Marco Russo

Marco Russo

Business Intelligence Senior Consultant

  • @marcorus

Areas of Expertise:

  • PowerPivot
  • Analysis Services
  • SQL Server
  • MDX
  • Integration Services
  • SSIS
  • SSAS
  • LINQ
  • C#
  • .NET Framework
  • consulting
  • speaking
  • programming
  • training
Marco Russo (marco.russo@sqlbi.com) is a founder of SQLBI.COM. He provides consultancy and training on Business Intelligence, with a particular specialization in the Microsoft Technologies related to BI. He has written several papers about these topics, with a particular mention for "SQLBI Methodology," which is a complete methodology for designing and implementing the back-end of a BI solution (from OLTP to OLAP cubes through Data Warehouse and Data Marts) using the Microsoft BI stack of technologies, and "The Many-to-Many Revolution," which is a paper dedicated to modeling patterns using many-to-many dimension relationships in Analysis Services. In 2009, he has co-authored Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, which is considered an important set of guidelines and best practices for using Microsoft Analysis Services in the real world. He also wrote several books for .NET development, in Italian and English language. Marco is also regular speakers at major international conferences about Microsoft SQL Server PowerPivot for Excel, Microsoft SQL Server Analysis Services, and .NET Framework development.

Marco blogs at:

Basket Analysis with #dax in #powerpivot and #ssas #tabular

June 12 2014

A few days ago I published a new article on DAX Patterns web site describing how to implement Basket Analysis in DAX. This topic is a very classical one and is also covered in the many-to-many revolution white paper. It has been also discussed in several blog posts, listed here… read more

White Paper on Analysis Services Tabular Large-scale Solution #ssas #tabular

June 05 2014

Since the first beta of Analysis Services 2012, I worked with many companies designing and implementing solutions based on Analysis Services Tabular. I am glad that Microsoft published a white paper about a case-study using one of these scenarios: An Analysis Services Case Study: Using Tabular Models in a Large-scale… read more

The updated Survey pattern for Power Pivot and Tabular #powerpivot #tabular #ssas #dax

May 29 2014

One of the first models I created for the many-to-many revolution white paper was the Survey one. At the time, it was in Analysis Services Multidimensional, and then we implemented it in Analysis Services Tabular and in Power Pivot, using the DAX language. I recently reviewed the data model and… read more

Write DAX queries in Report Builder #ssrs #dax #ssas #tabular

May 21 2014

If you use Report Builder with Reporting Services, you can use DAX queries even if the editor for Analysis Services provider does not support DAX syntax. In fact, the DMX editor that you can use in Visual Studio editor of Reporting Services (see a previous post on that), is not… read more

Tips for adapting Date table to Power View forecasting #powerview #powerbi

May 20 2014

During the keynote of the PASS Business Analytics Conference, Amir Netz presented the new forecasting capabilities in Power View for Office 365. I immediately tried the new feature (which was immediately available, a welcome surprise in a Microsoft announcement for a new release) and I had several issues trying to… read more

Power Query in Modern Corporate BI–Copenhagen, June 3, 2014–#powerquery

May 19 2014

I will be in Copenhagen to deliver the SSAS Tabular Workshop on June 2-4, 2014 (few seats still available, but hurry up!). In the same week I will be a speaker in an evening community event, MsBIP møde nr. 21, delivering the Power Query in Modern Corporate BI session that… read more

Implement Budget Allocation in DAX for Power Pivot and Tabular #powerpivot #tabular #ssas #dax

May 15 2014

Comparing sales and budget, or costs and budget, is a very common operation. However, it is often the case that you have different granularities for different tables containing budget and the data to compare with. There are two ways to do that: you can limit the comparison to the granularity… read more

Meet me at TechEd 2014 – where and when #msteched

May 12 2014

If you are attending TechEd North America in Houston this week, stop me and say hello! I am always happy to meet blog readers, and of course if you have question or topic to discuss, try to join me at the BI booth expo. I tried to put a list… read more

SSAS Tabular from the Trenches in London on June 11, 2014 #ssas #tabular

May 12 2014

I will be in London to teach the Advanced DAX Workshop on June 11-13, 2014 (if you are interested, there are still seats available).During my stay, I will also deliver an evening community session titles SSAS Tabular from the Trenches on June 11, 2014 at 6:30pm. The London Business Analytics Group… read more

First steps with Scheduled Data Refresh for Power Query #powerbi #powerquery

May 06 2014

Just a few days before my session about Power Query at TechEd 2014, Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations. This is a very good news, because it enables the data refresh of a number of different… read more

LINQ to DAX project on CodePlex #dax #tabular #ssas

May 05 2014

Since its release, I've seen a number of scenarios where Analysis Services Tabular is the analytical engine of the reporting section in a larger system. In these conditions, at least a part of the queries sent to Analysis Services are DAX queries generated by code (as a consequence of user… read more

How to handle fact tables with different granularities in #dax #powerpivot #tabular

May 01 2014

A common question I receive from Excel users learning Power Pivot is how to handle table that have different granularities. In reality, this terminology is not the one they use: the concept of “table granularity” is used mostly by Kimball practitioners, who immediately identify this scenario in a “two fact… read more

Upcoming conference speeches and workshops #ssas #tabular #dax #powerpivot

April 28 2014

Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap:PASS Business Analytics Conference 2014 - May 7-9, 2014 - San Jose, CaliforniaQuerying in DAX (Marco Russo)DAX from the Field: Real-World Case Studies… read more

The ISEMPTY function in #dax #powerpivot #tabular

April 22 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 alternatives based on… read more

ABC Analysis in #dax: complete pattern and other links #powerpivot #tabular

April 17 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 columns, so we consider it… read more

Create Excel Dashboards working on Excel for iPad #excel #ipad #dashboard

April 15 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 an error saying… read more

"I learned a lot from this book about all the different types of programs and ways you can use this very useful data program."
--Stephaine Szostak, cybertron reviews

"Keep this baby close by. You'll be looking in it every eleven seconds."
--Jenilee, Kick Ass Book Reviews

"I would recommend this book to those who have to handle business analysis but are not looking for an extensive business intelligence solution."
--Susan Donnelly, eJournal of the Tucson Computer Society, March 2011, Volume 29, Number 3

"Authors Paolo Pialorsi and Marco Russo, have done an outstanding job of writing a book that covers Language Integrated Query (LINQ) both deeply and widely."
--John Vacca, Amazon.com