Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

PASS Summit 2010 is approaching and I'm facing the dilemma of choosing concurrent sessions in certain timeslots. I'm not alone in this situation and discussing it with other people only enhance my doubts because I see only more reasons to look also other  Read more

Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting  Read more

You can download these two sample chapters of the PowerPivot for Excel 2010: Give Your Data Meaning book: Chapter 2 - PowerPivot at Work This is introductive and suggested to read to anyone who is new to PowerPivot Chapter 7 – Date Calculations in DAX  Read more

I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when  Read more

Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires  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

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