This article contains a short checklist of what you have to do in order to optimize the memory used by a data model in PowerPivot or in Analysis Services Tabular, including links to tools and resources that can help you…  Read more

I recently talked about memory usage in PowerPivot and previously I wrote about difference modeling options using table normalization or not. Thus, I wondered whether table normalization is a good practice for performance and memory or not. The short answer…  Read more

As you might already know, I and Alberto Ferrari are writing a book about PowerPivot 2010 for Excel. The official title is Microsoft PowerPivot for Excel 2010: Give Your Data Meaning and you can already order it on Amazon! However,…  Read more

There are already several posts in the blogosphere about the need of using a separate Dates table in PowerPivot to make almost any type of analysis. An important step you should make whenever you have a Dates table (almost always,…  Read more

Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS. A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is…  Read more

In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to…  Read more

Next week I will be in Paris and Brussels for two editions of the PowerPivot Workshop. The evening after the first day of the workshop is always a good chance to meet people from local communities and I am happy…  Read more

In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface…  Read more

After so many request we have finally arranged a PowerPivot Workshop online edition dedicated to America’s time zones! It is scheduled for December 19-20, 2012, with this schedule: US Eastern Time (EST): 10:00am-1:00pm / 2:00pm-5:00pm US Central Time (CST): 9:00am-12:00pm…  Read more

A few weeks ago I received a question that inspired me in writing this article about how to handle data at different granularities in PowerPivot and BISM Tabular. I think this is a common pattern when you have a budget…  Read more