Executive Dashboard Design
One glance, one decision, one drill path
Executive dashboards are a visual discipline in restraint: one page, a tight metric grid, deltas + bands, and drill-through — designed for a weekly scan cycle, not permanent screen-saver status.
What you will learn
- Apply reading-order and hierarchy in dashboard layout
- Choose the right visual per metric decision
- Wire drill-through without cluttering the main page
What is this?
Executive dashboard design is the craft of making a decision visible in one glance: a value-delta-band tile grid in reading order, restrained color, one chart where a trend actually matters, and click-through detail behind each tile. It's a weekly-scan artifact, not a permanent wallpaper — design for the glance, then the drill.
Why do you need it?
- A glance that takes ten seconds beats a screen nobody reads.
- Layout and reading order decide whether numbers are absorbed or skipped.
- Drill-through keeps the page clean without losing the 'why'.
- Dashboard taste is a hiring-signal skill for BI analysts.
Mental model
Chess notation vs the coach's one-page review
Dashboards
Chess records every move (the data), but a coach reviews a one-page: key positions, material balance, time, plan. The review page highlights the few things that change decisions; the notation waits in the box behind it. Executive dashboards are the coach's page, with the notation one click away.
How it works
- Structure: metric tiles first (the decision), trends second, details hidden behind.
- Reading order: top-left to bottom-right; revenue left, risk right.
- Visual choice: one number→tile, trend→sparkline, comparison→bar, distribution→small multiples.
- Color: one accent for the band status; red only for real risks.
- Drill-through: click the tile for region/product/time decomposition events.
Layout: glance, then drill.
Examples
A hex of a tile design
REVENUE MARGIN CASH 12.4M ▸ +8% 63.9% +1pt -0.9M +0.3M (band: green) (band: amber) (band: red) Region split [ bar, small ]Trend 8w [ sparklines ]vs plan [ table, deltas ] Below the fold: drill-through — region, product, channel,period. Page itself never grows past one screen.Tiles demand a decision glance; trends whisper momentum; detail waits behind the click.
In production
- A weekly exec page recomputes from the metric layer every Monday — same page, fresh numbers.
- A risk tile amber→red automatically pulls the delayering caveat into the drill page.
- A QBR view delegates region drill keys to the region teams; the page stays one screen.
Best practices
- Design the glance; keep the drill honest (never bury bad news).
- Restrain color: band status carries the message.
- Make tiles hit-testable: one click → the decomposition.
- Rebuild the page for its cadence: weekly page, quarterly QBR variant.
Common mistakes
- Twenty charts on a page — wallpaper, not dashboard.
- No bands or deltas on the tiles — pretty numbers, no decision.
- Red used for any dip, every month, until red means nothing.
- Drill-through that dead-ends in a blank page of static tables.
Debugging tips
- Execs keep asking the same question → the tile doesn't answer it; add the delta/band.
- Tile says green, drill shows the local red → masking broke; check the roll-up.
- Page renders 4s+ → precompute the tile payload, keep the page lean.
Interview checkpoint
Hands-on lab
- Sketch a one-screen tile layout in reading order
- Audit your design against a decision checklist
- Document the drill paths each tile needs
Sketch and Audit an Executive One-Pager
45 min · intermediate
Quick quiz
The visual for a single KPI value is:
Executive dashboards should grow with every new KPI request.