An 80/20 dashboard shows the small number of measures that actually drive your business, and leaves everything else off the front page. To build one, list every metric you track, keep only the ones that directly influence a decision you make regularly, and put those (usually a handful, not dozens) on a single screen that updates itself. If a number never changes what anyone does, it doesn't belong on the dashboard.
Why most dashboards don't get used
We've all seen the dashboard with twenty-plus charts, all competing for attention. It looked impressive when it was built. Six months later, nobody opens it.
That happens for a few predictable reasons:
- Too much to read. When everything is highlighted, nothing stands out. People can't tell at a glance whether things are going well or badly.
- Metrics without decisions. Many charts are there because the data was available, not because anyone acts on them.
- Borrowed metrics. Teams copy measures that are popular in their industry without checking whether those numbers matter for their own business model.
- Stale data. If the dashboard depends on someone exporting and pasting data, it falls behind and people stop trusting it.
The 80/20 rule applied to metrics
The Pareto principle, often called the 80/20 rule, is the observation that a small share of causes tends to drive most of the results. It's a rule of thumb, not a law, but it applies well to business metrics: a few indicators usually tell you most of what you need to know.
For a builder, those might be gross margin by job, cash position and the value of work under- or over-claimed. For a distributor, perhaps gross margin by product line, stock on hand versus sales and overdue debtors. For a manufacturer, perhaps job cost against quote, on-time delivery and machine or labour utilisation. The right list is different for every business, which is why it's worth working out rather than copying.
How to build your 80/20 dashboard
- List every metric you currently track. Include the reports from your accounting system, the spreadsheets people maintain and anything already in Power BI or similar.
- Ask what decision each one supports. For each metric, write down who looks at it and what they would do differently if it moved. If there's no answer, it's a candidate for removal.
- Rank by impact on profit and cash. Keep the measures most directly tied to the outcomes that matter most to the business.
- Cut to a handful for the main view. Put the rest on a secondary page or a detailed report for the people who need them.
- Add context to every number. A figure on its own means little. Show it against a target, last month or the same period last year, so it's obvious whether it's good or bad.
- Automate the data feed. Connect the dashboard directly to your accounting, job management or inventory systems so it updates without anyone copying data across.
This isn't a one-off exercise. As the business changes, so should the measures. Reviewing them every quarter is a sensible rhythm.
Design tips that make a dashboard useful
- One screen, no scrolling for the main view. If people have to hunt, they won't.
- Lead with the most important number in the top left, where people look first.
- Use colour sparingly, mainly to flag when something is off target.
- Make it possible to drill down. Keep the summary simple, but let people click through to the detail when a number looks wrong.
- Show when the data was last updated. It builds trust and highlights when a feed has broken.
Tools such as Power BI and Tableau make this straightforward once the underlying data is clean and connected. If you're weighing them up, our Power BI vs Tableau comparison covers the differences. The harder part is usually getting data from several systems into one place, which is what our page on combining all your business data into one dashboard is about.
Why less is more
When you strip a dashboard back to what matters, a few things happen. Meetings get shorter because everyone is looking at the same few numbers. Problems stand out because they're not buried among charts that don't matter. And people start using the dashboard to make decisions, which is the whole point. Focus on what matters, put the rest a click away and let the data update itself.
Frequently asked questions
How many metrics should a business dashboard have?
There's no fixed number, but the main view should fit on one screen and be readable in under a minute. For most small and mid-sized businesses that means a handful of key measures, with detail available on secondary pages.
What is the 80/20 rule for dashboards?
It's the idea that a small number of measures explain most of what's happening in the business. An 80/20 dashboard shows those measures prominently and moves everything else to detailed reports.
Should I build my dashboard in Excel or Power BI?
Excel can work for a simple dashboard maintained by one person. Power BI or Tableau are better when data comes from several systems, needs to refresh automatically or is shared with a team.
How do I get data from Xero or MYOB into a dashboard?
Both have APIs and connectors that tools like Power BI can use, either directly or through a data layer in between. The main work is usually cleaning and structuring the data so the numbers match your accounts.
If your dashboards have grown cluttered, or you don't have one yet, book a free initial chat. We'll talk through which numbers matter for your business and how to get them in front of you automatically. You can also read more about our business intelligence and reporting work.