Marco Russo's Blog

   View full profile
Page 34 of 723 results

Optimize Many-to-Many with SUMMARIZE and Other Techniques

We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships  Read more

SQLIO analysis on Excel charts

I tend to use twitter when I have to notify an interesting link or tool. But sometimes a blog post (even if short) is better, because allows me to easily find it on search engines (Bing/Google/whatever) months or years later. I know PInterest is growing  Read more

May Schedule of SSAS #Tabular Workshop for US & Europe

As you might have read in the previous post, May is a busy month for all the editions of the SSAS Tabular Workshop . We’ll start with an online edition next week in a time slot that should be good for US and other countries in that time zones. Then there  Read more

Distinct Count of Customers in a SCD Type 2 in #DAX

If you have a Slowly Changing Dimension (SCD) Type 2 for your customer and you want to calculate the number of distinct customers that bought a product, you cannot use the simple formula: Customers := DISTINCTCOUNT( FactTable[Customer Id] ) ) because  Read more

SSAS Maestro Training in July 2012 #ssasmaestro #ssas

A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world.  Read more