A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example: You want to make part of the calculation depending  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  Read more

I started using SQL Search (a free product from RedGate) several weeks ago, while it was still in beta. Now that the product has been released and is freely downloadable, I can say it has being really useful since the first beta. My common need is to  Read more

Denny Lee described how to open a trace file in PowerPivot for Excel . It is something that is very important because the SSAS engine which runs PowerPivot runs inside the Excel process and doesn’t have an external connection (thus, also SQL Profiler  Read more

PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with  Read more

The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example,  Read more

Following the full disclosure of Grant Fritchey and Andy Leonard , here are my evaluations of PASS 2009 Summit evaluations (in both sessions I was on stage together with Alberto Ferrari). To make the post more readable, I anticipate the comments. The  Read more

I know, the title is provocative. It’s intentional. I’d like to get feedback about my opinion. My point is simple (but not so short!). PowerPivot (which, you know, I like) and self-service BI are the new buzzwords for BI in Redmond. However, there are  Read more

The CALCULATE function in DAX is the magic key for many calculations we can do in DAX. However, it is not pretty intuitive how it works and I spent a lot of time trying to understand how it can be used. First of all, this is the syntax. CALCULATE( <expression>,  Read more

Even if the site still is not updated, the Microsoft BI Conference 2010 will be joined with TechEd 2010 in New Orleans, LA. The conference will start on June 7, 2010, with a pre-conference day on June 6 (there are still no updates about BI Conference  Read more