Spreadsheets are one of the best tools a small business can have: flexible, cheap and familiar. But there comes a point where the spreadsheet that once saved you time starts costing you instead.
Five signs you have outgrown your spreadsheets
- The same report takes hours every week
- The steps are predictable, which means they can be automated.
- Only one person understands how it works
- When they are away, reporting stops.
- There are several versions of the truth
- "Sales_final_v2" and "Sales_final_REALLY" do not agree.
- Mistakes are found after decisions are made
- A broken formula can go unnoticed for weeks.
- There is data, but no time to look at it
- All the effort goes into preparing numbers, none into understanding them.
What an automated dashboard does
A dashboard is one page showing the numbers that matter most, presented visually and refreshed automatically from where your data already lives: a till system, booking software, online shop or shared spreadsheet.
What it shows depends on the business. Pick yours:
- Daily sales against the same day last week
- Best-sellers
- Busiest hours
- Staff cost as a share of sales
- Bookings
- No-shows
- Revenue per team member
- Rebooking rate
- Orders
- Returns
- Average order value
- Revenue by channel
- Billable hours
- Utilisation
- Project margin
- Pipeline
A simple plan
- 1
Pick five numbers
Which figures actually change your decisions? Start there.
- 2
Find where they come from
List every source and how it can be exported or connected.
- 3
Define each one precisely
Does "sales" include VAT? Refunds? Write it down.
- 4
Build a clean model
One table per business event, plus lookup tables for products, customers and dates. The star schema guide explains why.
- 5
Design for a glance
The most important number top-left, trends over tables, and no more than six visuals on the first page.
- 6
Automate the refresh
Scheduled refresh in Power BI, or a small script, as in the automation guide.
Design principles for dashboards people use
- Every chart answers a question someone actually asks.
- Show comparisons: against last month, last year or a target.
- Use colour to highlight, not decorate.
- Label clearly in the language of the business, not of the database.
- Show when the data was last refreshed.
What it costs
Often very little in software. Power BI Desktop is free, and many small businesses can start with data they already have in spreadsheets and cloud tools. Most of the value is in the design and the data model, not the licence.
Check your understanding
1/3What is the best first step towards a dashboard?
A dashboard that answers a few real questions gets used; one that shows everything gets ignored.
2/3Where should the most important number go?
People read a page top-left first, so lead with what matters most.
3/3Why define "sales" in writing?
Most "the numbers are wrong" arguments are really definition arguments.
You got 0 out of 3.
Alessandro Ecclesie AgazziWritten by Alessandro Ecclesie Agazzi, analytics engineer in London. Updated 30 September 2026. About me