Aggregated Values of KPIs in a Single Indicator – Case Studies

One of the main purposes of a KPI scorecard is to calculate the performance value. Technically it is possible to calculate the performance of:

  • A single indicator.
  • A group of indicators (container), and even
  • The performance of the whole scorecard.

Several single values can be aggregated and presented as a new performance index. We recommend that you be careful about this approach, below are some case studies with our users that illustrate good examples of how such indexes can be created and used.

Combining strategic single values

We use BSC Designer to manage strategic and operational KPIs. These indicators are updated weekly, monthly and yearly. We plan to use the software for the evaluation of single values as well.

 Check out LinkedIn Profile Pablo Avegno, Systems Manager, Ventalum, Argentina

We are evaluating BSC Designer and if it fits our needs we are going to implement it into our business processes. The first goal is to transfer the balanced scorecard that we have now in an Excel file to the BSC software. The complicated part may be to create single indicators that will incorporate the aggregated values of other KPIs. For example, in Excel I can consolidate values from different lines by summarizing them and I have to see how to do this with BSC Designer.

A note from developers

Thank you for sharing a detailed implementation plan for BSC Designer and the Balanced Scorecard. I believe BSC Designer will provide all of the necessary features to support your decision. As for MS Excel, I know that a lot of companies use it for a prototype and basic BSC, but then people prefer to move up to a professional BSC Software. Some users reported that BSC Designer helped them to avoid home-made Excel spreadsheets, others say that scorecards in Excel were difficult to maintain or it was too complicated to update Excel spreadsheet with a new information.

I think moving up from Excel to BSC Designer will be a smooth process:

  1. You can get your data from Excel. You can decide whether to import all the data or link a certain KPI to a specific value in Excel.
  2. As for working with aggregated values, you can follow the same idea as in Excel. You can specify a formula for a KPI where you can, for example, summarize the values of other KPIs.

Also, you mentioned that KPIs in your scorecard will have a different update interval. In BSC Designer you can specify an update interval for each KPI and the program will inform you about an upcoming upgrade deadline.

Update panel in BSC Designer

That is a simple notification. You can also create special alerts that will inform you about important changes in the KPIs via email.

Building Overall Index to Measure Supply Chain Performance

We used BSC Designer to build an overall index to measure the Supply Chain department performance. There must be an option to use the weight factor.

Jiri Kratochvil, Manager Supply Chain Projects, PMI, Czech Republic

I was searching for a tool, which would help me to build an overall index for Supply Chain department performance. BSC Designer seems to be the right tool – easy to use and also to share with others. So far, I was trying to prepare something similar in MS Excel, however it was too complicated to update with new data. I will see if your BSC Designer will satisfy all of my needs.

A note from developers

Jiri, I thank you for your feedback and opinion about BSC Designer. MS Excel is a popular business tool and there a lot of business professionals who keep their data in Excel Spreadsheets, as for the Balanced Scorecard, it is not really suitable for that task. One can manage to build their formulas and link them, but when it comes to multilevel KPIs or scorecards then the process is a nightmare.

With BSC Designer sharing vital BSC information is easy. You can generate an HTML report and share it with your colleague. Or you can sign up with BSC Designer Online and share the whole project with anyone from your team that has a PC or a tablet with an access to the Internet.

You mentioned that one of your goals is to build an overall index to measure the performance. Although this approach is very popular in the business world, it has its own problems, and doesn’t give a big picture.

Why most KPIs don't work and what to do about this

For sure, you can use BSC Designer for building an overall index, but I would suggest adding a strategy map with some key indicators on it something similar to what was explained in this article.

Determine the Impact of Intervention Factors on the Finance with BSC

BSC Designer product gives us the possibility to determine the impact of intervention factors on the financial results.

Roger Jean, Principal consultant, WATCH-Consultancy, Netherlands

Your product, the BSC Designer is very easy to use and creates possibilities to determine the reciprocal influence of several factors on the total result of an organization.

For us as consultants, BSC Designer is a very important tool to give insights in complex business situations. We can measure the impact of our interventions on the end results.

A note from developers:

