|
Columns
|
Description
|
|
KPI Name
|
Name of KPI
|
|
Period
|
The Period based on which the KPI is calculated
|
|
Frequency
|
“How often can we measure?” The frequency ranges from Yearly to Hourly time dimensions
|
|
Polarity
|
If increase in value of KPI is beneficial, it is ‘High’ polarity KPI, whereas if increase is adverse, it is ‘Low’ polarity. For example, Sales is High polarity KPI, while Return Quantity is Low polarity KPI.
|
|
Previous Value
|
Actual KPI value for previous Period
|
|
Actual
|
Actual KPI value for the current Period
|
|
Target
|
Target KPI value as per definition
|
|
Alert
|
Alert threshold value as per definition. Can be manual or automatic
|
|
Warning
|
Warning threshold value as per definition. Can be manual or automatic
|
|
Variance
|
If the polarity is high, then Variance = Actual – Target
If the polarity is low, then Variance = Target – Actual
|
|
Variance %
|
(Variance / Target)*100
|
|
Performance %
|
If the polarity is high, then Performance % = (Actual / Target)*100
If the polarity is low, then Performance % = (Target / Actual)*100
|
|
Performance Indicator
|
There are three indicators in the threshold section
|
|
|
|
If the Actual value is less than the Alert value
|
|
|
If the Actual value is less than the Warning value and greater than the Alert value
|
|
|
If the Actual value is greater than the Warning value
|
|
Trend Indicator
|
The direction of the arrow indicates the direction of the Performance Trend (up or down compared with previous period). The colour indicates performance for the current period with respect to the target.
If the target is not defined, trend indicator will be shown without any colour.
|
|
|
(9).png)
|
Performance for the period is less than the target, and performance has declined compared with previous period.
|
|
(9).png)
|
Performance for the period is less than the target, and performance has improved compared with previous period.
|
|
(9).png)
|
Performance for the period is higher than the target, and performance has declined compared with previous period.
|
|
(9).png)
|
Performance for the period is higher than the target, and performance has improved compared with previous period.
|
|
(9).png)
|
Performance has declined compared with previous period and Target is not defined.
|
|
(9).png)
|
Performance has improved compared with previous period and Target is not defined.
|
|
Trend chart
|
Trend chart shows the trend line for performance over a period.
|
(9).png){kind=small}
(9).png){kind=small}
(9).png){kind=small}
(9).png){kind=small}
(9).png){kind=small}
(9).png){kind=small}