If you lost the SQLBI Methodology session (or any other one) at 24 Hours of PASS in September, now you can watch the recordings on-line ! I just looked at the presentation and unfortunately there are 6 minutes missing from our presentation. Thus, if you  Read more

Banding is one of the most common requirements when you have the need to analyze continuous values, like the retail price of a product which may change over time, due to discounts and price variations. I have already spoken about banding with regards  Read more

My Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning book has been printed and is now in stock on many bookstores! This is another good news of the past week, who have been dense of good news. I and Alberto have been interviewed by Vidas Matelis  Read more

A few days ago Kasper anticipated that I and Alberto will teach a 2-day PowerPivot course based on our PowerPivot book . The location will be next the Amsterdam airport, at Schiphol, Netherlands, and the dates are December 1st and 2nd, 2010. When we prepared  Read more

The sample files of the PowerPivot book are available at this page , where you can download a 260Mb zipped file containing all the Excel workbooks used in the book to make the examples.  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 Microsoft® PowerPivot for Excel® 2010:  Read more

If you get an error trying to create chained relationships in PowerPivot (i.e. Customers - Orders - OrderDetails), there is a known issue with a possible workaround. The item is described on Connect, but here is the issue and the workaround: ISSUE: A  Read more

The upcoming book Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I wrote with Marco is its final stage. You can see the final update through the “ Rough Cuts ” initiative by O’Reilly. The book will be available in bookstores in the first  Read more

This topic is general and not related to a specific feature of PowerPivot. In the way it is designed today, when data are imported from a SSAS cube into PowerPivot, the dimensionality of the original cube is lost and a flat table is imported as the result  Read more

Every measure imported from a SSAS cube is imported as a Text column instead of as a Numeric column. This is very annoying because users are used to use SSAS data with rich metadata, and a measure is usually numeric. Moreover, the standard aggregation  Read more