Columns

The 10 ways of KPI

There’s a lot of talk these days about Key Performance Indicators (KPIs). They are the backbone of scorecards and dashboards, which organizations use to present performance information to executives and staff. Unfortunately, BI developers seem to focus more on creating visual metaphors than on understanding what constitutes a good KPI that delivers long-term value to the firm.

Part of the problem is that people use the terms “KPI” and “metric” interchangeably. A KPI is a metric, but a metric is not always a KPI. The key difference? KPIs reflect strategic value drivers, whereas metrics may represent the measurement of any business activity.

When developing KPIs for scorecards or dashboards, you should keep in mind that KPIs possess 10 distinct characteristics. Although metrics may exhibit some of these characteristics, good KPIs possess all of them.

1. KPIs reflect strategic value drivers. Value drivers represent activities that, when executed properly, guarantee future success. Value drivers move the organization in the right direction to achieve its stated financial and organizational goals. Examples of value drivers might be “high customer satisfaction” or “excellent product quality.”

In most cases, KPIs are not financial metrics. Rather, KPIs reflect how well the organization is doing in areas that most impact financial measures valued by shareholders, such as profitability and revenue. As such, KPIs are “leading” not “lagging” indicators of financial performance. In contrast, most financial metrics are lagging indicators of performance.

2. KPIs are defined by “executives.” Executives define value drivers in planning sessions that determine the short- and long-term strategic direction of the organization. To get the most from these value drivers, executives need to define how they want to measure their organization’s performance against these drivers. Unfortunately, too many executives terminate strategic planning sessions before they define and validate these measurements, otherwise known as KPIs.

3. KPIs cascade throughout an organization. Every group at every level in every organization is managed by an executive whether or not the person carries that title. These executives may be known as “divisional presidents,” “managers,” “directors” or “supervisors,” among other things. Like CXOs, these “executives” also need to conduct strategic planning sessions that identify the key value drivers, goals and plans for the group. At lower levels, these elements may be largely defined and handed down by a group higher in the hierarchy.

However, each group’s value drivers and KPIs tie back to those at the level above them, up to the level of the CXOs. In other words, all KPIs are based on and tied to the overarching corporate strategy and value drivers. In this way, top-level KPIs cascade throughout an organization, and the data captured by lower-level KPIs roll up to corporate-wide KPIs. This linkage among all KPIs, which can be modeled using strategy mapping software, supports flexible analysis and reporting at any level of granularity at any level of the firm.

4. KPIs are based on corporate standards. The only way cascading KPIs work is if an organization has established standard measurements. But it can take organizations months if not years to hash out the meaning of key measures or entities. For example, functional representatives at a major U.S. airline spent months trying to agree on the meaning of “flight” and “segment,” and their entire analytical infrastructure was put on hold until they achieved consensus. In some cases, organizations can only agree to disagree and use meta data to highlight the differences in reports. Only with enough top executive support can organizations overcome the political obstacles associated with standardizing definitions for commonly used KPIs.

5. KPIs are based on valid data. When pressed, most executives find it easy to create KPIs for key value drivers. In fact, most industries have a common set of metrics for measuring future success. Unfortunately, knowing what to measure and actually measuring it are two different things. Before executives finalize a KPI, they need to ask a technical analyst if the data exists to calculate the metric and whether it is accurate enough to deliver valid results. Often, the answer is no. In that case, executives either need to allocate funds to capture new data or clean existing dirty data. Or they need to revise the KPI. Providing cost estimates for each approach helps executives to decide on the best course of action.

6. KPIs must be easy to comprehend. One problem with most KPIs is that there are too many of them. As a result, they lose their power to grab the attention of employees and modify behavior. According to TDWI research, the median number of KPIs that organizations deploy per user is seven. More KPIs than this makes it difficult for employees to peruse them all and take requisite action.

In addition, KPIs must be understandable. Employees must know what is being measured, how it is calculated and, more importantly, what they should (and should not) do to positively effect the KPI. This means that it is not enough to simply publish a scorecard; you must train individuals whose performance is being tracked and follow up with regular reviews to ensure that they understand and are acting accordingly.

7. KPIs are always relevant. To ensure that KPIs continually boost performance, you need to periodically audit them to determine usage and relevance. If a KPI isn’t being looked at, it should probably be discarded or rewritten. In most cases, KPIs have a natural life cycle. When first introduced, the KPI energizes the workforce and performance improves. Over time, KPIs lose their impact and should probably be revised. Most organizations review and revise KPIs quarterly.

8. KPIs provide context. Metrics always show a number that reflects performance. But a KPI puts that performance in context by evaluating the performance according to expectations. The context is provided using thresholds, targets or benchmarks that can be based on industry-wide measures or various methodologies, such as Six Sigma. In addition, most KPIs indicate the direction of the performance, either “up,” “down” or “static.”

9. KPIs empower users. It is commonly stated that you can’t manage what you don’t measure. But a corollary is that you can’t manage what you don’t reward. To be effective, KPIs must have incentives attached them. Almost 40% of firms surveyed by TDWI state that they restructured incentives systems when implementing KPIs. However, it’s important not to link incentives to KPIs until the KPIs have been fully vetted. Often, KPIs must be tweaked or modified before they have the desired effect.

It’s also critical to revamp business processes when implementing KPIs. The business process needs to empower users to take the appropriate action in response to KPIs. The last thing you want is informed but powerless users. That’s a recipe for disillusionment and poor morale. Forty percent of organizations said they modified business processes when implementing KPIs, according to TDWI research.

10. KPIs lead to positive action. Finally, KPIs should generate the intended action -- improved performance. Unfortunately, many organizations allow groups to create KPIs in isolation, which leads to KPIs that undermine each other. For example, a KPI for a retail store might track stock outs (when there is not enough merchandise on hand to meet demand) but the regional warehouse is incented to carry minimal inventory. If the regional warehouse does too good a job, it may not have enough inventory to keep the retail shelves stocked when there is a surge in demand for certain merchandise.

Another problem is human nature. People will always try to circumvent KPIs and find loopholes to minimize their effort and maximize their performance and rewards. Good KPIs are vetted before deployment, and are then closely monitored to ensure that they engender the intended consequences.

I hope that you have been convinced that KPIs are a breed apart from your run-of-the-mill metric. While an organization may have hundreds, if not thousands of metrics, it should only have a few dozen KPIs that focus employees on the key activities that deliver the most value to the organization.

KPIs enable top executives to communicate the mission and focus of the organization. When KPIs cascade throughout an organization, they ensure that everyone is marching together -- and in the right direction --to deliver the most value to the organization as a whole.

About the Author

Wayne W. Eckerson is director of education and research for The Data Warehousing Institute, where he oversees TDWI's educational curriculum, member publications, and various research and consulting services. He has published and spoken extensively on data warehousing and business intelligence subjects since 1994.