Skip to content
DBAI

The AI Buyer’s Guide · 06

Your AI workflow is only as ready as the data it uses.

Your business data is ready for an AI pilot when the team can identify the right source, match the right records, recognize missing or stale information, and explain what happens when a check fails. You do not need to clean every system first. You need dependable inputs for one clearly defined job.

Published
Cluster
Buying AI

Start with one decision, then trace its inputs

“We have years of data” does not tell you whether an automation can use it. Start with the output you want: a draft quote request, an internal product answer, or a routed support ticket. List the facts that output depends on. For each fact, name the source and the person who can resolve a disagreement.

Consider a hypothetical apparel quote assistant. A customer email may establish the requested quantity, while a product catalog establishes the variant identifier. An old spreadsheet may contain a price, but that does not make it the approved pricing source. Write down that distinction before asking a model to combine the records.

Use a field-level readiness check

The UK Government Data Quality Framework treats quality as fitness for the intended use. It distinguishes completeness, uniqueness, consistency, timeliness, validity, and accuracy. A filled-in field can still be wrong; a correctly formatted date can still describe the wrong event. The linked framework provides the terminology. The workflow checks below are DBAI’s practical planning approach.

Illustrative checks for an apparel quote workflow. These are planning examples, not measured client results.
InputEvidence to inspectRule when the check fails
Product and variant IDA stable identifier resolves to one current catalog variant; names alone are not used as the join key.Hold ambiguous matches for staff selection. Do not choose the closest name silently.
Quantity and required dateThe values can be traced to the customer request, with units and date meaning recorded.Keep absent values missing and request clarification; do not manufacture defaults.
AvailabilityThe record shows when the supplier data was updated and when your system last imported it successfully.If the agreed freshness limit is exceeded, flag availability as unconfirmed.
Price sourceAn owner identifies the approved source, effective period, and applicable customer context.Conflicting or expired values require approval before a price is used.
Customer recordThe lookup resolves the intended account and the requesting user is allowed to access it.Block uncertain matches and unauthorized access rather than broadening the search.

Inspect ordinary records and the awkward ones

Ask the workflow owner for a representative sample from the actual sources. Include normal requests and known exceptions: missing variants, duplicate accounts, stale inventory, corrected orders, and conflicting attachments. Track how the sample was selected. A handpicked set of clean records can demonstrate the happy path but cannot establish readiness across the workload.

Record counts as well as examples. If you report the share of requests missing a required field, state the denominator, date range, and source. Separate defects that prevent a safe action from defects that only limit convenience. A missing optional description and an unresolved customer identity should not carry the same weight.

Choose freshness limits around the decision. Product descriptions and stock availability may need different limits. Also distinguish a successful import from fresh source data: copying yesterday’s unchanged feed today does not make the underlying facts current. There is no universal percentage or timestamp threshold that makes every business workflow ready.

Copy this readiness worksheet into your project brief

AI data readiness worksheetComplete this for one workflow with its business owner. Use approved, minimized samples; do not paste private customer records into the brief. · markdown
# AI data readiness — one workflow
Workflow and intended output:
Business owner and decision date:
Actions allowed during pilot:
Actions requiring human approval:

## For each required input
Field / fact:
Authoritative source and source owner:
Record ID and matching rule:
Allowed users / customer scope:
Required format, units, and meaning:
Source update time / last successful import:
Maximum acceptable age for this decision:
Missing, duplicate, or conflicting value rule:
Evidence retained to trace the output:

## Sample review
Sources, date range, and selection method:
Records reviewed / records failing each check:
Normal cases and known exceptions included:
Unrepresented cases and limits of this review:

## Decision
Ready for a bounded pilot / repair first / narrow scope:
Blocking issues, responsible owners, and due dates:
Fallback process while a record is unresolved:
How corrections reach the source and downstream copies:
Acceptance checks to rerun after repairs:

What this looks like in DBAI’s work

The published Exora INK case study describes a SanMar SFTP catalog feed ingested and normalized through n8n, then synchronized to WooCommerce. The storefront, customer chatbot, and internal assistant use a shared data layer. That is a concrete example of the source-to-system plumbing an AI workflow depends on.

The buying lesson is to scope that plumbing with the assistant. Ask which system owns product facts, how variants are matched, and what happens when an import fails. The case study supports the architecture example; it does not establish a data-quality score or a measured result for the hypothetical quote workflow above.

Make a readiness decision you can act on

  1. 01

    Proceed with a bounded pilot

    Required sources and access are clear, record matching is checkable, and unresolved inputs have a tested hold or review path. Validate the outputs separately before rollout.

  2. 02

    Repair a specific dependency

    Assign an owner to the broken feed, missing identifier, or conflicting source. Recheck affected records after the repair reaches downstream systems.

  3. 03

    Narrow the job

    If reliable inputs cover only part of the workload, limit the pilot to that part and make exclusions visible. Keep the existing process for everything else.

Data readiness is an input decision. Pilot acceptance is an output decision. Bring the worksheet to your implementation partner, then agree how you will test the resulting workflow. A clear boundary now is more useful than discovering halfway through a build that nobody owns the source.

FAQ

  1. Do we need a data warehouse before using AI automation?

    Not necessarily. A bounded workflow may use approved inputs from existing systems. First establish source ownership, access, record matching, and freshness. Decide on additional infrastructure when the workflow requires it, not as an automatic starting purchase.

  2. Can AI fix missing or inconsistent business data?

    It can assist with proposed classifications or cleanup, but proposed values are not verified business facts. Keep the original evidence, review consequential corrections, and fix recurring problems at the source. Do not let an assistant invent an identifier, price, or customer requirement.

  3. How much data should we review before a pilot?

    There is no universal sample size. Match the review to the workload’s variation and the consequences of errors. Include normal cases and known exceptions, record the selection method, and state what the sample cannot establish.

Bring us the workflow and its sources.

DBAI can help map the inputs, identify the dependencies, and scope an AI pilot your team can evaluate. Start with the job you want done.

Discuss your AI workflow