How to Validate AI-Generated Analysis Before It Reaches Your Boss
A practical checklist for checking AI-generated analysis: reconcile totals, trace every number, test edge cases and label what is still an assumption.
Short answer: AI transformation usually stalls on data, not models. Gartner expects organisations to abandon 60% of AI projects that lack AI-ready data through 2026, and RAND notes estimates that more than 80% of AI projects fail. Before choosing a model, check that your key metrics have one definition, your data has an owner, and you can measure whether the AI actually helped.
Every company I read about has an AI transformation story in progress. Many of them have the same plot: an impressive pilot, a lot of excitement, then a slow fade when it meets real data. The model was rarely the problem.
This post covers why that happens, what the research says, and a readiness checklist you can run before the next pilot. It’s written from an analyst’s seat, because analysts are usually the first to see the cracks.
Strip the buzzword and AI transformation means changing how work gets done because AI now does part of it. Not “we bought a licence”. Not “we ran a pilot”. Work changes: a process is faster, a decision is better informed, a team spends its time differently.
That definition matters, because it tells you how to measure it. If nothing about the work changed, nothing was transformed, however good the demo looked.
The research points in the same direction.
A caveat on both: “fail” is defined differently across studies, and survey figures vary a lot. I’d treat them as “most”, not as precise percentages. The direction is consistent, though, and it matches what analysts see every day.
In plain terms, AI projects tend to fail for four reasons:
Creating a semantinc model with currated and well-defined definitions around the metrics totally makes a difference. For instance, defining “active users”: what time definition? Should all segments of customers be included and follow the same rules? Which source data table should be considered as the truth, the one coming from the CRM or any other system like the billing engine?
It sounds vague, so here’s the analyst’s version. Data is AI-ready when an assistant could answer a business question with it and you would trust the answer without redoing it yourself.
That needs four things:
| Property | What it means | Quick test |
|---|---|---|
| Defined | Each key metric has one written definition | Ask three teams for “active customers”. Same number? |
| Clean | Duplicates, nulls and test records are handled | Run a duplicate-row check on your main tables |
| Owned | Someone fixes the source when it’s wrong | Can you name the owner of your revenue table? |
| Documented | Tables and columns are described in words | Could a new hire find the right table in a day? |
The first row is the one that bites hardest. An AI can write perfectly valid SQL against the wrong definition of revenue, and nothing in the output will warn you. That’s the subject of why AI analysts fail on bad metric definitions, and it’s why a semantic layer is becoming part of the AI conversation.
You can do this in an afternoon, before anyone signs a contract.
If you can’t get through steps 2 to 4, that’s your answer: the next project isn’t an AI project. It’s a data project, and it’ll make every later AI project cheaper.
Closer to the middle than most org charts suggest. Analysts know which tables lie, which metrics have three definitions, and which dashboards nobody trusts. That’s exactly the knowledge an AI programme needs, and it rarely sits with the people buying the tools.
Practically, that means analysts can:
The evaluation set is the one I’d push hardest. Twenty real questions with answers you’ve checked by hand will tell you more about an AI tool than any vendor demo.
It’s not a model choice. Models improve every few months, and the gap between the leading ones is often smaller than the gap between clean and messy data.
It’s also not a one-off project. Data gets messy again the moment you stop looking after it. The organisations that do well treat data quality like hygiene: boring, constant, and noticed only when it stops.
My take: if you have one budget line for AI this year, spend the first part of it on definitions and data ownership. It’s the least exciting slide in the deck. It’s also the one that decides whether the rest of the deck comes true. If you think your data is already in good shape, the checklist above will confirm it in an afternoon, and I’d be happy to be wrong.
Sources: Gartner, “Lack of AI-Ready Data Puts AI Projects at Risk” (February 2025); RAND Corporation, “The Root Causes of Failure for Artificial Intelligence Projects and How They Can Succeed” (2024). The checklist is my own.
Part of: AI for Analysts