In June I participated to two TechEd editions ( North America and Europe ). I and Alberto delivered a Pre Conference and two sessions about Tabular. Both conferences provides recorded sessions freely available on Channel 9 so that you can compare which  Read more

I and Alberto are in Amsterdam this week at TechEd Europe 2012 . If you are here at the conference, you can meet us here: Wed, Jun 27 10:15 AM - 11:30 AM – Room G106 DBI319 - BISM: Multidimensional vs. Tabular Wed, Jun 27 02:15 PM – 02:30 PM – Microsoft  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 and even if I  Read more

I hadn’t time yesterday to write a blog post before of the beginning of the day and I recover now that I’m already back to Europe. I spent many hours at the Microsoft booth meeting people who asked questions about Tabular, Power View and PowerPivot. I  Read more

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

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

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

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

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

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