5 KPI Design Best Practice Guidelines [Tutorial]

Table of Contents

Using Business Transformation Consulting To Design KPIs

 

As you move through your SAP career, you will frequently find that the scope of your consulting duties expands, whether you’re prepared for it or not. 

 

This is a good thing, and you, if you’re like me, seek out new challenges constantly. 

 

I guess it comes from my days in the USAF where it was “up or out”.  

 

One of my recent expanded opportunities as a consultant was to work in SAP’s Business Transformation Consulting.  The task was to help a major medical device manufacturer both design a comprehensive solution architecture and design a set of KPI’s and a KPI architecture to support both the existing and planned future SAP and non-SAP business processes

 

Key Performance Indicators Consulting

 

In essence, I was providing KPI consultancy using advanced SAP tools which provided both a business process modelling capability and a KPI design template capability, fully integrated within the tool.

 

Our ultimate business goal was to more than quadruple this client’s revenue in under 5 years, so the ‘stretch’ target was indeed high.

KPI Design Frameworks

There are a number of organizations that provide KPI and business requirements process definitions for the following roles:
 
  • KPI for Solution Architects       
  • KPI for ERP implementations   
  • KPI for Engineering Design     
  • KPI for Designers        
  • KPI for Designer          
  • KPI for Design Departments     
  • KPI for Business Analyst
In fact, there are KPI guidelines for a whole range of roles and industries already pre-defined with agreed upon definitions.   The challenge is, as KPI consultants, is designing the optimal KPI reporting tree for a particular organization with a particular business context.  BI consulting providers, such as ourselves, help elite organizations with this daunting task all the time, all over the world.
 

SAP KPI Design Reporting Tool

 
A great KPI design tool SAP provides is a little used tool called the Solution Map Composer, now upgraded and replaced by the Industry Solution Composer.  It provides expert users a multitude of functions, including, as it turns out, an ability to do lookups that in reverse shows the KPIs associated to each SAP standard business process. It's great for coming up with a:

  • KPI for design and development
  • KPI for design department
  • KPI for design engineer

and many more.

 
If you don’t already have and know this tool, I recommend you download it (works best on a windows machine) and get acquainted with it. 
 
The basic concept is that it aligns SAP standard business processes in swim lanes and you can explore the linkages between and among business processes. 
 

You can also build your customized business process models with this tool. 

 
One of the critical functionalities of the tool is that you can use it as an input into building your blueprint within the SAP Solution Manager, because both make use of the Business Process Repository (BPM)

 

KPI Design and Definition Require Requirements Analysis Expertise

 

When doing an exercise like this, there are some key takeaways with regards to KPI definitions you should keep in mind:

 

  1. You should follow a proven Best Practice approach to defining KPIs which includes:

    strategy
    data
    and technology aspects.

  2. You must ensure your KPI definitions are measurable, have a target, and are meaningful and are actually Key.

  3. When you're are doing top-down KPI requirements collection, ensure your effort focuses on a strategic approach and reflects executives’ vision and the performance metrics they want to focus on.

  4. You must keep in mind and understand that bottom-up KPI requirements collection focuses on tactical and operational goals.  

  5. Top down KPI requirements collection will typically focus on:

    Profitability Metrics
    Performance Management, i.e., creative team benchmarks
    Value-Driven KPIs, i.e., Value Driver Trees

  6. Design Code block elements – Improve transparency in reporting, which will lead to ease in preparation of global consolidated reports.

  7. Hierarchies hide the changes in G/L accounts or changes in the hierarchical organization (done in the source system) from the reports and the report nodes adjust themselves after the changed hierarchy is loaded to SAP Netweaver BW or SAP HANA.

  8. Reporting through hierarchy sets is a functionality where reports are built using hierarchies created on various characteristics.

KPIs Belong to a Position (But a Person will be Assigned to that Position)

All KPIs should also have an owner.  However, an owner should really be a position. Who currently holds the position is not all that important. Experience has proven, that over time, the person who holds a position and who provided the definition of the KPI will eventually move. 

Positions may also be eliminated or re-designated, as frequently happens in any corporation, but the task frequently still needs to get done. 

It is therefore imperative to have a solid KPI design document.  

This will form the basis for your SAP BW datawarehouse design and in the case of business concerns which fall under Title 1 CFR Part 11 (typically medical or pharmaceutical manufacturers), provides a clearly defined testing pathway, which can be used to satisfy government reporting requirements. 

Many Industries Require This Level Of KPI Track and Trace

Other critical industries where you might need to provide this level of detailed KPI definition and ownership track and trace is within the aviation Maintenance Repair, and Overhaul (MRO) sector, or any other industry where critical maintenance must take place, which can range from Railroads to Oil Refinery and Pipeline operations.

 

As you can see, defining KPIs and tracking them, never mind getting your system to report them, is a challenging undertaking.  Just keep the best practices in mind when defining them and you’ll do fine.

 

If you're getting ready to start your own KPI definition exercise, you can use our KPI Sweep Whitepaper, which provides a tried and proven framework for identifying the right KPIs while eliminating the useless ones.  In effect, it is an 80/20 approach to KPI design.

 

Define Your Corporate  KPI Requirements

 

 

People Who Read This Also Read:

10 Advanced SAP BW Project Estimation Techniques

17 Tips For Creating Clear SAP BW Requirements

Define Your SAP Webi Requirements

Business Process Requirements Specification Template

7 Questions Typically Answered By A BI Strategy

 

Do you have other KPI design and definition experiences you would like to share?  Or other approaches you have used to define your reporting hierarchy.

 

Thanks

 

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie Ayers

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie Ayers

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.