Which decision should the indicator support?
Start with a management question before choosing an indicator: Should work be reassigned? Are inquiries waiting too long for follow-up? Where should the team investigate delays? A clear question makes the choice of measurement more specific.
Microsoft's Power BI guidance explains a KPI through a measurable value and a defined target. The useful principle is that a number needs a clear meaning and comparison point. Choosing the management decision, its owner and the conditions for intervention is part of designing your company's review process. K1
Write a KPI definition card
- Purpose and action. Name the management decision, the target or trigger, and the action someone will consider when the trigger is reached.
- Formula and population. Specify units, numerator, denominator, period and exclusions. For on-time delivery, decide how to count cancellations, partial shipments and orders with revised deadlines.
- Source and owner. Name the system or record used for each input, the person responsible for its quality, and how often the data and the decision are reviewed.
Could two people calculate it consistently?
Give every indicator a working definition: name, purpose, calculation, source, period, data owner and review frequency. For a percentage, define the numerator, denominator and exclusions. “On-time delivery” needs an eligible order population, a reference deadline and rules for cancellations or rescheduling.
Record the latest update time. If data is unavailable or the denominator is zero, display “not available” with the reason rather than a zero that suggests a measured result. Agree these definitions before designing the dashboard.
Choose a review frequency that matches the opportunity to intervene: daily operations may need closer attention than a longer-term strategic objective. Use one agreed definition across the team. When it changes, record the date and effect on comparability instead of joining different series as though they measured the same thing.
How do you interpret a result accurately?
Illustrative example, not a client result: 50 orders were due for delivery during a week and 40 arrived by the agreed deadline. Under this definition, on-time delivery is 40 ÷ 50 × 100 = 80%. If the illustrative internal target is 90%, the gap is ten percentage points. That target is hypothetical, not an industry benchmark.
Before proposing a solution, examine the ten orders that missed the deadline. Were delays in approval, preparation or transport? Compare periods using the same definition, and consider whether differences in order mix or volume require explanation.
Percentage points measure the absolute gap between two percentages. From 80% to 90%, the gap is ten percentage points. Relative change divides the gap by the starting percentage, so that same increase is 12.5% relative to 80%. Label which comparison you are using.
Show the count and any important data gaps alongside a rate. A small or changing denominator can make two weeks look very different. Flag late records, partial coverage or a changed definition before drawing a conclusion.
Is one indicator enough?
Choose a small set that covers the important aspects of the decision. In the delivery example, consider timeliness alongside returns or rework, so a focus on speed does not overlook quality. Add a measure of an actionable stage, such as approval waiting time, when it relates to the delay under investigation.
There is no single suitable number of KPIs for every company. Start with what you can measure, review and act on. If an indicator changes no question or decision, reconsider its place on the management dashboard.
What happens after the numbers are presented?
Use the review to address three points: What changed? Which explanation is supported? What happens next, who owns it, and when will it be reviewed? Distinguish a missed target from data that needs correction. An improvement occurring after an action does not, by itself, establish that the action caused it.
DOiT Business Solutions helps connect performance indicators to business objectives and organize management follow-up. Request a free introductory session to discuss the decision you want your measures to support and a suitable scope.
What to do next
Start with the decision, document one repeatable calculation and agree how the team will respond. Review whether the measure still helps after the process or data changes.
Frequently asked questions
How should I set a KPI target?
Use a reliable baseline, the desired outcome, available resources and constraints. Document the target's rationale and review it when conditions change.
Do I need advanced software to start?
Start with a tool suited to your data. Prioritize clear definitions, reliable sources, consistent calculations and review ownership.
Does a green indicator mean there is no problem?
It only indicates that the defined condition was met. Check data quality, underlying details and related indicators before judging overall performance.
Article sources
K1 — Microsoft Learn | Create key performance indicator (KPI) visualizations
Related DOiT work
KPI & Performance Analytics · Coffee manufacturing business development
Related articles
When does your company need a business diagnosis? · Before choosing an ERP: what should your company define?
