Business Dashboard: the numbers an owner should see without asking anyone

A business dashboard is one screen that shows the few numbers an owner needs to run the business, drawn live from the records the work already creates. It replaces the weekly request for a report. If someone has to build it by hand before you can read it, it is a report, not a dashboard.

What is a business dashboard, and what is it not?

The word gets used for almost anything with a chart on it, so it helps to go back to a careful definition. In his March 2004 article "Dashboard Confusion", the information design writer Stephen Few described a dashboard as a visual display of the most important information needed to reach an objective, arranged on a single screen so it can be "monitored at a glance".

Three things in that definition matter to an owner:

1. The most important information, not all of it. A dashboard is a short list. If everything is on it, nothing is.
2. A single screen. No tabs, no scrolling, no second file to open.
3. At a glance. You look, you know, you move on. Analysis happens somewhere else.

Few also made the point that a dashboard is not defined by a type of information, such as KPIs. It is defined by its purpose. That is useful, because it means the question is never "which charts should I have?" It is "what do I need to know to run this week?"

Why do most owners still ask someone for the numbers?

Because the numbers live in different places. Sales are in one app, invoices in another, the job list is a spreadsheet and the enquiries are in an inbox. To answer a simple question, someone has to open each one, copy figures into a sheet and send it on. By the time it arrives, the week it describes is over.

That is the real cost of disconnected tools. It is not only the time spent building the report, which we covered in automate reporting. It is that the owner makes Tuesday's decision on last Friday's picture, and cannot check a figure without interrupting the person who built it.

Searches around this topic show the same pattern. The most common additions people type after "business dashboard" are template, examples and excel. Owners are looking for a layout to fill in. A layout is the easy part. The hard part is where the numbers come from.

Which numbers should an owner see without asking anyone?

The right list depends on the business, but most owner dashboards answer the same five questions. Five numbers, one screen, updated by the work itself.

Question	The number	Where it should come from
Is work coming in?	New enquiries this week, and how many are still unanswered	The enquiry record, created when the message, call or form arrives
Is it turning into business?	Quotes sent and quotes accepted	The quote record, when its status changes
Is the work moving?	Jobs in progress, and jobs past their due date	The job record, updated by the people doing the work
Has it been billed?	Completed work not yet invoiced	The link between the job and its invoice
Has it been paid?	Invoices outstanding, and how long they have been open	The invoice record, when a payment is matched

Notice that none of these is a calculation someone performs on a Friday. Each one is a count of records in a certain state. If the records are kept as the work happens, the numbers already exist. The dashboard only has to show them.

Is an Excel dashboard template enough?

A template gives you the tiles. It does not fill them. Someone still exports, pastes and checks, so the dashboard is as current as the last time that person had a free hour. It also holds a second copy of every figure, and two copies drift apart.

A spreadsheet is a good place to work out which numbers you want. It is a poor place to keep them once the business depends on them. When the checking takes longer than the reading, the template has done its job and it is time for the numbers to come from the system of record. We set out how to test whether a figure can be trusted in how to analyse sales data.

How does the Business Operating System keep the dashboard live?

The Business Operating System is built around how your business runs, so the dashboard is not a separate project. It is a view of records that already exist.

• Captured once. An enquiry, a quote, a job and an invoice are each entered one time, by the person doing that step.
• Linked, not copied. The quote belongs to the enquiry, the job to the quote, the invoice to the job. Nothing is retyped into a reporting sheet.
• Counted by status. Each tile counts records in a state: unanswered, sent, overdue, unbilled, unpaid. When a status changes, the tile changes.
• One click to the detail. A number that looks wrong opens the list of records behind it, so you check it yourself instead of asking.
• The same picture for everyone. The owner, the office and the team read from one source of truth, so the meeting starts from the same numbers.

What changes for the owner is the direction of the question. You stop asking for the numbers and start asking about them. The Friday report becomes a conversation about the two tiles that moved. Month end gets shorter for the same reason, as we set out in month end close.

If the idea of one system for the whole business is new, start with what a business operating system is and the signs you have outgrown your apps in business management system.

How do you start if your numbers are scattered?

1. Write down the five questions you ask your team most often. That is your first dashboard, on paper.
2. Find where each answer lives today. An app, a spreadsheet, an inbox or a person's memory.
3. Mark every answer that needs a person to assemble it. Those are the joins that are missing.
4. Fix the record before the chart. A tile is only as good as the habit of updating the record behind it.

Frequently Asked Questions

What is a business dashboard?

A business dashboard is a single screen showing the few numbers needed to run the business, such as open enquiries, jobs in progress and unpaid invoices, updated from live records so nobody has to compile them first.

What is the difference between a dashboard and a report?

A report is assembled for a period and read afterwards. A dashboard shows the current state continuously on one screen. If a person must build it before you can read it, it is a report.

How many numbers should a business dashboard show?

Few enough to read at a glance on one screen. For most owners that is about five: enquiries, quotes, jobs, unbilled work and unpaid invoices. Detail belongs one click behind each number, not on the screen.

Can I build a business dashboard in Excel?

Yes, and it is a sensible way to decide which numbers you want. It stays manual, though. Someone must export and paste the figures, so the dashboard is only as current as their last update.

Find out which numbers you are still asking for

The free Business Autopsy maps how enquiries, quotes, jobs and invoices move through your business, and shows which answers still depend on a person assembling them. Book a free Business Autopsy, or start with a short discovery call.