---
title: 5 KPI Design Best Practice Guidelines [Tutorial]
description: Learn 5 best practices for KPI design. Align your KPIs with business goals and boost performance. Click for expert guidelines and drive success now!
---

[SAP BW|BOBJ|Project Management Blog ](https://www.sapbwconsulting.com/blog)

# [5 KPI Design Best Practice Guidelines [Tutorial]](https://www.sapbwconsulting.com/blog/5-kpi-design-best-practice-guidelines)

 Written by [Lonnie D. Ayers, PMP](https://www.sapbwconsulting.com/blog/author/lonnie-d-ayers-pmp) | Wed, Jan, 30, 2013 @ 10:30 PM

## Using [Business Transformation Consulting](https://www.sapbwconsulting.com/blog/inbound-marketing/how-to-uncover-sap-services-opportunities) To Design [KPIs](https://www.sapbwconsulting.com/business-ratio-kpi-formulas-financial-formulas)

 

As you move through your [SAP career](https://www.sapbwconsulting.com/blog/12-easy-steps-to-being-a-better-sap-consultant), you will frequently find that the scope of your [consulting duties](https://www.sapbwconsulting.com/blog/8-value-based-questions-for-real-estate-management-software-solutions) 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](https://www.sapbwconsulting.com/blog/senior-executives-use-strategic-analysis-to-create-shareholder-value) 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](https://www.sapbwconsulting.com/blog/inbound-marketing/12-sap-crm-content-management-system-requirements) was to work in [**SAP’s Business Transformation Consulting**](https://www.sapbwconsulting.com/blog/inbound-marketing/4-ways-to-bring-digital-innovation-to-your-company).  Specifically, I followed the [SAP KPI Design Process](https://www.sapbwconsulting.com/hire-sap-business-intelligence-consultant) using a [specialized SAP tool](https://www.sapbwconsulting.com/blog/value-stream-mapping).

 

## Aggressive Business Goals

 

The task was to help a major medical device manufacturer both design a comprehensive [solution architecture](https://www.sapbwconsulting.com/blog/inbound-marketing/does-pci-dss-compliance-affect-you) and design a set of [KPI’s](https://www.sapbwconsulting.com/blog/inbound-marketing/3-marketing-routes-to-reach-your-crm-goals) and a [KPI architecture](https://www.sapbwconsulting.com/developing-balanced-scorecards) to support both the existing and planned future [SAP](https://www.sapbwconsulting.com/blog/sap-support-companies) and non-SAP [business processes](https://www.sapbwconsulting.com/enterprise-services/sap-industry-solutions/business-requirements-analysis). 

 

## Key Performance Indicators Consulting

 

In essence, I was providing [KPI consultancy](https://www.sapbwconsulting.com/blog/learn-more-about-our-sap-business-intelligence-consulting-services) using advanced SAP tools which provided both a [business process modeling capability](https://www.sapbwconsulting.com/business-process-consulting) and a [KPI design template capability](https://www.sapbwconsulting.com/request-sap-business-planning-and-consolidation-sap-bpc-consulting-support), fully integrated within the tool.  In addition, [these tools](https://www.sapbwconsulting.com/blog/inbound-marketing/13-lessons-learned-using-hubspots-workflow-lead-management-system) provide typical [KPI examples](https://www.sapbwconsulting.com/business-ratio-kpi-formulas-financial-formulas-archived-2) for each SAP Supported Business Process.  That means that it indicates the typical [Performance Indicator](https://www.sapbwconsulting.com/blog/12-warning-signs-your-epm-system-is-in-trouble) for a business process, and often provides [industry specific variations](https://www.sapbwconsulting.com/sap-consulting-support) to be aware of. 

 

## Ultimate Performance Measure - Revenue

 

Our ultimate [business goal](https://www.sapbwconsulting.com/blog/inbound-marketing/free-online-sales-and-inbound-marketing-calculator-determine-website-traffic-and-sales-goals) was to more than quadruple this client’s revenue in under 5 years, so the ‘stretch’ target was indeed high.

## [KPI Design](https://www.sapbwconsulting.com/enterprise-services/sap-industry-solutions/business-reporting-requirements-analysis) Frameworks

 There are a number of organizations that provide [KPI](https://www.sapbwconsulting.com/blog/how-to-determine-your-fully-loaded-cost-rate) and [business requirements](https://www.sapbwconsulting.com/enterprise-services/sap-industry-solutions/business-requirements-analysis) 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](https://www.sapbwconsulting.com/blog/inbound-marketing/unique-techniques-to-increase-your-company-revenues)

In fact, there are [KPI](https://www.sapbwconsulting.com/blog/inbound-marketing/5-best-ideas-how-business-can-grow-with-video) guidelines for a whole range of roles and industries already pre-defined with agreed upon definitions.  This provides a great starting point for any [KPI design](https://www.sapbwconsulting.com/blog/business-reporting-requirements) exercise.    The challenge is, as KPI consultants, is designing the optimal KPI reporting tree for a particular organization with a particular [business context](https://www.sapbwconsulting.com/blog/inbound-marketing/22-critical-lessons-learned-for-conducting-pre-sales-demos).  SAP 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](https://www.sapbwconsulting.com/blog/inbound-marketing/what-do-sap-consultancies-do) 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 the Design Department
- KPI for Design Engineering

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](https://www.sapbwconsulting.com/request-sap-functional-consulting-support) 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 (BPR)** . 

 

## 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 [KPI](https://www.sapbwconsulting.com/business-ratio-formulas-financial-formulas)s which includes:
   
   [Strategy](https://www.sapbwconsulting.com/blog/five-forces-model)  
   [Data](https://www.sapbwconsulting.com/blog/10-sap-data-migration-mistakes-to-avoid)  
   and Technology Aspects.
2. You must ensure your KPI definitions are **measurable**, have a **target**, and are **meaningful and are actually Key.  **There are many [performance metrics](https://www.sapbwconsulting.com/blog/inbound-marketing/how-to-correctly-calculate-conversion-rate-3-easy-formulas-to-use), but few KPIs.**
   
   **
3. When you're are doing top-down KPI requirements collection, ensure your effort focuses on a [**strategic approach**](https://www.sapbwconsulting.com/blog/a-step-by-step-process-for-setting-profit-improvement-goals-using-sap) and reflects executives’ vision and the [**Performance Metrics**](https://www.sapbwconsulting.com/blog/how-to-improve-sap-profitability-management-the-ultimate-guide) 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**](https://www.sapbwconsulting.com/blog/unleashing-business-success-balanced-scorecard-strategy).  
5. **Top down** KPI requirements collection will typically focus on:
   
   [Profitability Metrics](https://www.sapbwconsulting.com/blog/how-to-improve-sap-profitability-management-p2-the-ultimate-guide)  
   [Performance Management](https://www.sapbwconsulting.com/blog/inbound-marketing/hubspot-pipeline-customization), i.e., Creative Team [Benchmarks](https://www.sapbwconsulting.com/blog/understanding-the-difference-between-value-model-and-value-case)  
   [Value-Driven KPIs](https://www.sapbwconsulting.com/blog/inbound-marketing/the-guaranteed-easiest-way-to-calculate-sla), i.e., [Value Driver Trees](https://www.sapbwconsulting.com/blog/9-little-known-factors-that-could-affect-your-profitability)
6. Design Code block elements – **Improve transparency** in reporting, which will lead to ease of preparation of [global consolidated financial reports](https://www.sapbwconsulting.com/sap-fico-consulting).
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](https://www.sapbwconsulting.com/blog/understanding-the-most-common-sap-data-warehousing-concepts) or SAP B/W HANA.
8. [Reporting](https://www.sapbwconsulting.com/blog/how-to-build-a-sap-sem-bps-retail-industry-value-case) 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. 

 

## Organizational Structures Change

 

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](https://www.sapbwconsulting.com/resources/bi-technical-definition/).  

## Datawarehouse Blueprint Design

 

This will form the basis for your [SAP BW datawarehouse](https://www.sapbwconsulting.com/understanding-sap-bw-in-5-minutes) 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](https://www.sapbwconsulting.com/resources/sap-bi-technical-definition). 

## 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](https://www.sapbwconsulting.com/blog/how-to-use-a-project-charter-to-start-a-project) in mind when defining them and you’ll do fine.

 

## KPI Clean-Up

 

If you're getting ready to start your own KPI definition exercise, you can use our [KPI](https://www.sapbwconsulting.com/develop-a-data-governance-framework) Sweep Whitepaper, which provides a tried and proven [framework](https://www.sapbwconsulting.com/blog/data-quality-best-practices-for-effective-sap-bw-reporting) for identifying the right KPIs while eliminating the useless ones.  In effect, it is an 80/20 approach to KPI design.

 

 

 

**People Who Read This Also Read:**

[10 Advanced SAP BW Project Estimation Techniques](https://www.sapbwconsulting.com/blog/10-advanced-sap-bw-project-estimation-techniques)

[17 Tips For Creating Clear SAP BW Requirements](https://www.sapbwconsulting.com/blog/17-tips-for-creating-clear-sap-bw-requirements)

[Define Your SAP Webi Requirements](https://www.sapbwconsulting.com/define-your-sap-webi-requirements)

[Business Process Requirements Specification Template](https://www.sapbwconsulting.com/business-process-requirements-specification-template)

[7 Questions Typically Answered By A BI Strategy](https://www.sapbwconsulting.com/blog/7-questions-typically-answered-by-a-bi-strategy)

 

### Please Leave a Comment or Ask a Question

 

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

 

[View full post](https://www.sapbwconsulting.com/blog/5-kpi-design-best-practice-guidelines)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Lonnie D. Ayers, PMP"
  },
  "dateModified" : "2026-02-06T17:22:57.671Z",
  "datePublished" : "2013-01-30T22:30:00Z",
  "headline" : "5 KPI Design Best Practice Guidelines [Tutorial]",
  "image" : {
    "@type" : "ImageObject",
    "height" : 523,
    "url" : "https://118735.fs1.hubspotusercontent-na1.net/hubfs/118735/Stock%20images/KPI%20-%20Key%20Performance%20Indicator.jpeg",
    "width" : 1000
  },
  "mainEntityOfPage" : "https://www.sapbwconsulting.com/blog/5-kpi-design-best-practice-guidelines",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog of SAP BW Consulting - Business Intelligence, BOBJ, Big Data, Project Management and Staffing"
  }
}
```