Back to insights

Clarify the data before building the dashboard

A precise chart cannot clarify ambiguous data. Establish definitions, quality and ownership before designing the display.

Reading path 7 / 10Digital transformation: from understanding to continuous change

Mojtaba RashnooDigital transformation4 min read
Conceptual green and amber streams becoming clear after passing through a filter
All articles in this path

A dashboard can be beautifully organized and still leave a decision unclear. The charts are precise, the colors consistent and the numbers apparently current, yet two people interpret the same figure differently. The reporting software may not be the problem. Perhaps nobody has agreed what a record represents, when it is recorded or which decision it can support. Establishing meaning comes before displaying data.

Start with a decision, not a chart

In a hypothetical example, a sales manager wants to know which orders need attention. The total number of orders does not answer that question. Payment status, the promised delivery time and the latest contact might matter more. Without a clear decision, every available column becomes a candidate for display, turning the dashboard into a neatly arranged information store.

GOV.UK's outcome-measurement principle connects metrics to the problem a service should solve and to user research. The editorial suggestion here is to give every indicator a decision sentence: if this value changes, who will do what differently? An absent answer is a reason to reconsider the indicator. GOV.UK: measuring service outcomes

Give a shared word a shared definition

A completed order might mean payment received to the sales team, goods dispatched to operations, and acceptable delivery to the customer. A chart cannot settle that difference on its own. Write down the definition, the beginning and end of the period, exceptions and the recording source. Test the definition against actual records rather than relying on apparent agreement in a meeting.

A small indicator sheet can capture its name, purpose, definition, source, update timing and correction owner. The definition must still work when an order is returned or payment arrives late. This is not a proposal for another layer of bureaucracy. It is a way to prevent meaning from changing unnoticed when people move roles or another spreadsheet appears.

Complete does not necessarily mean correct

The UK government's data-quality framework treats quality as fitness for a purpose and distinguishes completeness from accuracy. Filled fields do not prove that the values are right. That distinction lets us name the issue more precisely: an invalid value, duplicate record, old date and missing essential information require different responses. UK government data-quality framework

In the hypothetical sales example, an order identifier might be duplicated or dispatch status might be recorded late. That delay could matter for an immediate decision, while a different limitation matters for a longer-term trend. The entire organization's data need not become perfect before the first report. Identify the gaps that could change this particular decision, and make those gaps visible and traceable.

Keep responsibility alongside the number

Knowing that a value is wrong achieves little if nobody has authority to correct it. Establish how an issue is reported, who investigates it and when the correction reaches the report. Do not conceal the latest update time or important limitations in the interface. A clearly explained number is more actionable than an apparently certain figure stripped of context.

The first dashboard can remain small: a few relevant indicators, accessible definitions and a correction route. Observe a real decision meeting to see where discussion returns to guessing and which information was missing. Add a chart in response to that observation, not to fill the screen. Data becomes valuable when it supports shared understanding and a specific action, not merely an attractive display.

Sources and further reading