Recently I received a request from a reader related to the handling of missing or invalid dates in Tabular (but the same can be applied to Power Pivot). In the Analysis Services Tabular book , we wrote that you can insert a special row in the Date table  Read more

I recently wrote an article that describes how to calculate a measure (such a sales, but it could be anything else) considering for each customer its first 12 months, then months 13-24 and so on. In practice, for every customer you have a different range  Read more

Alberto Ferrari recently recorded a free short video introduction about what is time intelligence . When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are  Read more

A couple of weeks ago, I wrote a blog post about MCSM for BI certification . This raised an interesting discussion about the reasons why such a certification does not exists, whether it was really necessary, what it should include, and so on. There was  Read more

I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that  Read more

Two years ago Microsoft started a certification program called SSAS Maestro , which was intended to be as a step towards a broader certification such as a Microsoft Certified Architect (MCA) or Microsoft Certified Solution Master (MCSM) for Business Intelligence  Read more

This time Microsoft listened to the many complaints received since Excel 2013 release and the stand-alone version of Excel now includes Power Pivot and Power View! This is a very important news because there were customer who didn’t upgrade from Excel  Read more

In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about  Read more

Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we’ll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of  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 the same session.  Read more