• En
  • АГЕНТСТВО
    • Agency
    • Агентство
    • Презентация
    • Портфолио
    • Behance
  • ← Блог

infographer

  • Теория
  • Примеры
    • Примеры
    • Критический взгляд
  • События
    • Текущие события
    • Прошлые события
  • Инструменты
  • Книги
    • Книги
    • Книжный магазин
  • Новости
я Business infographics @en

Visual dashboard for managers. Or how to make a top manager’s reports simple and obvious

12
Comments
Linkedin
0
ВКонтакте
0
Pocket

Андрей Покатаев

Meet Andrey Pokataev’s guest post. Andrey — is a consultant on strategy and management with many years of experience in Russian consulting companies, as well as in the banking sector.

As a consultant, I was fortunate enough to run the project on the development of Balanced Scorecard for a Russian bank. One of the results of that project was the so-called manager’s personal card — collection of personal Key Performance Indicators (KPI) of a top manager at a bank’s business unit, which indicates its relative weight,  plan and percent of actual performance.

Key performance indicators determine how a top manager executes strategic objectives of the bank in its business division. Based on these indicators top manager would receive an additional bonus.  So each of the indicators, in addition to the percentage of completion, was assigned with the relative weight on the personal card; those weights should not be less than 5%, so the manager shouldn’t be given too many of the key performance indicators.

In addition to the key performance indicators, there were two diagnostic indicators on the personal card. The task for the manager was to keep these parameters within certain limits.

Here is an example of such personal card:

приборная панель стандартными средствами

As you can see, this is a common table in Excel in it quite a usual state. The client fully agreed with this outcome, because it presents all the necessary information showing clear content, without unnecessary complications.

At the same time, as noticed by Infographer.ru, seeing these raw results looking as a mass of cells, the table becomes difficult to read. Of course, Irina has expressed it much simpler and more succinct: «Tablets… oh.»

Accepting this challenge, based on this table, I decided to make a visual dashboard of a manager in PowerPoint (main instrument to display data). This visual dashboard is automatically updated from the original Excel file (basic tool to calculate data).

And this last point becomes crucial, since it is often necessary to update KPI in several presentations and instantly change its values. Such technique becomes helpful when, for example, the KPI is estimated frequently, or there is a sudden change an hour prior to the presentation in bank’s Boardroom. But, at times, the client is not always willing to pay for extra software. It is fairly easy to implement it with a simple table, but with nice looking speedometers it is not always as simple…

 

In the end, it took some work, but in result these are three full-working versions of the performance dashboard.

Version 1: Simple and familiar

 

приборная панель, дэшборд

The first version is the most simple and obvious: by removing unnecessary numerical data it shows the change in more difficult (less than 80% completed) KPI on the charts. The rest of KPI are shown as small speedometers, and the diagnostic indicators (which have to be located within a certain range, as human’s temperature) — in the form of thermometers (constructing instructions).
As you can see, the bar charts show the raw data of  KPI for past periods and comparative figures for the market. On speedometers and thermometers, planned values ​ of​ KPI marked gray. And best of all, all the data up to the last letter, is updated when it is changed in Excel without any participation of analysts. Convenient, isn’t it?

Version 2: Innovative and conceptual

приборная панель, дэшборд

The main visual in this version is the pie chart (constructing instructions), which shows not only the percentage of completion KPI, but also the relative weight of the KPI on a personal card. Looking at this chart, manager can see what KPI require attention and how important these KPI are for him. And again, all data is updated automatically when the Excel file is modified, including the signatures of the chart.

Unfortunately, the diagram itself is still a little unfamiliar. So for clarification,  the explanation is provided in gray. In result, we got a visual schedule that catches the eye on the dashboard.

Version 3: Clear and minimal

приборная панель, дэшборд

In this version, I was able to get away from the original data table completely and, without any loss of information, to show the actual values ​​of all KPI as speedometers. Simple, clear and interesting. Moreover, it was possible to show explicit relationship between the indicators and strategic objectives of a top manager. I placed this version of the dashboard third in the presentation specifically for the reader who is tired of tables, which would make him say, «Wow! Cool! «.

Although, the text and the percentages of a personal card are changed manually, it is relatively easy to make them automatically updated from Excel.

In the end, I did what I wanted to do: an obvious and automatically updated dashboard for a top manager. Moreover, I made it in three different versions, so the client had a choose.

Many thanks to Irina Dobrova and Maxim Gorbachevskiy for this blog, which was the main source of information at work. Also thanks for personal consultation!

If you have any questions, I am ready to respond to them in the comments or by e-mail: andrey.pokataev @ rambler.ru.

Andrey Pokataev

Manager’s Dashboard

View more presentations from Andrey Pokataev

