Connecting the Dots with Indirect KPIs

07 Aug Connecting the Dots with Indirect KPIs

Share this pageShare on LinkedInTweet about this on TwitterEmail this to someone

Direct vs Indirect KPIs Simple Graphic

 

As business intelligence and analytics continue to add value to supply chain organizations, how do we gain even more value?  With an increase in data and the sources of information – from supply chain systems to customer systems to supplier management systems, a source of business value can be achieved by correlating a group of metrics from disparate systems to provide insight and cause/effect relationships.  Correlating metrics in this manner is called indirect KPIs vs. the conventional manner of developing KPIs referred to as direct KPIs.

First, lets review the difference between direct KPIs and indirect KPIs.

Direct KPIs are the metrics which result from drilling down or drilling up on metrics.  In a typical supply chain organization, an example can be Inventory:

    1. Inventory   (Primary KPI)
      1. RM Inventory     (sub-metric of Inventory)
      2. WIP Inventory   (sub-metric of Inventory)
      3. FG Inventory     (sub-metric of Inventory)

Assuming no other type of inventory exists the business, just adding up raw material inventory, work in process inventory and finished goods inventory calculates Inventory for an organization.  Another example of a direct KPI is Revenue and different kinds of revenue:

    1. Revenue    (Primary KPI)
      1. Revenue by Division     (sub-metric of Revenue)
        1. Revenue by Division by Location    (sub-metric of Revenue by Division)

Most supply chain analytics systems work in this manner, since the data is collected from similar systems and analytics are rolled up in a very straightforward manner.

Indirect KPIs are those which impact KPIs not found within a straightforward “drill-down” or “drill-up” manor; these are KPIs which correlate to or impact other KPIs.  Indirect KPIs are much harder to determine (vs. simply adding up numbers in our earlier inventory or sales examples), but can provide insights into supply chain issues and drive improvements.

Normally, direct KPIs can tell a business what happened, whereas indirect KPIs can help organizations learn what to do differently by connecting the dots to determine factors which truly impact performance.

How to connect the dots

First, start with tribal knowledge.  Ask some basic questions about the key metrics which need improving and any general knowledge of what impacts them:

What causes product to be late?
            Is it delays in manufacturing?
            Poor yields?
            Late suppliers?
            Supplier quality?

Each of the potential reasons open up a new set of KPIs.  Rather than continuing infinitely, drill down and across into the KPIs until a set of actionable KPIs can be focused upon.  Remember:

KPIs just for visibility are interesting, KPIs where action can directly impact a business metric are focus areas.

Once the dots are connected which can lead to a business-impacting metric, determine the data source for all the KPIs in the Indirect KPI trail of dots.  Think out of the box on this trail dots – these may not be static data sources (your ERP system, your accounting system, etc.).  These KPIs can be managed by apps (or mini-apps).  An important factor is how often these KPIs are refreshed.  If 1 KPI is refreshed in real-time and another is refreshed on a quarterly basis, the accuracy and actions-to-take may be harder to develop.

In the example below, the organization is struggling with Adherence to Plan – a metric which defines the date and quantity of finished product to a distribution center.  One of the direct KPIs of Adherence to Plan is Inventory.  A direct KPI of Inventory is WIP inventory.  Since WIP is high, we can access data and metrics from manufacturing and supplier management and determine that poor supplier quality of raw materials is causing rework, causing ATP to fall short.

Connecting the dots with Indirect KPIs

Direct vs Indirect KPIs Connecting the Dots Graphic

 

Summary: Using the above example, by managing Indirect KPIs, we find that supplier quality inconsistency is adversely affecting Adherence to Plan.

 

Share this pageShare on LinkedInTweet about this on TwitterEmail this to someone
5 Comments
  • Collaboration with Context
    Posted at 06:31h, 14 August Reply

    […] the story” example, a KPI may be messaged to a team.  Each member of the team may need access an Indirect KPI to contribute to the conversation.  Such Indirect KPIs may be information from different systems, […]

  • Purpose Built Analytics - Sage Clarity
    Posted at 07:24h, 29 August Reply

    […] data cubes is required.  The ability to access data from very different sources, accessing direct and in-direct KPIs, accessing unstructured data and structured data are facets of purpose build analytics programs.  […]

  • Applying Goal Attainment Principles to Metrics
    Posted at 20:32h, 04 September Reply

    […] an example of taking stoplight metrics to another level – using KPIs which depend on others, or Indirect KPIs as elements into a metrics program to achieve specific […]

  • Siloed Analytics vs. Broad Business Analytics - Sage Clarity
    Posted at 09:34h, 08 January Reply

    […] or KPIs which are not found in a standard “drill-up”/”drill-down” manner are known as Indirect KPIs. The example above shows the use of Indirect KPIs at an individual level. Indirect KPIs can be […]

  • how executives can manage information overload
    Posted at 20:49h, 25 June Reply

    […] Using Indirect KPIs. This sounds very specific, but what we find is that there are numerous pieces of information that really mean minimal to an executive. However, when several small KPIs are correlated, the result can lead to a KPI that an executive can review and make a decision quickly and more importantly, accurately. Indirect KPIs are KPIs which impact other KPIs not found within a straightforward “drill-down” or “drill-up” manor; these are KPIs that correlate to or impact other KPIs. Indirect KPIs are much harder to determine (vs. simply adding up numbers in a typical manner), but can provide insights into supply chain issues and drive improvements.   Indirect KPIs are KPIs that connect the dots. Rather than showing the executing the dots (smaller, tactical KPIs), expose the executive to the already-connected-dots. […]

Post A Comment