How do I design indicators for measurement data presentation?

In the design of enterprise measurement system, many enterprises often do not pay much attention to the data presentation, the following examples illustrate how to design metrics data indicators.

For example, the department manager is concerned about the progress of each project in the department and wants to know the progress of each project through the measurement data. For this requirement, we design a metric analysis graph (indicator) that meets its needs. A careful discussion and analysis of this measurement requirements can be obtained: The department manager would like to display in the Department of each project's duration deviation days, deviation%, and for the number of days deviation of more than 10 days, the deviation rate of more than 15% to be marked out.

To meet the above requirements, the initially conceived indicator is:

Scenario 1:

The horizontal axis is the project, the ordinate is the deviation of the number of days and%. But in this figure does not reflect the total number of days of the project, if some project deviation rate is very large, and the actual deviation days is very small, may not take measures, so hope to gross position days also manifested in the inside, so, and improved to:

Scenario 2:

Horizontal axis or project, ordinate is the total number of days, deviation days, and the deviation%. By the total number of days of the project, the total number of days is a histogram, for a color (such as light blue), deviation days in total days, if the extension of more than 10 days, is the red column, if not exceeded, the extension of the number of days is yellow. The% of the delay, marked on the chart with a circle. Draw 15%, 10 day two control lines on the graph.

This picture is a bit messy and not suitable for simple reading, so you need to look for a better design solution.

Scenario 3:

In this figure, the upper part is the histogram of the deviation days and the total number of days, sorted by the total number of days from large to small. The bottom half of the histogram, the collation and the same, the ordinate is the deviation rate. The bars of the deviation days below 10 days are yellow, and more than 10 days are red colors to remind the manager of the attention. In the lower part, the deviation rate is less than 15% is yellow, more than 15% is red, negative or 0 are green display.

In this indicator, for the same project, only the upper and lower parts are green, it is normal, if all red is seriously out of the plan, if it is a yellow is out of the plan.

The above completes the outline design of the indicator, then can be in excel in the final solution to do the physical implementation of the design.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

How do I design indicators for measurement data presentation?