KPI Calculations – Best Practices

Best Practices on Using Calculations

· Use calculations only with Standard KPIs (non leaf level).

· Accept the default values for Standard KPIs (leaf level) and Objective KPIs.

Detailed Description of Behavior

To understand how the Calculation setting affects a KPI, it is important to understand the differences between three types of KPIs:

· Standard KPIs (leaf level). These KPIs have no KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" selected in the Calculation dialog box.

· Standard KPIs (non leaf level). These KPIs have one or more KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" selected in the Calculation dialog box.

· Objective KPIs. These KPIs have one or more KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" cleared (not selected) in the Calculation Dialog box.

Calculation settings apply differently, depending on the type of KPI. In addition, be aware that each KPI has a value and a score. For Standard KPIs, the value is a number that either comes directly from a data source or is calculated based on child KPIs (such as the average of child KPIs). Values are not used with Objective KPIs.

For Standard KPIs, the score is a percentage that compares the KPI's Actual value to its Target value. (This percentage can be a raw score or normalized score, based on its thresholds.) For Objective KPIs, the score is the weighted average of the scores of the child KPI. The score determines which indicator is shown. (Note that you can override the score by selecting Band by Stated Score in the Edit Bandings dialog box.)

Scores are shown on a scorecard, as illustrated:

The following table explains how calculations settings affect your scorecard KPIs:

 Value Based on KPI Type Value Based on KPI Type Value Based on KPI Type Calculation Setting Standard KPI (leaf level) Standard KPI (non leaf level) Objective KPI Default Score Calculated value of Actual to Target Calculated value of Actual to Target Weighted average of child KPIs Value Value selected in Data Mappings Value selected in Data Mappings Not used No Value Score Set at 0% Set at 0% Weighted average of child KPIs Value Blank Blank Not used Source Data Score Calculated value of Actual to Target Calculated value of Actual to Target Weighted average of child KPIs Value Value selected in Data Mappings Value selected in Data Mappings Not used Average of Children Score Set at 0% Calculated value of Actual to Target Weighted average of child KPIs Value Blank Average of child KPI values Not used Sum of Children Score Set at 0% Calculated value of Actual to Target Weighted average of child KPIs Value Blank Sum of child KPI values Not used Max of Children Score Set at 0% Calculated value of Actual to Target Weighted average of child KPIs Value Blank Highest value of child KPI values Not used Min of Children Score Set at 0% Calculated value of Actual to Target Weighted average of child KPIs Value Blank Lowest value of child KPI values Not used

Elaine Andersen (elainean@microsoft.com)

Tags

1. Noticias externas says:
2. June says: