ASSL Akili Smart Solutions Limited
Data Engineering

Ninety-eight per cent of a data programme happens before the dashboard

Institutions ask for a dashboard and discover they have bought a question. Here is the order of work that actually produces a number somebody is willing to sign.

Published
Reading
2 minutes
Written by
ASSL Engineering

In short

  • The dashboard is the last two per cent, and the cheapest part.
  • Lineage matters more than visual design: a figure nobody can trace is a figure nobody will defend.
  • Governance decided late is governance never implemented.
  • If two departments disagree on a number, that is a modelling problem, not a reporting problem.

The request usually arrives fully formed. Somebody has seen a dashboard elsewhere and wants one, with these charts, by the end of the quarter. The charts are rarely the hard part.

The order the work actually goes in

Acquisition first: finding every system that holds a piece of the answer, including the ones that are a spreadsheet on a specific laptop. Then cleaning, which is where the schedule usually slips, because the data is not wrong so much as inconsistent in ways nobody documented. Then modelling, which forces the organisation to decide what its own terms mean.

That third step is where the politics live. Two departments reporting different totals for the same quantity are not making an arithmetic error. They are using two definitions, both defensible, neither written down. A data platform cannot resolve that; it can only make it visible and insist somebody decide.

Lineage is the deliverable

When a figure is challenged in a board meeting, the useful response is not confidence. It is the ability to open the number, see the transformation that produced it, and reach the source record in one step. Build that first and the reporting layer becomes almost trivial. Skip it and every disputed figure becomes a two-week investigation.

Governance is not a phase at the end

Ownership, classification, retention and access control are cheap to design in and expensive to retrofit. More to the point, retrofitted governance tends to be ignored, because by then everybody has working habits built around its absence.

What the dashboard is for

Once the foundation exists, the reporting layer should be small. Three to five questions that genuinely drive the institution, answered clearly, opened daily. A dashboard with forty charts is a sign that nobody decided what mattered, and it will be abandoned within a quarter.

Keep reading

Related insights.

Next step

Tell us the decision that is going wrong.

Not the technology you think you need. The decision, who makes it, and on what evidence. We will tell you plainly whether there is a system in it.