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] ) )…  Read more

Yesterday I and Alberto delivered the PreCon day about BISM Tabular in Analysis Services 2012. We received very good feedback and now I am looking forward to meet people that read our blogs and our books! Ping me on Twitter…  Read more

Yesterday I spent the longest day at this TechEd: we talked with many people at Community Night until 9pm and I have to say that just a few months after Analysis Services 2012 has been released, there are many people…  Read more

I will deliver two sessions at the next PASS Summit 2012: one is title Inside DAX Query Plans and the other is Near Real-Time Analytics with xVelocity (without DirectQuery). These will be two sessions that require a lot of preparation…  Read more

It has been a long wait, but finally our book about Analysis Services Tabular is available! Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model Amazon is already shipping it in US and it should be available soon also…  Read more

Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012. You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November…  Read more

At the end of June 2012, I was in Amsterdam to present some sessions at Teched Europe 2012 and, while preparing the material for the demos (yes, the best demos are the ones I prepare at the last minute), I…  Read more

The sessions recorded at TechEd 2013 are online. I and Alberto Ferrari delivered the same sessions and the recording are available for both TechEd North America and TechEd Europe. It’s nice for me being able to compare two deliveries of…  Read more

UPDATE Aug 16, 2013: Excel 2013 stand-alone now includes Power Pivot (now the name has a space and it is no longer a single word!). This post was originally published on Feb 18, 2013 and is now outdated. If you…  Read more