Alan Whitehouse's Ramblings

Continuing to work until my heavy investment in lottery tickets finally pays off….

  • Categories

  • Archives

  • Deep Thought

    Historically speaking, all true change in the world has come thanks to leaders emerging, them taking charge and giving the masses someone to rally around. Can an intentionally "leaderless" movement survive or will it just slowly fade away?

  • Subscribe

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 18 other followers

  • Me!

  • Advertisements
  • Disclaimer

    The views expressed in this blog, while intelligent and always right, are strictly my own, and do not necessarily reflect the views of anyone else with which I am in any way affiliated. And don't forget, I own the rights to all information on this blog (except for the stuff I stole from other people).
  • Current Rant


    You want change, then get involved. Vote, run for office, go to shareholder meetings and contact advertisers or investors. Sitting around banging drums, singing kumbaya, smoking weed and having a camp out under the stars is not going to get you the change you want.

  • Admin Stuff

PerformancePoint Services 2010 Review

Posted by Alan on January 6, 2010

A few weeks back TGO was contracted by a client to implement a dashboard solution for them.  We had originally planned on rolling out the project using Microsoft Office SharePoint Server 2007 and the M&A components of PerformancePoint Server.   However, after some discussions we jointly agreed to roll out the project using SharePoint 2010 and PerformancePoint Services.   Thanks to this project I think I can now offer some real-world insight to the new version.   

So what do I think of PerformancePoint Services in SharePoint 2010?  Overall I really like it.  We didn’t experience any major “bugs”, there are many new and useful features and the learning curve was minimal.  However, I am sure there are people out there who were expecting hundreds of new features  and they will be disappointed.  As for me, I am not complaining.  OK, I take that back, I do have a couple of complaints.  

Given the upheaval that the development team and the product itself must have experienced during the last year, I am impressed with what they accomplished with this release.   And now that they have the tighter integration with SharePoint and PowerPivot is available I really look forward to the future of B.I. from Microsoft.   

So here is my quick list of some of the new things that ended up coming into play during our first project with 2010 that I really like:

  1. Natively Build Dashboards — one of the features of Dashboard Designer allows you to create and publish a dashboard.  You pull in your items and publish the dashboard and a web page is created for you automatically.  In 2007, if you really wanted a professional look and feel this function was not ideal and to really get what you wanted you had to create a SharePoint web part page and add the PerformancePoint web parts and manually configure them.  Now, the web pages created in the Dashboard Designer can really stand on their own.   So much in fact, that I think this may now be the default way to publish dashboards to SharePoint.
  2. Stacked Items — if you ever struggled with having to cram too much into a single web page then you will like the stacking.  With it you can layer multiple items over one another and then choose which one to view via a drop down list.   Note:  As Nick pointed out below, you had this in 2007 with the “native dashboards”, I was thinking of the SharePoint created dashboards.
  3. SharePoint for Storage — in 2010 all your important items (i.e., data connections, KPI’s, charts, etc.) are stored in a SharePoint document library which gives you the capability to use functions like versioning and check in/check out.  
  4. Pie Charts — never again must we face the embarrassement of explaining to a client that while implementing their enterprise BI solution that we couldn’t accomodate their request for a simple pie chart. 
  5. Multiple Actuals, Multiple Variances and Calculated Measures — all items that make displaying information the way people really want to look at it far, far easier.
  6. Decomposition Tree — all I can say is WOW!   This thing is slick and the folks who decided to do it in Silverlight and who then developed it should all get a raise.

As with any project and any new product there have to be some things that are not perfect.  So here is the quick list of things that are causing me some frustration:

  1. Relational Chart/Grids Only Through Excel Services — in 2007 if you wanted to create a chart or data grid off of a non-SSAS data source you could do it within the application.  It wasn’t perfect, but it was available.  In 2010, any chart or data grid coming from a non-SSAS  source must first be created in Excel Services.   Now you do get much greater functionality, but for simple displays of information this extra step does add an additional layer of effort and complexity.  
  2. Loss of Heat/Tree Maps and Scatter Diagrams — AAARRRRGGGG!!!!  Yes we had to use the ProClarity components to source these, but they were very powerful and they looked really cool.  I can only hope that this functionality is on the top of the new feature list for PerformancePoint Services 201x. 

So did the PerformancePoint team hit a home run with this release?  I can’t give them that, but I can say they got themselves a stand-up triple.


10 Responses to “PerformancePoint Services 2010 Review”

  1. […] This post was mentioned on Twitter by Excel Dashboards, Hellin Donal. Hellin Donal said: PerformancePoint Services 2010 Review « Alan Whitehouse's Ramblings: We had originally planned on rolling o.. […]

  2. Hi Alan, nice post.

    Small correction: I think you’ll find that the Stacked Item functionality was available in PPS 2007.


  3. Alan said


    You are right that the stacked option existed if you used the directly published dashboard from the Dashboard Designer. However, if you were creating your own web pages within SharePoint you didn’t have that option (unless I have been missing it completely these past couple years). Now we have the “PerformancePoint Stack Selector” web part which I really like.


  4. Matt P said

    I’m glad to see you posting again. I’m now almost completely out of the budgeting/planning space (although I do help with a new product that is getting built). I recently took a new job which has a heavy BI and SharePoint focus in the next couple of years so I appreciate the great content you provide.

  5. Don said

    Alan – Nice post. We are releasing an alerting solution for PerformancePoint. If you or your company would like more info, please contact me.

  6. vsd said

  7. vsd said

  8. Mahesh said

    Hi Alan,

    I am struggling in PPS because of its inability to create calculated measures in reports. It would not be practical to build all possible measures in the cubes. Is there anything like OLAP Pivot Table Extension in Excel which allows us to create calculated measures.


  9. Alan said

    Hi Mahesh,

    Can you leave me some more details on what you are trying to accomplish?


  10. Wilson said

    I’m interested in knowing about heat maps and how they can be created in the designer?


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: