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

I received this request in many courses , messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature  Read more

If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models . This is the  Read more

I received the communication from the PASS Program Committee that none of my proposals have been accepted at PASS Summit 2013 . Probably this year there was too many proposals and I made a mistake not using all the possible proposals available per speaker.  Read more