Dashboards That Actually Help You Make Decisions
Most dashboards are decoration. Too many metrics, no context, stale data. What separates dashboards that drive real action from the ones nobody looks at.
Every business has dashboards. Most of them are useless.
That sounds harsh, but here's the test: when was the last time you looked at a dashboard and then actually changed what you were doing because of what it showed you? Not just nodded and moved on, but genuinely made a different decision?
If the answer is "I can't remember," your dashboard is decoration, not a tool.
What goes wrong with most dashboards
- Too many metrics: A dashboard with 40 numbers is a spreadsheet with graphics. Nobody scans 40 numbers daily. The important ones get lost in the noise.
- Vanity metrics: Total revenue is nice to know. Revenue trend by product line by week is useful. One tells you something; the other helps you decide something.
- No context: A number without a benchmark is meaningless. "$42K revenue this month". Is that good? Compared to what? Last month? Same month last year? Your target?
- Stale data: If your dashboard updates weekly but your problems happen daily, the dashboard is always behind.
- Beautiful but useless: The fanciest dashboard tool doesn't matter if you're measuring the wrong things.
What good dashboards do differently
The dashboards that actually drive decisions have a few things in common:
- Five to eight key metrics, maximum. Each one answers a specific question that someone needs to act on this week.
- Comparisons built in. Current vs target. This period vs last. Trend lines. Context that makes the number meaningful.
- Alerts for anomalies. Don't make people scan the dashboard looking for problems. Highlight when something is out of range.
- Connected to real data sources. Your accounting system, your CRM, your project management tool. Not a spreadsheet someone updates manually on Mondays.
- Designed for a specific audience. The CEO dashboard is different from the ops manager dashboard. Stop trying to make one dashboard serve everyone.
Practical examples
A trades business: Jobs quoted vs jobs won (conversion rate), average time from quote to completion, revenue per crew, outstanding invoices over 30 days. Four metrics. Checked daily. Decisions made weekly.
An ecommerce business: Daily revenue vs target, conversion rate by channel, abandoned cart rate, average order value trend. Connected to Shopify and Google Analytics. Updated hourly.
A professional services firm: Utilisation rate by team, pipeline value by stage, average project margin, overdue milestones. Connected to their project management and Xero.
Getting there
Start by asking each person who'll use the dashboard: "What decisions do you make regularly, and what information would help you make them better?"
Then work backwards from those decisions to the data. Resist the urge to add more metrics "just in case." Every metric you add dilutes the ones that matter.
A dashboard isn't a report. It's a decision-support tool. If it's not supporting decisions, strip it back until it is.