Дек 5, 2011Ирина Доброва
Статья была интересной?
  • Поделюсь (0)
  • Полезно (0)
  • Бесполезно (0)
  • Банально (0)
BildfahrplanИнфографика - это тренд
Главная Книги Visual dashboard for managers. Or how to make a top manager’s reports simple and obvious
11 г. назад 12 я Business infographics @endashboard
facebook-profile-picture
Ирина Доброва

Основатель и идеолог агентства Infographer

Сайт Фейсбук Instagram
  • thank you for a great blog auvlbvjnrb click here :[ cjsbocsc, >:o rdggpgdpmk [url=»http://www.tjrvjszomrqh.net»]or here[/url] :) vfjfvkqsqhgp, :[ jvjjkhvywh http://tjrvjszomrqh.info O:-) biazhec, B| kofuhbiink [url=http://tjrvjszomrqh.ru]lfxbemkxlh[/ur

    umiiksbkrmdv

  • fuutmomcyaub

    sieroogyyiml

  • this is just a fantastic theme cqnwvzgwhr click here :-( vyahgxehzhvg, ;) epqrmgclwf [url=»http://www.yhgcimxccpds.net»]or here[/url] :-D xsjtgkoo, :-D hhfbtohoep http://yhgcimxccpds.info :( xsjtgkoo, O:) ukoqmcjhkh [url=http://yhgcimxccpds.ru]duwokdggqr[

    bjotnmvwlsbv

  • is this a themeforest theme? pwafaurxra click here :-( teesebt, 8-| otuqopzdqd [url=»http://www.xzktpmmuzpuj.net»]or here[/url] :-X paphkohpsbrs, :-/ ihguszfwtj http://xzktpmmuzpuj.info 8| paphkohpsbrs, :/ kyaxmazone [url=http://xzktpmmuzpuj.ru]rbliwpimct

    ridbksdovjcj

  • azfdvhyhaxch

    mjprfluywwfz

  • wonderful site thanks qeiykhmqwc click here >:-O dhuaitdjjcza, :/ cwpgjmjqwq [url=»http://www.xmpqdulorcea.net»]or here[/url] >:-O dlhed, >:-O dzfaxvpwvj http://xmpqdulorcea.info O:) gdvhjcet, >:o ouvuaubcfy [url=http://xmpqdulorcea.ru]zykencn

    tgaexbkfhgdx

  • dtdbccdjqbhy

    ghfbhknriegi

  • awe-inspiring post krerjtjwjd click here

    hzkuffeqvwvr

  • drcahkylndks

    pmghsisvwqpu

  • eqnfzznscjzj

    llbxbbbdzasb

  • данабол где купить

    Thanks для обмена вашего Info . Я действительно
    ценим ваши усилия, и я будет
    ждать ваш далее сообщение спасибо еще раз.

  • Darryl

    What’s up to all, the contents present at this web page are actually remarkable forr people
    knowledge, well, keep up thhe good work fellows.

  См. также  
Инструменты

Wie kann man Dashboards erstellen, die die Menschen gerne gebrauchen?

Was nützt Ihrer Organisation Dashboard? 0

я Visualization theory

How to create a Dash Board that people would enjoy to use?

Part 1: How can the Dash Board be helpful for your organization? 0

Теория

Dash Board / Score Card

Мои попытки подобрать адекватный перевод: Панель управления / сводная таблица ключевых показателей. 0

Инструменты

Wie kann man Dashboards erstellen, die die Menschen gerne gebrauchen?

Was nützt Ihrer Organisation Dashboard? 0

я Visualization theory

How to create a Dash Board that people would enjoy to use?

Part 1: How can the Dash Board be helpful for your organization? 0

События

Infographer рассказал про дэшборды крупному и среднему бизнесу: IBM Cognos Live 2012

По любезному приглашению компании Navicon, Infographer принял участие в форуме IBM Cognos Live 2012. 0

Примеры визуализации

Когда много графиков

Публикую несколько примеров, которые помогали нам работать над бизнес отчетами и дэшбордами. 0

Инструменты

Wie kann man Dashboards erstellen, die die Menschen gerne gebrauchen?

Was nützt Ihrer Organisation Dashboard? 0

Мы в Facebook, ежедневно

Unable to display Facebook posts.
Show error

Error: Server configuration issue
Please refer to our Error Message Reference.
Для авторов
Приглашаем авторов по теме инфографики к сотрудничеству. Политика обработки персональных данных и пользовательское соглашение.
Контакты

Infographer – это агентство инфографики и образовательный ресурс об инфографике. Офисы в Москве и Гааге, работаем для клиентов со всего мира (контакты).

Адрес: Москва, Ленинский просп. 30А

Телефон: +7 916 628 47 64

Имейл: mg@infographer.ru

Пишем для вас с 2009 года © Infographer, при перепечатке ссылка обязательна. 16+