Skip to content
DWKD
Lesson · The full series

Design a dashboard around one decision

You will learn

Dashboards get opened twice: once when they launch and once when somebody asks about them. Building around a single decision is what makes one get opened on a Tuesday.

Intermediate 20 min Data
Make the numbers hold up Lesson 5 of 5

Most dashboards get opened twice. Once in the meeting where they launch, and once months later when somebody asks whether anyone uses them. In between, the people they were built for go back to asking a colleague, because asking a colleague answers a question and the dashboard answers eleven.

The failure is almost never the charts. It is that the thing was commissioned as a display of available data rather than as an instrument for a decision, and nobody noticed the difference until it was built.

Name the decision and the person who makes it

Write it on one line before you open anything. “Every Monday, the operations lead decides which three of this week’s jobs need a second pair of hands.”

Now you have a test for every element you are about to add: does this help that person, on Monday, choose those three? Most of what a stakeholder asks for will not, and you now have something better than an opinion to say so with.

Two symptoms tell you the decision has not been named. The dashboard has a section per data source — a CRM panel, a finance panel, a support panel — which is the org chart drawn in charts. Or it has a filter for everything, because nobody knew which view mattered, so the reader was handed the job of finding out.

If you cannot name the decision, the honest deliverable may not be a dashboard at all. A weekly figure in an email, or a single alert that fires when something crosses a line, beats a page nobody opens. Both are also far cheaper to keep alive.

Not everything is a chart

A single current value is a stat tile: the number, its change, and at most a sparkline. It is not a one-bar bar chart, which wastes the most valuable area on the page to say one thing badly.

A handful of headline numbers is a row of those tiles, not a grouped bar chart. A single ratio against a limit is a meter, not a two-slice pie. And more than about seven categories that all carry meaning is a table, possibly beside one chart — not more colors.

The lead number gets to be large. Forty-eight pixels or more, alone, at the top. Almost every dashboard buries its most important figure in a grid of equals and then asks the reader to know which one matters.

That is the opening. The rest of the lesson — the remaining sections, the exercise and the check-your-understanding questions — is behind the gate below.

This lesson requires full access.

Create an account to explore the published free lessons. This lesson requires full access; signing up does not purchase access or enroll you in Academy.