Eight years in business. Twelve members of staff. A solid reputation and a loyal customer base. By most measures, a well-run clothing retailer doing the right things.
Then the owner walked out of a supplier meeting where she'd been asked a simple question: "Which of our lines are most profitable for you?"
She couldn't answer.
Not because she was unprepared or disorganised. Because she genuinely didn't know. And standing in the car park afterwards, she didn't feel embarrassed — she felt something more unsettling. She realised she'd been growing a business for eight years and couldn't answer a basic profitability question about it.
That afternoon, she agreed to do a BI audit.
What a BI audit actually involves
It's not a system review or an IT assessment. A BI audit is a structured, honest look at the information you're currently using to run your business: what reports exist, whether anyone reads them, whether they're actually driving decisions, what definitions you're working from, and where the blind spots are.
This one took twenty minutes. What it surfaced took considerably longer to process.
Finding 1: Seven reports were producing nothing
The business had nine reports in regular circulation — weekly and monthly summaries covering sales, stock, footfall, margin, and a few others that had accumulated over the years. The question we asked for each one was simple: who reads this, and did it change any behaviour in the last three months?
Two reports passed. Nine were being produced — with someone's time — on a regular basis. Seven had no downstream effect on any decision made in the business.
This is more common than most owners want to believe. Reports accumulate. Someone asks for something once, it gets built into the routine, and nobody ever stops to ask whether it's still serving a purpose. The cost isn't catastrophic — but it's real. Time spent producing reports that no one acts on is time not spent on something that matters.
A report that doesn't change a decision isn't a report. It's a habit.
Finding 2: Three people, three definitions of margin
We asked the owner, the bookkeeper, and the sales manager to each write down how they calculated margin.
All three were different. All three were plausible. None of them matched.
The owner's version included returns and supplier rebates. The bookkeeper's was a cleaner gross margin based on invoiced cost. The sales manager's was effectively a contribution margin that excluded certain fixed costs. Each made sense in context. None of them were wrong, exactly. But they were different — which meant that every conversation about margin in that business was, at some level, a conversation between people who weren't measuring the same thing.
That's not a data problem. It's a definitions problem. And it's almost impossible to spot without stopping to look for it deliberately.
Finding 3: No visibility on customer profitability
The business had some product-level margin data — approximate, given the definitions issue above — but nothing at the customer level. They could tell you which products sold well. They couldn't tell you which customers were actually worth having.
That distinction matters more than most people realise. Some customers are easy to service, pay on time, and buy at full margin. Others generate significant service overhead, push for discounts, and return stock at higher rates. When you can't see the difference, you treat them the same — same terms, same attention, same investment. The unprofitable customer gets subsidised by the profitable one, and you never know it's happening.
For a retailer with a CRM, loyalty data, and eight years of transaction history, this was a solvable problem. But first, they had to know it was a problem at all.
What they changed that afternoon
Three immediate actions came out of the session — none of them required new software, new staff, or significant time investment.
- Retired five reports immediately. Not archived, not paused — retired. If no one could explain what decision the report supported, it was gone. The remaining four were mapped to specific decisions and specific owners.
- Agreed a single margin definition. It took forty minutes of discussion. The bookkeeper's version won, with one adjustment from the owner. It was written down, shared with all three people, and made the reference point for every margin conversation going forward.
- Named customer profitability as the Q2 priority. Not fixed immediately — identified as the most important blind spot and scheduled for a proper fix in the next quarter, with a clear owner and a simple brief.
The data was never the problem
The retailer had data. Eight years of it. She had systems, reports, and a team who were conscientious about keeping records. The problem wasn't a lack of data — it was a lack of clarity about what the data meant, which parts of it were actually being used, and where the gaps were.
That's the pattern I see most often in SMEs that have been running for a while. The BI infrastructure has grown organically — a report here, a metric there, a definition that made sense at the time — and nobody has ever stopped to audit whether it still holds together. Usually, it doesn't. Not catastrophically. Just quietly, expensively, in ways that only become obvious once you look.
Twenty minutes of structured review. Three findings. Three fixes. That's what a BI audit does.