AI in practice

Getting your data ready for AI without a big clean-up

You do not need perfect data to start with AI. How to tidy just the information your first use needs, and avoid the mistakes that make AI confidently wrong.

"Our data is a mess, so AI is not for us yet." We hear this a lot from small businesses, and it is half right. AI does depend on your information, and messy information makes AI give confident wrong answers. But the fix is not a company-wide clean-up project. It is tidying the small slice of data that your first AI task actually uses.

This guide shows you how to find that slice, what "ready" means in practice, and the one mistake that catches out almost everyone who connects AI to shared folders.

Key takeaways

  • Do not wait for perfect data. Fix the data for one task at a time.
  • AI cannot tell an old document from a current one. Remove or label out-of-date files first.
  • Know where your information lives, who owns it and how reliable it is.
  • Keep one trusted version of key facts such as prices, policies and customer details.
  • Decide what sensitive information should never go near an AI tool.

Why does data matter so much?

AI does not fix bad information; it repeats it, faster and with more confidence. When AI tools disappoint, the cause is far more often inconsistent, incomplete or out-of-date information than a weak tool. If your price list exists in five versions, an AI assistant will happily quote any of them.

That is the bad news. The good news is that you only need to fix what your chosen task touches.

Why a big clean-up is the wrong place to start

Business-wide data projects have a habit of never finishing. They take months, they are hard to justify, and by the time they end, the business has moved on. Meanwhile nothing useful has happened.

The approach that works is narrower:

  1. Pick the one task you want AI to help with. Our guide to choosing a first AI use can help.
  2. Trace back to the specific information that task relies on.
  3. Fix the gaps, formats and access problems for that information only.
  4. Get the task working, then repeat for the next one.

Each round leaves you with tidier information and a working use of AI, rather than a plan.

What does "ready" actually mean?

For a small business, ready means you can answer these questions about the information your task uses.

QuestionWhy it mattersA quick fix if the answer is no
Where is it?Information hidden in personal inboxes and side spreadsheets gets missedList every place the task's information lives, including the "unofficial" ones
Which version is current?AI treats an old file as just as true as a new oneArchive or clearly label old and draft files
Who owns it?Without an owner, nobody keeps it up to dateName one person per key source
Does everyone mean the same thing?If "customer" or "order date" means different things in different places, answers conflictAgree a short glossary for the terms that matter
Is it complete enough?Gaps lead to guessesFill the gaps that matter for this task, not every gap
Is any of it sensitive?Some information should never reach an AI toolMark it and keep it out (see below)

Do not overlook the spreadsheets. In many small firms, the information people actually use to make decisions lives outside the main systems. Ask the people who do the work what they really look at.

The mistake almost everyone makes

The most common early mistake is connecting an AI assistant to a shared drive or document library as it stands. Shared folders are full of old drafts, superseded price lists and policies that were replaced years ago. The AI has no way of knowing which is current.

One larger organisation learned this the hard way. Its internal chatbot gave impressive answers in early tests, so it was connected to the existing shared drives. Those drives had never been tidied. The chatbot could not tell the current price list from one that had expired years earlier, and drew on outdated files as often as current ones. The fix was not a better chatbot. It was basic document control.

Patience pays: an example from a small manufacturer

Picture a small manufacturer whose stock and production planning rely on information spread across a customer system, accounting software and an older supplier system. The sensible route is step by step: paper to digital records, then cloud software, then the AI features already built into those packages, and only then anything more ambitious that pulls the sources together.

The lesson is not to aim for the ambitious end point first. It is that each small step of getting information into proper systems made the next step possible.

How should a small firm handle sensitive information?

Some information should never be pasted into an AI tool or connected to one without careful thought: customer and staff personal details, financial records, anything given to you in confidence. Once that information is inside an AI system, it can be very hard to control who sees it. An assistant connected to everything will answer whoever asks.

Practical steps:

  • List the types of information you hold and mark which are sensitive.
  • Decide which AI tools, if any, may be used with each type.
  • Make sure any AI tool connected to your files only shows people what they could already see.
  • Prefer business versions of AI tools over free personal accounts for work information.
  • Before you share customer or staff records with an AI tool or a consultant, check your obligations with a data protection adviser.

Getting into good habits from now on

If you are a young or growing firm, the cheapest data clean-up is the one you never need. Keep customer and job information in a proper system rather than scattered documents, use consistent names and references, and record why decisions were made as well as what was done. That written context makes AI tools far more useful later, in the same way it helps a new member of staff.

And if your data really is in a mess today? That is normal. Start with the one task that matters most, tidy what it needs, and go from there. When you are ready to test it, our guide to why AI pilots stall explains how to run a fair trial.

Planning an AI project?

Our free project brief template helps you set out what you need before you speak to anyone, so you can compare consultants on the same terms.

Download the brief template