GlossaryDashboard
Dashboard
A dashboard is the document or screen that brings together, on one page, the few indicators a manager needs to steer their business.
A management dashboard takes its name from the one in a car: it does not show everything the engine is doing, only what calls for a reaction. A small business owner’s dashboard often comes down to a dozen figures, such as the month’s revenue, cash in the bank, pending quotes, overdue invoices or the order book, updated on a set date and compared with a target or with the previous period. It draws on the accounts and the management software and keeps only what helps decide the coming week or month.
How to build one in Excel
France Num, the French government’s programme for small business digitalisation, advises starting with a simple spreadsheet before any specialised software, and the sturdiest Excel dashboard keeps three things apart on three tabs. The first holds the raw data, exported as it is from the invoicing software or the bank and formatted as a table, so that formulas follow when rows are added. The second calculates the indicators, with a pivot table or formulas such as SUMIFS, and it is the only place where each formula is written. The third displays, on one page, a chart or a figure per indicator with the comparison against the previous month or the target, with no data entry at all. On update day you replace the data in the first tab, refresh, and the display follows without being touched.
For a fifteen-person agency one page is often enough: the month’s invoiced revenue and its gap with last year, available cash, the amount of overdue invoices, the quote conversion rate and the days billed per consultant. Each of these figures is a KPI, with its formula, its source and its owner.
Common mistakes
The most common is the dashboard that grows with every request until it holds forty indicators nobody reads, whereas France Num recommends sticking to five to ten. Next comes the figure shown with no comparison, which says how much without saying whether that is good or bad. A manual update that depends on one person stops when that person goes on holiday, and a missing update date suggests the figures on screen are today’s. The last pitfall is the dashboard that counts only what is easy to count, and so displays a gain the real work contradicts, as our article on work that only looks finished shows.
Dashboard, reporting and KPI
Reporting gives an account, at fixed intervals, of what has happened, often for someone other than the person preparing it, such as a board, a bank or the shareholders. A dashboard serves the person steering the business, to decide what to do next. KPIs are the figures that go on it, and a dashboard is worth exactly what the chosen indicators are worth. Balt, for his part, prepares the weekly update every Monday from the figures in your tools, with what changed and its likely cause, as the reporting page shows.

