Data and Knowledge

An SME owner at a desk reviewing a thirty-seven tab operations spreadsheet alongside a half-configured new system on a second screen

From spreadsheets to systems: when an SME outgrows its data setup

The spreadsheet was the right answer at five people. At twenty-five, it is the bottleneck. Four signs to watch for, and a proportionate migration sequence that does not retire the spreadsheet on day one.

An owner and two colleagues at a small meeting table with a printed sheet of questions, a coffee cup and an open notebook, mid-conversation

Measuring data and knowledge readiness, four questions to revisit each quarter

Owners who measure data and knowledge readiness in a structured way ship better AI outcomes than owners who treat it as a feeling. Four questions, every quarter, no dashboard required.

A woman in her fifties at a kitchen table reading a printed proposal document, pen in hand, with two other proposals beside her and a mug of tea.

When to bring in a data consultant, and when not to

Three situations where external data help is worth the spend, the more common ones where in-house is faster, and how to brief a consultant so the engagement actually lands.

A founder at a desk with a one-page plan in her hand, checking items off, with a three-block wall planner behind her

The 90-day data and knowledge readiness roadmap for SMEs

A focused ninety-day sprint, structured in three phases of about a month each, gets a 5 to 50 person business from scattered information to data and knowledge that does not block the next AI use case.

A small business owner and her operations lead at a desk, looking at a laptop screen showing a folder of documents, the owner pointing at one file

Version control for SME knowledge, the proportionate approach

Proposal_v4_dh_FINAL_final2.docx was tolerable when only humans read it. The moment AI is reading your documents the cost shows up sharply. Here are the three rules that do the work.

A small business owner and two senior colleagues around a meeting table, a printed glossary sheet in the centre, one writing on it with a pen, another pointing at a line

Building a business glossary, the foundation most SMEs skip

One page, twenty terms, ninety minutes. The cheapest and highest-impact AI readiness investment a small business can make, and the one almost nobody does.

A small business owner at a desk reviewing a printed sheet of tag categories alongside a CRM contact list on a laptop

Tagging and metadata: the SME search problem nobody named

Every SME has a metadata problem and almost none has named it as one. A proportionate fix is ten to fifteen tags, agreed once, reviewed quarterly.

Two colleagues at a desk reviewing a folder structure on a laptop with a printed three-column tier list on the desk

The shared drive problem, getting a decade of documents AI-ready

An owner's new AI tool surfaced a 2019 PDF as the answer to a current client question. Three more recent and relevant documents were sitting two folders away. The fix is not a clean-out, it is a categorisation pass.

A woman at a desk reviewing a shared-drive folder structure on her laptop with a printed checklist beside her

Naming conventions and folder structure for AI retrieval

Your AI assistant just cited Client_Proposal_FINAL_v3 (2).docx as the latest version of a document that was superseded three months ago. The fix is four rules, applied going forward, with a forgiving attitude to history.

An owner at a desk comparing two PDFs on a laptop screen with a folder of paper contracts open beside him

PDFs, scans and image-only documents, what AI can and cannot read

Two PDFs that look identical on screen can behave very differently when an AI tool tries to read them. Here is the difference, why it matters, and how to triage a mixed document estate without OCR-ing the lot.

An owner at a small desk with a laptop, notepad, and phone showing recent client calls, searching for an answer that is already in the archive

Slack, email and call transcripts: the hidden knowledge base sitting in your messages

Your team has already answered the question dozens of times. The answers are sitting in Slack, in old email threads, and in the call recordings nobody re-listens to. AI has finally made that archive useful, but only if you scope it proportionately.

A woman at a kitchen table reading and annotating a printed standard operating procedure with a pen

Standard operating procedures AI can actually read

An owner asks the AI to onboard a new client using the standard process. It invents half the steps. The fix is not a new tool, it is three small changes to how the SOP is written.

A senior operations lead in her late fifties points at a laptop screen while a younger colleague takes notes on a paper pad, the two of them at a small meeting table with a printed process diagram on the wall behind them

Capturing tacit knowledge before your key people leave

The most valuable knowledge in an owner-operated business is almost never written down. When a long-serving person leaves, the cost is measured in months of pattern-matching the replacement cannot do. Here is the proportionate capture discipline that actually works.