PerformancePoint Services (PPS) Wish List
Posted by denglishbi on February 11, 2011
I have been working with the PerformancePoint product since the early CTP days back in 2006. I previously had experience using the ProClarity product that was acquired and partial converted into the PerformancePoint product. With the release of PerformancePoint Services in SharePoint 2010 last year there have been some significant enhancements and additions to the product, but there are still some items that we would all like to see. Over the years I have read and heard complaints of features that are missing. Some of these are valid, but there are others where I can see why it was ‘by design’. Below I have compiled my list of items that I would like to see included and enhanced in the product.
1. Include the ProClarity Performance Map (Heat Map) and Perspective reports – these are two ‘key’ and extremely informative options that have just been glossed over and would add so much value to the product offering. I am baffled why they have not been included. I find these two views more valuable than the Decomposition Tree that was finally added into the current release (although it still can not be a starting point, it is available to use to explore the multidimensional data). The ability to analyze two metrics at the same time to determine impact and search out anomalies is a must. Even though ProClarity views can still be referenced in current product, it just is not the same and requires setup and configuration of additional product.
2. Allow users to save and share analytical views (reports) – often when users are exploring existing analytical reports they come across a new and interesting view of the data. It would be great if this view of the report could be saved to use as a starting point and shared with other users to help streamline report creation and sharing of information. Another feature that was available in ProClarity.
3. Provide Analytical Map report – another nice visualization feature that was added in SSRS 2008 R2 and is available in other competing products. It would be nice to have this option available even though you can leverage the SSRS reports in PerformancePoint to add more value to the product offering. Enhance the map experience as well with zooming and dragging functionality as well just like users would expect.
4. KPI alerts – this was available in Business Scorecard Manager so that you could receive notifications based on criteria – Scorecard Alerts in BSM 2005. This did leverage SQL Server Notification Services and I have heard rumors of a new alerting mechanism coming in the near future. Currently there is a solution that you can purchase – Bidoma Alert.
5. Ability to control chart types for data series in Analytical Reports – current version provides option to include a bar (actually a column, but called a bar…) and line chart option if one of the measures is a percentage (automatically generates second y-axis). ProClarity provided way to select a data series and chose the options independently of each other and they could be the same data type – this allowed you to show say current year sales measure in columns and previous year in a line.
6. More Analytical Charting options – provide the ability to select or provide a color scheme (you can do this in the other Microsoft products, why not here as well?); include axis labels; add more chart types – bar (in addition to the column charts already included that are called bar), area, range, polar, funnel, scatter, polar, gauges; include 3D option (although I am not a fan of the 3D, it does provide some eye candy); make data labels optional (would be great for Pie charts which are just another bad visualization, but people like them); add zoom support to select and zoom in/out in portions of the reports.
7. More linking (connection) options – ability to link filters to each other to create cascading filter functionality, ability to link Analytical reports to other items (if I can link to them, why not the other way?)
8. Provide dashboard preview functionality in Dashboard Designer – why do I need to deploy the dashboard to view how it will look and function? I can preview Report Builder, why not in Dashboard Designer as well?
9. Enhance Person Responsible property – tie this into Active directory and provide the ability to quickly interact and view that person’s contact information and status. Currently have to use additional web parts for this functionality. Ability to include mailto for hyperlink would be nice, but doesn’t appear to be an option like it was in BSM 2005. Being able to view status and availability would be extremely nice and you can do this with SharePoint lists
10. Provide printing and export functionality for dashboard and report items – ability to export each item independently is there, but not the whole dashboard, plus printing options to print and scale a dashboard or individual report would be great feature. There is a printing option you can purchase though – PerformancePoint Print WebPart.
11. Add slider filter option for Time filters – users continue to ask for options to be able to selected a start and end date type of filter. By adding a slider filter option so that the user can select a starting and ending point range for the filter would be a very nice option. This is available in other competing products. So for example here is a slider control filter from Bing Travel that allows me to select a range of time
12. Bring in the Silverlight charts – end users like the eye candy and adding in the Decomposition Tree only brings about the question why not in the other Analytical Reports. Enhance the visuals so that they look appealing to the consumers. For me it is all about the data and information, but the consumers also want the experience and visuals (like the Pie chart). In the end it is the end users that will be using the tools and pay for the product, if we can enhance and make the experience appealing and blow them away with neat visuals than this will only increase user adoption rates. Unleash the Silverlight toolkit and bring it into PerformancePoint analytical reports. Russell Christopher has a couple of outstanding examples of the sliding bubble chart and heat map – bring these visualizations into the product to provide more value. We have all been waiting for the Hockey Treemap Visualization to become a reality and part of the product offering, why has the heat map not been added yet?
13. Ok, I need one more for the bakers dozen. Mobile version for phones. Okay, you can view the SharePoint dashboard pages on the tablet and pad like devices (sorry I just can’t say the Apple words). The functionality isn’t too bad. What about for the phones? Being able to provide a version or app that can be installed to display Analytical reports that have been developed would be a nice feature. Maybe this can already be done and since I just use my phone for a phone and not all of the enhanced online capabilities it is just my lack of knowledge here. We can definitely see that the push to mobile like devices and access to information away from the desk/office is definitely happening, so provide a solution leveraging the items that have already been created.
We definitely need a better way to communicate with the product team like there is for SQL Server so that bugs and suggestions can be easily shared and monitored. Creating support cases and sending feedback into a black hole is not convenient. Leaving comments on the product teams blog is not a good long term solution either, why can’t we use the Microsoft Connect site to communicate with the team like we do with SQL Server? (maybe we can and I am just not aware of it)
I am not the only one that is requesting similar features and functionality. For more items (and some of these have been added in PerformancePoint 2010) take a look at this thread in the PPS M&A forum – PerformancePoint Monitoring Feature Suggestions.
If you have more items like you would like to see, please leave comments, who knows, maybe someone is listening and reading this and we can get these on the list for the next release of PerformancePoint assuming that this is still on the radar for maintaining this product and that it will not be swapped out with something else like ‘Crescent’. I know that ‘Crescent’ is supposed to be a reporting tool, but it sure does provide a lot of analytical capabilities just like PowerPivot.