By Mo Hussein
5 min read
A business dashboard is one screen that shows the handful of numbers you run the business on, pulled from your own systems so they're current when you look. It replaces the report someone builds by hand every Monday, and the question "can you send me the latest figures?"
A good one is boring in the best way. You open it, you see what's slipping, you decide what to do about it. If it takes more than a minute to read, it has too much on it.
What should a small business dashboard track?
There's no standard list, and anyone who hands you one without asking how you work is guessing. But service businesses tend to circle the same five questions. Treat these as examples to react to, not a prescription:
- Enquiries. How many came in this week, and from where? A trades business might care about phone calls and web forms. A training provider might care about course enquiries.
- Conversion. Of the people who asked for a quote or a booking, how many said yes? A consultancy sending proposals will feel this number quickly.
- Work in progress. What's live right now, and what's stuck? A clinic might look at appointments booked against slots; an agency at projects waiting on client feedback.
- Cash owed. Which invoices are overdue, and by how long? This is the one most owners wish they saw sooner, because late payment is easier to chase on day three than day thirty.
- Capacity. Who has room next week, and who is already over? Staff hours against what's booked is usually the picture.
Five is a ceiling, not a target. Plenty of businesses need three. If you can't say what you'd do differently when a number moves, drop it.
Where does the data come from?
From tools you already use. Enquiries sit in your inbox, website forms or a CRM. Invoices and what's owed sit in your accounts, for example Xero or QuickBooks. Jobs and bookings sit in a booking system, a job tool or, still very often, a spreadsheet. Staff time sits in timesheets.
The hard part is rarely the chart. It's that those numbers live in five places and don't agree about what a "customer" or a "job" is. Joining them up, and tidying them where they disagree, is most of the work. A dashboard is only as good as the tidiness underneath it.
Built-in reports, BI tools or a custom dashboard?
Three honest options, in the order we'd try them.
Built-in reports. Most accounting, booking and CRM tools have reporting. If the numbers you need all live in one tool, use that and stop. It's free and it's already maintained.
A reporting or BI tool such as Looker Studio or Power BI. These can connect several sources and draw charts, and you stay in control. The trade-off is that somebody has to set up the connections, keep them working and make sense of messy data. It suits someone who enjoys that, or has time for it.
A custom dashboard. Worth it when the data needs joining up or tidying first, when different people should see different things (owners seeing the money, teams seeing their own work), or when the figures should sit inside a tool your team already uses. It costs more up front than the other two. If one off-the-shelf option would do the job, we'll tell you.
Our guide to spreadsheet, off-the-shelf tool or custom build uses the same logic for choosing, and it applies here too.
Mistakes that make dashboards useless
- Too many charts. Fifty tiles means none get read. Pick the few that change what you do.
- Numbers nobody acts on. Total website visitors looks lovely and decides nothing. Ask who would act on each figure, and when.
- Stale data. A dashboard showing last month looks like a report with a nicer font. Decide how fresh each number needs to be: some are fine overnight, some you want within minutes.
- No agreed definitions. If "converted" means one thing in sales and another in finance, the dashboard will start arguments, not settle them.
- Nobody owns it. Someone should notice when a feed breaks and a figure quietly freezes.
How to start small
Write down the three questions you ask most often on a Monday morning. Find where the answers live today. Get those three onto one screen, from live sources, and use it for a month before adding anything.
Most people find that the second month's additions are obvious and the first month's guesses were half wrong. That's fine. It's much cheaper to learn it on three numbers than thirty.
Common questions
What is a business dashboard?
It's a single view of the key figures in your business, drawn automatically from the tools you already use, so you can see what's happening without building a report by hand.
What is a small business dashboard worth tracking first?
Start with the questions you ask most often. For many service businesses that's new enquiries, quotes won, work in progress, unpaid invoices and who has capacity, but yours may differ.
Do I need custom dashboard development?
Often not. If your numbers sit in one tool, its built-in reports will do. Custom dashboard development makes sense when the data comes from several places, needs tidying, or different people need different views.
How up to date can a dashboard be?
As often as the source systems allow, from near real time to a nightly refresh. Pick the frequency by how quickly you'd act on the number.
If you want to see what we build, read about dashboards and reporting. You can also try the project estimate for a price range, or book a free discovery call and bring your Monday spreadsheet. For a wider view of what else is worth automating, see business process automation for small businesses and connecting your tools to Xero.
