KPI decreasing is better with percentage

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Performance Point » KPI decreasing is better with percentage

KPI decreasing is better with percentage

Rate Topic

Display Mode

Topic Options

Author

Message

Franky Leeuwerck

Posted Tuesday, April 19, 2011 5:58 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 8:43 AM
Points: 349, Visits: 467

Dear,

I want to define a KPI that measures the relative amount of freight costs to the amount sold.
The target is to limit this percentage as much as possible, so "decreasing is better".

Let's say that in most cases the freight cost is below 10%.
The best case would be 0% (but unrealistic).
A "good" situation is where we have 5% freight costs.
Bad sales are sales with freight costs above 15%.

What this the best way to model this KPI ? Use a normalized methode, or absolute ? What is the "worst value" ? ..

Franky

Franky L.

Post #1095540

Raunak Jhawar

Posted Wednesday, April 20, 2011 3:04 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

It largely depends upon the factors that the business considers while designing the KPI's.

A business could very well measure KPI for freight as freight/tonnage(this is an arbitrary example)
This is a classic example of relative KPI measure.

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1096161

Franky Leeuwerck

Posted Thursday, April 21, 2011 7:11 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 8:43 AM
Points: 349, Visits: 467

Solved:
When using ratio's (percentages), you should use the "Band by value" scoring pattern. In such case 'a worst value' is not needed in the KPI configuration wizard.

Franky L.

Post #1096960

hamburg113

Posted Friday, April 22, 2011 8:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 24, 2011 1:52 AM
Points: 2, Visits: 2

Hi,

Thanks very much for this comment. It help me to think about my ideals.

Tks again and pls keep posting.

If you want to get more materials that related to this topic, you can visit: KPI examples

Best regards.

Post #1097479

« Prev Topic | Next Topic »

Permissions