One of the common issues that can be seen on dashboards developed by professionals, who do not have right kind of reporting experience, can be seen on KPI reporting. Mostly KPIs are reported using traffic light indicators, and this has built-in support in performancepoint to create a scorecard and host KPIs. But over the period of time when user start using dashboards regularly, they feel the need to see the functional detail on the KPI on the dashboard itself. For example, when the user is analyzing a KPI (Cost Performance Index, for example), user would like to check different thresholds associated with this KPI. The values of interest can be, what is actual, what was target, what were the thresholds for Green, Amber and Red indicators etc.
Using stop light indicators, you can just display the status of the KPI but you can't display thresholds associated with the KPIs. Here a PPS professional would not know the solution, and the most that PPS developer would do is show the threshold values in the tooltip, which is not a solution at all. A seasoned reporting professional would immediately suggest a bullet graph for this, which is available in SSRS. You might have gone with the option of PPS just due to the scorecard feature, and when you figure out that even SSRS with Bullet Graph would have sufficed, the earth under your legs might start shaking !! This example is a very commonly found example, and if you have worked on a few reporting projects, you must have come across this scenario.