THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Define groups of values using PowerPivot

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 to change the cube structure on the server, something that an end user is not allowed to do.

Having such a flexibility in PowerPivot is one of the reasons it should be adopted by data analysts and advanced Excel users to do advanced analysis in a more autonomous way. The same topic is covered in more details in the Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning book (which is finally in stock – I just received my hard copy a few days ago and I’m happy it is now on my shelf, too) and will be of course discussed in the PowerPivot Workshop on Dec. 1-2, 2010.

Published Thursday, October 14, 2010 6:36 PM by Marco Russo (SQLBI)
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement