The business below — Meridian Creative Ltd. — is a composite. The numbers, the sequence, and the outcomes are drawn from real SME engagements, consolidated into a single fictional company to illustrate what a working BI function looks like at this size. No real client is identifiable. The Method, the metrics, and the rhythm are how the Review actually runs.
"BI working" in an SME is surprisingly unglamorous. No new tooling. No data team. No 40-chart executive overview. Just a small, stubborn discipline — applied monthly, built on metrics nobody had agreed on three months earlier.
Here's what that looks like in practice, in a £2M service business.
The business, before
Meridian Creative is an 18-person design and branding agency. £2.1M revenue in the last twelve months. Four years old. Roughly half the revenue is retainer work for three blue-chip clients; the other half is project-based.
On paper, the business looks clean. Xero is tidy. Invoices go out on time. The MD knows her team. Bookkeeping is outsourced and trusted. No obvious fires.
But the MD can't answer any of these questions without pulling data together by hand:
- Which client group is actually most profitable — retainers or projects?
- What margin is packaging work running at, versus brand strategy?
- What does cash runway look like if the top two retainers churned?
- Is team utilisation trending up or down?
She has suspicions. Not answers. And suspicions aren't enough to price, hire, or plan from.
What was actually going on
When the BIP Method™ ran through its first 60 days at Meridian, three things surfaced — none of them visible from the existing reports.
Finding 1 — Revenue concentration was much higher than assumed.
The top three clients represented 58% of the last twelve months' revenue. The MD had estimated "maybe 40%." Two of those three were packaging accounts with 18-month renewal windows. One renewal had just slipped by two quarters. The business was one conversation away from a 20% revenue drop, and the reporting didn't flag it.
Finding 2 — Margin was not evenly distributed.
Packaging work — which the MD's gut said was "the good stuff" — was running at a 24% gross margin once project hours, subcontractor costs, and revision cycles were properly allocated. Brand strategy was running at 41%. The business was implicitly favouring the lower-margin service, because packaging was "easier to sell."
Finding 3 — Cash runway was shorter than assumed.
The MD said "about four months" when asked. Actual was 2.3 months at current burn — and 1.1 months if the slipped retainer fully churned. Nobody had run that second-scenario number. There was no view to run it from.
None of this required new software. Meridian already had Xero, Harvest (for time), and a Google Sheet the bookkeeper used for cashflow. The data was there. It just wasn't connected, defined, or read.
The reset — 60 days
The Method's four stages — Baseline, Foundation, Rhythm, Evolution — map directly to what happened at Meridian in the first two months.
Baseline
A 10-signs diagnostic was run. Meridian scored 7 out of 10 — flying blind. The signs that hit: three different definitions of "revenue" in use across the MD, the ops lead, and the bookkeeper. No trusted view of margin by service line. Dashboards that existed but nobody opened. Big decisions (a recent hire, a pricing change) made on gut.
Foundation
Definitions got written down. "Revenue" became: invoiced, VAT-exclusive, net of credit notes, in the month of delivery (not the month of invoicing). "Client" became: parent company, not project. "Margin" became: revenue minus direct loaded hours minus subcontractor cost — for that client, that month. Eight core metrics were agreed. Not fifty. Eight.
Rhythm
A monthly scorecard got built — one Google Sheet tab, pulling from Xero and Harvest exports. Eight numbers. Four standing questions, answered by the MD and ops lead together in a 40-minute meeting on the first Monday of each month: What moved? Why? What do we do about it? What do we watch?
Evolution
By the end of Q1, the MD added two lead indicators to the scorecard: pipeline coverage (£ proposal value, next 60 days, divided by monthly revenue target) and utilisation trend (rolling 3-month billable hours as a percent of capacity). Neither existed at the start. They were added once the core rhythm was stable enough to carry them.
After — the monthly rhythm
Ninety days in, here's what Meridian's BI function looks like:
- One scorecard, one page. Eight numbers. Month, prior month, rolling three-month trend.
- Margin decomposed by service line. Packaging vs brand strategy vs retainer — one row each.
- Concentration visible. Top-3 client share of revenue, plotted monthly. A metric the MD watches, not a surprise she discovers.
- Two cash runway scenarios. Current burn. Current burn with the largest retainer removed. Both visible on the scorecard.
- A 40-minute monthly meeting. MD and ops lead. Same four questions. Notes in a running doc, so "what do we watch" in March becomes a check-in in April.
No Power BI. No Tableau. No data analyst. A spreadsheet, a meeting, and a set of agreed definitions.
Before and after, side by side
| Dimension | Before | After |
|---|---|---|
| Time to answer "how was the month?" | Half a day, three tools | Five minutes, one page |
| Revenue concentration | Not tracked; assumed ~40% | Top-3 share plotted monthly; actual 58% |
| Margin by service line | Assumed, untested | Known: packaging 24%, brand strategy 41% |
| Cash runway | Single estimate, off by ~1.7 months | Two-scenario view (base + retainer-loss), current |
| Monthly review cadence | None | 40 min, first Monday, four questions |
| Big decisions | On gut | Against the scorecard |
The part most SMEs get wrong
Most SMEs try to skip to Stage 3. They buy a dashboarding tool, hook up a data source, and hope the rhythm emerges. It doesn't. Without agreed definitions, the dashboard fragments on the first disagreement about what a number means. Without the right five to ten metrics, the dashboard becomes clutter nobody opens.
The Meridian case is boring on purpose. No new tool got bought. No analyst got hired. Eight numbers, a spreadsheet, and a 40-minute meeting — run every month — moved the business from suspicion to signal inside a quarter.
That's what BI looks like in an SME when it's working.
Where to start
If Meridian's "before" felt familiar, the BI Baseline Score tests the same 10 dimensions Meridian hit on. Two minutes, ten questions, an instant read on where the business actually sits — and which part of the Method to start with. For the full depth of the engagement — your numbers, your definitions, your scorecard — see the Review.