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)

Comments

• Anonymous
  July 20, 2007
  Best Practices on Using Calculations · Use calculations only with Standard KPIs (non leaf level). · Accept

• Anonymous
  December 12, 2013
  None of your images load for any of the KPI threshold articles.