Lesson 10 of 15 · Lab
Dashboard design best practices and a checklist
A good dashboard answers the questions one decision raises, in the order the reader asks them, and leaves out the rest. Everything on it should change what someone does. Put the summary first, then the views that explain it, and state the period and any known gaps.
| Check | Passes when |
|---|---|
| Decision | You can name it in one sentence |
| Reader | You know who it's for and how long they have |
| Order | The summary comes first, then what explains it |
| Scope | Every visual answers a question the reader has |
| Labels | Measure, unit, period and any exclusions are on the page |
| Consistency | All views use the same rows and definitions |
Max Thrust, the founder of fictional Vandelay Coffee Supply, has 30 seconds with this draft of six visuals. He needs to know how much net value Q3 brought against target, which region leads and since when.
Which two of the six visuals answer none of those three questions?
Net value by customer and the invoice table. Both are true, and both are useful later. Neither answers what Max asked.
Remove two visuals
- In this live dashboard in Vista, Oplema's browser app for dashboards, select the invoice table so its outline shows. Press Delete.
- Select Net value by customer, and press Delete.
- Read what's left, top to bottom: total, target, regions, path.
- Reset example restores the draft if you remove the wrong one.
Open this page on a larger screen to edit this dashboard.
Four visuals should remain
The page now reads €11,478, 95.7% of the €12,000 target, South ahead of North by €322, and the crossing on September 23.
What stays, and what has to be said
Order follows the conversation. He asks how much, then where, then since when, so the page reads that way. Removing visuals costs you nothing. The detail still exists for whoever asks for it next.
A page can also mislead by omission. This one should say that it covers booked invoices from July 1 to September 30, net of rebates, and that INV-1014 has no price yet. A Text visual is enough. Without that, €11,478 looks more final than it is. The first dashboard guide shows how to add one.
Common dashboard mistakes
- Showing everything. It feels safe, because nobody can say you left something out. It moves the work of finding the answer onto the person with the least time.
- Mixed populations. A headline from one filter beside a chart from another looks like one story.
- Decoration. Gauges and 3D take space and carry no extra fact.
When a dashboard is the wrong answer
Build a dashboard when a question comes back regularly, or when readers need to explore the same measure. A one-off decision may need only a chart and a paragraph. An exact lookup needs a table. And if nobody can name the decision, the page will have nothing to leave out, so settle that first.
Power BI, Tableau and a spreadsheet all reward the same habits. The tool changes where you click, and the checklist above stays the same.