The latest release of PerformancePoint Services in Microsoft SharePoint Server 2010 provides you with several new and improved features to help you monitor and analyze performance in your organization. You can use dashboards that include more sophisticated key performance indicators (KPIs) in scorecards. You can use new reports, such as a KPI Details report. And, you can open a Decomposition Tree from a value in an analytic report or a scorecard. You can also apply value filters, such as a “Top 10” filter, to view more specific information in some kinds of scorecards and reports.
Enhancements in KPIs and scorecards
PerformancePoint scorecards new include more sophisticated KPIs and other advanced functionality to make it easier to monitor and analyze organizational performance. For example, you can use Drill Down and Drill Up to view lower or higher levels of detail in your scorecards. And, you can use scorecards that have KPIs on columns. You can also use more advanced scorecards that use Time Intelligence, calculated metrics, and multiple actuals to measure performance.
Depending on how your scorecard is configured, you can expand or collapse rows in your scorecard to see lower or higher levels of detail.
For example, if you have a scorecard that measures product sales profitability across different products in a retail organization, your scorecard might resemble the following image:
If you want to see the next level of detail for a particular category, such as GAMES & TOYS you can click the plus sign (+) next to that category and the scorecard will automatically expand to show the next level of detail. Then, your scorecard might resemble the following image:
You can continue expanding the scorecard until you get to the lowest level of detail. The following image shows the Download Games subcategory expanded to list individual products, which is the lowest level of detail for this particular scorecard.
In the preceding example, the categories, subcategories, and individual products are dynamically populated. That is, as the data changes, the scorecard remains up to date to show the current data.
In addition to clicking the plus sign (+) or minus sign (–) next to an item in the scorecard, you can also use Drill Down and Drill Up commands, as shown in the following image:
To use the Drill Up or Drill Down commands, right-click an item, and then click Drill Up or Drill Down.
Use Drill Up to view a higher level of detail.
Use Drill Down to view a lower level of detail.
SCORECARDS THAT HAVE KPIS ON COLUMNS
You can now have scorecards that include multiple KPIs on columns, enabling you to view more than one set of metrics for each row in your scorecard. A scorecard with KPIs on columns might resemble the following image:
In the preceding example, the scorecard contains two KPIs on columns: Sales Performance and Sales Margins.
SCORECARDS THAT HAVE MORE SOPHISTICATED KPIS
You can now use scorecards that contain more advanced KPIs. For example, you might have KPIs that use formulas and calculations to measure performance (such KPIs are said to use calculated metrics). Or, you might have KPIs that compare multiple values to an overall target (such KPIs are said to use multiple actuals). You can even have KPIs that use special formulas to show information for dynamic time periods, such as “Last Six Months” or “Year to Date” (such KPIs are said to use Time Intelligence). And, you can now have KPIs that show how far off performance is from a goal (such KPIs are said to display Variance).
Although you can have advanced KPIs in your scorecards, your scorecards can remain simple and easy to use. For example, a scorecard that includes such sophisticated KPIs might resemble the following image:
In the following image, the Sales Margins KPI is highlighted. This KPI uses calculated metrics to determine whether performance is on or off target.
When calculated metrics are used in KPIs, SharePoint Server applies one or more formulas to the data as it is retrieved from the underlying database(s). This capability also enables the use of multiple data sources in a single KPI.
New report types and views
You can now use three new PerformancePoint view types in your dashboards: the KPI Details report, analytic pie charts, and the Decomposition Tree.
You can use a KPI Details report in your dashboard to view additional information about scorecard KPIs. For example, you can view the following information in a KPI Details report:
- The kinds of metrics that are used for KPIs
- How performance scores are calculated and what the thresholds are for individual scores
- Comments that were posted by other scorecard users
A KPI Details report might resemble the following image:
A KPI Details report is always accompanied by a scorecard in a dashboard page. This is because all the information that you view in the KPI Details report is determined by what you click in the scorecard. To view information in a KPI Details report, you click any value in a scorecard. To see how scores are calculated in a scorecard, click a cell in a Target value column.
ANALYTIC PIE CHARTS
You can now use analytic pie charts in your dashboards. Similar to an analytic line or bar chart, you can use an analytic pie chart to view higher or lower levels of detail. You can also drill into the data to view a different dimension in the underlying SQL Server Analysis Services data cube.
An analytic pie chart might resemble the following image:
You can open a Decomposition Tree to explore data in some kinds of scorecards and reports. The Decomposition Tree is available as an action that you can apply to PerformancePoint analytic reports and scorecards that use Analysis Services data.
You would typically use a Decomposition Tree to see how an individual value in a report or a scorecard can be broken down into its contributing members. The Decomposition Tree automatically sorts results and applies an inline Pareto chart to the data, so you can quickly see the highest contributors to a particular report value. You can also see trends across individual members that contribute to an overall value.
NOTE In order to open and use the Decomposition Tree, you must have Microsoft Silverlight 2 or Silverlight 3 installed on your computer. In addition, depending on how a scorecard or an analytic view is configured, you might not be able to open the Decomposition Tree.
To open the Decomposition Tree, right-click an individual value, such as a point in a line chart, a bar in a bar chart, a wedge in a pie chart, or a cell in a grid or a scorecard. Then, you can select Decomposition Tree. The Decomposition Tree opens in a new window, where you can either drill down to the next level of detail, or drill into the data to view a different dimension in the data cube.
A Decomposition Tree might resemble the following image:
Using the Decomposition Tree, you can also view member properties for a particular dimension member, as shown in the following image: