BI platforms advertise dashboards; small businesses need answers. Before any licence, there's an Excel-stage dashboard that delivers most of the value at zero software cost — provided you build it as a system rather than a one-off worksheet.
Step 1: pick three numbers, not thirty
The dashboard earns its keep by answering decisions made weekly: is revenue tracking? What's slow-moving? Who owes us past 30 days? Three decision-linked metrics beat a wall of charts nobody opens. Write the question beside each number — if you can't, it doesn't belong on the sheet.
Step 2: automate the feed, not the painting
- Tally/Busy/billing exports land in a fixed folder on a schedule — or a scheduled import pulls them in.
- One cleaning sheet normalises columns; Power Query handles repeats without retyping.
- The dashboard sheet references cleaned data only. Never chart raw exports.
Step 3: format for a phone screen
Your Monday reader opens it on mobile in the cab. Big numbers top-left, trend arrows, detail tables below the fold. If the first screen needs pinching and scrolling, adoption is dead regardless of analytical brilliance.
The test isn't whether the dashboard impresses you. It's whether the meeting starts from it without anyone being asked to.
When you've outgrown Excel (honest signals)
- Multiple people edit the workbook and versions diverge.
- The file takes minutes to open; formulas recalc painfully.
- You're reconciling three sources manually before the feed works at all.
- Alerting matters — thresholds need to push to you, not wait to be opened.
Any single signal means it's time to talk about automated feeds and proper dashboards — exactly the BI work we do, starting from the Excel version you've already proven. Want the Excel stage built properly first? That's a legitimate engagement too.