Marco Russo's Blog
View full profileOptimize 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
Registrations Open for SSAS Maestro in July 2012 #ssasmaestro #sass
Registrations are now open for the SSAS Maestro course in July 2012, which will take place in Milan (Italy). I introduced this course in a previous blog post and I’m not going to repeat all the details here. I just want to highlight a few updates, the 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
Order of Evaluation in CALCULATE and Clever Hierarchy Handling in #dax
After the first two editions of the SSAS Tabular Workshop , I and Alberto had some time to flush some of the pending activities. We published two articles: Clever Hierarchy Handling in DAX : DAX is not a hierarchy-friendly language, especially if you Read more
Last minute update #ssas #tabular community event in Amsterdam on April 16
We finally have the registration website for the community event about Tabular in Analysis Services in Amsterdam on April 16 evening that I introduced in my previous post – don’t miss it, the registration are open (and limited!) at: http://passnl-april2012.eventbrite.com/ Read more
#SSAS #Tabular Workshop and Community Events in Netherlands and Denmark
Next week I will finally start the roadshow of the SSAS Tabular Workshop , a 2-day seminar about the new BISM Tabular model for Analysis Services that has been introduced in SQL Server 2012. During these roadshows, we always try to arrange some speeches 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
Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model #ssas #tabular #bism
I, Alberto and Chris spent many months (many nights, holidays and also working days of the last months) writing the book we would have liked to read when we started working with Analysis Services Tabular. A book that explains how to use Tabular, how to 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