“We can’t trust our numbers.” Sales says revenue was one figure last month, finance says another, and the spreadsheet on the shared drive says something else again. Every meeting starts with an argument about whose number is right, and ends before anyone talks about what to do.
If that sounds familiar, the problem usually isn’t your people or your software. It’s that your numbers come from several places that were never connected. This guide explains why that happens, what a good dashboard does about it, and how to tell whether you need one.
Why don’t the numbers in my reports match?
There are a few common reasons, and most businesses have more than one:
- Different sources. Your online store, your accounting system and your sales system each record a sale slightly differently, and at different moments. One counts an order when it’s placed, another when it’s paid, another when it ships.
- Different definitions. Does “revenue” include tax? Shipping? Refunds? If two people answer differently, their reports will never agree.
- Copies of copies. Someone exports data into a spreadsheet, someone else copies that into another one, and each copy is a snapshot from a different day.
- Hand-typed fixes. A correction made in a spreadsheet never makes it back into the system it came from.
None of these are anyone’s fault. They’re what happens when a business grows faster than the way it keeps its numbers.
What is a business dashboard, and what should it show?
A dashboard is a single screen that shows the handful of numbers you need to run the business, updated automatically, from the same source every time. You open it and see where things stand, without asking anyone to build a report.
A useful dashboard is small. It should answer the questions you ask every week, such as:
- How much did we sell, and how does that compare with last month and last year?
- How much cash is coming in, and what’s overdue?
- Which products, services or customers are growing, and which are slipping?
- Where is work getting stuck: orders, jobs, support requests?
A good test: if a number on the dashboard went up or down sharply, would you do something differently? If not, it probably doesn’t belong there.
When is a spreadsheet no longer enough?
Spreadsheets are a fine place to start, and plenty of businesses never need more. They stop being enough when:
- Someone spends hours every week rebuilding the same report
- The spreadsheet is so large or fragile that only one person dares to edit it
- Two versions of it exist, and nobody is sure which is current
- A simple question, like “how did this region do compared with last year?”, takes an afternoon to answer
- Decisions get made on gut feel because the real numbers are too much trouble to get
We wrote more about this in 5 signs your business has outgrown its spreadsheets.
What is a data warehouse, in plain English?
A data warehouse is one central place where copies of the information from all your systems are collected, cleaned up and stored side by side, with the same definitions applied throughout.
Think of it as the single, agreed-upon version of your numbers. Your store, your accounting system and your sales system keep doing their jobs. Every night, or every hour, their information is copied into the warehouse, where “revenue” means one thing and one thing only. The dashboard reads from there.
That’s what ends the arguments. Everyone looks at the same number, built the same way, from the same source.
Not every business needs a warehouse. If most of your numbers live in one system, a dashboard can often read from it directly. A warehouse earns its place when you need to combine information from several systems, or keep a history the systems themselves don’t hold.
How do you decide which numbers matter most?
Start with decisions, not data. Ask:
- What do we decide every week or month? Hiring, ordering stock, chasing payments, where to spend on marketing.
- What would we need to see to decide well? Those are your dashboard numbers.
- Who needs to see them? The owner, the sales lead and the operations manager may each need a slightly different view.
- How fresh does each number need to be? Some need to be live. Most are fine updated overnight.
Agreeing on definitions, such as what counts as a sale or when a customer counts as active, is often the most valuable part of the work. It’s a conversation with your team rather than a technical task, and it’s where we start.
What gets done, and what does it cost?
A typical dashboard project with Agapi looks like this:
- A free 30-minute call in plain English, with no obligation. You tell us which numbers you don’t trust and which questions take too long to answer.
- Agreeing the numbers that matter and how each one is defined.
- Connecting your systems so the information flows in automatically, with a data warehouse if you need one.
- Building the dashboard, checking every figure against what your team already knows to be true, and walking you through it.
The cost depends on how many systems are involved and how much cleaning the data needs, so we scope it before quoting. The price is agreed in writing before any work starts. The work is done by Agapi’s own senior engineers, and you deal with one consistent point of contact throughout.
Being honest about the limits
A dashboard shows your numbers clearly. It doesn’t fix them by itself. If information is entered incorrectly at the start, for example a sale recorded against the wrong customer, the dashboard will faithfully show the wrong answer. Part of the work is finding those problems and fixing them where they start, and some of those fixes are changes to how your team works rather than to the software.
A dashboard also won’t tell you what to do. It makes the questions quicker to answer, so you spend meetings deciding instead of arguing about whose figure is right.
The short version
If your reports don’t match, you spend hours rebuilding them, or simple questions take an afternoon, a custom dashboard is probably worth it. Start with the decisions you make, agree what each number means, and connect your systems so the numbers update themselves.
If you’d like to talk it through, book a free 30-minute call, or read more about what we do.