The latest version of PerformancePoint Services in Microsoft SharePoint Server 2010 provides several new and enhanced 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 analytical report or a scorecard. You can also apply value filters, such as a “Top 10” filter, to display more specific information in some types of scorecards and reports.
Improvements in KPIs and scorecards
New PerformancePoint scorecards 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 display lower or higher levels of detail in your scorecards. And you can use scorecards with KPIs in columns. You can also use more advanced scorecards that use time intelligence, calculated metrics, and multiple actuals to measure performance.
SCORECARDS THAT HAVE DRILL DOWN AND DRILL UP FEATURES
Depending on how your scorecard is configured, you can expand or collapse rows on your scorecard to see lower or higher levels of detail.
For example, if you have a scorecard that measures the profitability of product sales across different products in a retail organization, your scorecard might look like the following image:
If you want to see the next level of detail for a specific category, like 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 look like the following image:
You can continue expanding the scorecard until you reach 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 specific scorecard.
In the previous example, the categories, subcategories, and individual products are populated dynamically. That is, as data changes, the scorecard stays updated to show current data.
In addition to clicking the plus sign (+) or minus sign (–) next to an item on the scorecard, you can also use Detailing It is To drill commands, as shown in the following image:
To use the To drill or Detailing commands, right-click an item and click To drill or Detailing.
wear To drill to view a higher level of detail.
wear Detailing to view a lower level of detail.
SCORECARDS THAT HAVE KPIS IN THE COLUMNS
You can now have scorecards that include multiple KPIs in columns, allowing you to see more than one set of metrics for each row in your scorecard. A scorecard with KPIs in columns might look like the following image:
In the previous example, the scorecard contains two KPIs in the columns: Sales Performance and Sales Margins.
SCORECARDS WITH 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 (these KPIs are said to use calculated metrics). Or you might have KPIs that compare multiple values to a general target (these KPIs are said to use multiple actual values). 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” (these KPIs are said to use time intelligence). And now you can have KPIs that show how far performance is from a goal (these KPIs are said to exhibit variance).
While you may have advanced KPIs on your scorecards, they can remain simple and easy to use. For example, a scorecard that includes these sophisticated KPIs might look like the following image:
Calculated metrics
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 feature also allows you to use multiple data sources on a single KPI.
New report types and views
You can now use three new PerformancePoint display types in your dashboards: the KPI Details report, analytical pie charts, and the Decomposition Tree.
KPI DETAILS REPORT
You can use a KPI details report on your dashboard to view additional information about your scorecard KPIs. For example, you can view the following information in a KPI details report:
- The types of metrics that are used for KPIs
- How performance scores are calculated and what the thresholds are for individual scores
- Comments posted by other scorecard users
A KPI details report might look like the following image:
A KPI details report is always accompanied by a scorecard on a dashboard page. This is because all of the information you see in the KPI Details report is determined by what you click on the scorecard. To view information in a KPI Details report, click any value on a scorecard. To see how scores are calculated on a scorecard, click a cell in a target value column.
ANALYTIC PIE CHARTS
You can now use analytical pie charts in your dashboards. Similar to an analytical line or bar chart, you can use an analytical pie chart to display higher or lower levels of detail. You can also drill down into the data to view a different dimension in the underlying SQL Server Analysis Services data cube.
An analytical pie chart might look like the following image:
DECOMPOSITION TREE
You can open a Decomposition Tree to explore data in some types of scorecards and reports. Decomposition Tree is available as an action that can be applied to PerformancePoint analytic reports and scorecards that use Analysis Services data.
Typically, you would use a Decomposition Tree to see how an individual value in a report or scorecard can be broken down into its contributing members. Decomposition Tree automatically sorts results and applies a built-in Pareto chart to the data so you can quickly see the biggest contributors to a given report value. You can also see trends in individual members that contribute to an overall value.
DON'T YOU To open and use the Decomposition Tree, you must have Microsoft Silverlight 2 or Silverlight 3 installed on your computer. Additionally, depending on how a scorecard or analytic view is configured, you may 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 slice in a pie chart, or a cell in a grid or scorecard. Then you can select Decomposition Tree. The Decomposition Tree opens in a new window, where you can drill down to the next level of detail or drill down into the data to view a different dimension in the data cube.
A Decomposition Tree might look like the following image:
Using the Decomposition Tree, you can also view the member properties for a given dimension member, as shown in the following image:
