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.
| Business | What the dashboard might show |
|---|---|
| Café or restaurant | Daily sales, best-sellers, busiest hours, staff cost as a share of sales |
| Salon or clinic | Bookings, no-shows, revenue per team member, rebooking rate |
| Online shop | Orders, returns, average order value, revenue by channel |
| Agency or consultancy | Billable hours, utilisation, project margin, pipeline |
A simple plan
- Pick five numbers. Which figures actually change your decisions? Start there.
- Find where they come from. List every source and how it can be exported or connected.
- Define each one precisely. Does "sales" include VAT? Refunds? Write it down.
- Build a clean model. One table per business event, plus lookup tables for products, customers and dates. The star schema guide explains why.
- Design for a glance. The most important number top-left, trends over tables, and no more than six visuals on the first page.
- 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, which is exactly where an analytics engineer helps.
Curious what a dashboard could show for your business? Tell me what you track today and I will suggest what is possible.
Written by Alessandro Ecclesie Agazzi, freelance analytics engineer in London. Updated 30 September 2026.