Thank you for your feedback. How did you determine the impact of intervention factors? I think that you used a weight value that each indicator and category have in BSC Designer. In this way one can specify the relevant important of each indicator. BSC Designer calculated the relevant importance taking into account the weight of an indicator, as well the weight of its category. This whitepaper explains in detail how the weight is used in calculations and what formulas are used to calculate a final performance.

Change item's weight using weight field in item's properties

A strategy map in BSC Designer has several placement styles. Besides a classical Balanced Scorecard there is a placement style that allows presenting a hierarchy of KPIs in a form of the tree. This type of map is also useful to present indicators and show how they influence on each other.

Related Articles

Posted in BSC Designer Testimonials

What is BSC Designer?

BSC Designer is a balanced scorecard software available as a cloud-based service and Windows desktop application.

Getting Started with BSC Designer

Try BSC Designer for free

Download BSC Designer

Who uses BSC Designer

According to our users, BSC Designer is easy to install, configure and it helps a lot with Balanced Scorecard, strategy maps, and KPIs.

BSC Designer Customers

Training for the software

To make it easier for the users to get started, we have a lot of free training materials for the software.

Video manuals for BSC Designer

Customer support

Should you have any questions, we are at your disposal.

Pricing and buying

How much does BSC Designer cost? It depends on the configuration that you prefer. Use this price calculator to find out the total cost, get an official quote, and buy the software.

What Balanced Scorecard is all about?

Fast Track explains complex ideas in a simple way Check out Strategy Scorecard Fast Track to find easy explanation of the most important complex ideas.
  • What is a Balanced/Strategy Scorecard?
  • How to build a good strategy map?
  • How to find winning KPIs?
  • How to cascade strategy?
  • How to implement scorecard
Learn all the nuances quickly and ask follow-up questions to BSC expert. Learn more...

What are your current challenges?

We help our users to get started with Balanced Scorecard, strategy maps, and KPIs. Here is a list of frequently asked questions and respective answers to them.

Q: What is the Balanced Scorecard?

Big picture about Balanced Scorecard A: Check out: Get the big picture about Balanced Scorecard article.

Q: I'm looking for a KPIs... how do I find good ones for our business?

How to find a KPI for... A: Check out our recommendations.

Q: Do you have some examples of the Balanced Scorecard?

Examples of Balanced ScorecardA: Sure, we have some here.

Q: Balanced Scorecard is about strategy execution, right? But what is a strategy?

Define strategy, create strategy mapA: Check these articles about strategy definition and creating strategy map.

Q: How do we cascade our top level scorecard throughout the company?

How to cascade a strategy mapA: Do it by business goals, some examples will also be useful.

More questions and answers...

BSC Lessons

Download BSC Designer and we will follow up with you with lessons about the Balanced Scorecard:

BSC Designer experts

Aleksey Savkin Performance Management and Balanced Scorecard

Kazim Ladimeji HR KPIs and Performance Expert

Levi Newman Effective KPIs and social metrics

Oana Boteanu Performance Management

Oleg Tumarkin Business Measurements

Upcoming events and talks

We organize, sponsor, and participate in various events related to the strategy execution.

  • "Building Balanced Scorecard Step by Step." 15th February, 2017, online training. Read more...

Drop us a note if you want to meet up at these events.

Online training: Build BSC step by step

The best way to get started with the Balanced Scorecard is to join our online training.

Balanced Scorecard Training Online Strategy map, KPIs, cascading - it might be hard to put it all together. In the online training "Building BSC Step by Step" we explain all the nuances in simple words and help companies to build a prototype of their balanced scorecards.

Find us on Google Plus

Thank you for sharing!

Whether you are looking for a professional Balanced Scorecard software, or just researching information about Balanced Scorecard and business strategies, we recommend you to download and try our BSC Designer software (no credit card is required).

We will follow up with you with lessons about the Balanced Scorecard and will keep you informed about the trending articles on bscdesigner.com

Follow us in Social Media

Send this to friend

More in BSC Designer Testimonials
Modeling Business Environment with Balanced Scorecard

When we are talking about Business Scorecard we are actually talking about some model of the business environment. It might...

Balanced Scorecard Weaknesses: External Factors are not Considered

I'm manager in a bank of Iran and I'm a lecturer in MBA courses and use BSC in our strategic course. I'm...

Close