Should you fix your data before or during an AI pilot?
You do not need perfect data to start, and you cannot wait for it either. The answer is a phased one, and it depends entirely on the use case.
Should you fix your data before or during an AI pilot?
This is the question that stalls teams before they even begin. One camp says do not touch AI until the data is clean, which means never, because data is never clean. The other says just start and fix it as you go, which means building on sand. Both are wrong as absolutes. The real answer is phased, and it depends on what the use case actually needs.
There is no universally ready state to wait for
Start with the fact that dissolves the “fix everything first” position: readiness is relative to the use case. There is no universal “AI ready” state to achieve. Data that is nowhere near ready for a real-time customer feature can be more than ready for an internal summarization task. So “fix the data first” has no finish line, because ready is defined by the specific feature, not by the data in the abstract. You cannot fix your way to a state that does not exist.
Phase it the way migrations are phased
An engineering lead who has moved billions of records between systems does not clean everything up front and he does not wing it either. He phases the work. For a large migration, he runs a first pass on the core data, customers, products, and sales, then lets the merchant reconcile and review, and then reruns the tool for the remaining incremental data right before go-live. The sequence is fix the essential, validate with a human, then close the gap. That is the template. Fix the data the pilot genuinely depends on before you start, prove the pilot on it, and clean the rest during the pilot as you learn which parts actually matter.
Fix what blocks the outcome, defer what does not
The trap on both sides is treating all data equally. Some fields are load-bearing for your use case and some are noise. Fix the load-bearing ones before day one, because a pilot built on wrong core data proves nothing. Defer the rest, because cleaning fields the feature never reads is a way to feel productive while the pilot waits. The migration lead’s own habit of covering the common cases first and handling edge cases later, sometimes by hand, is exactly this triage applied to data.
Let the pilot tell you what to fix next
Done in phases, the pilot becomes a source of information about your own data. It surfaces which fields it actually leans on, which conflicts it hits most, and which mess degrades the output. That is a far better prioritization signal than a pre-pilot audit that tried to grade everything at once. You fix, you learn, you fix the next thing the pilot pointed at.
Cleaning everything first has a hidden cost
There is also a timing cost to the “fix it all first” instinct that teams rarely price in. Every month spent scrubbing data the feature may never read is a month the pilot has not run, which means a month of not learning what actually matters. Worse, you can clean fields to a standard the use case did not require and still be blocked by the one field you overlooked. Effort spent on the wrong data is not readiness, it is delay wearing a productive costume. The phased approach protects against both failure modes: you fix enough to start, and you let the running pilot tell you where the next real gap is.
How we approach it at Density Labs
In the AI Readiness Assessment, our fixed two week, $2,500 engagement, we help you draw the line between the data you must fix before the pilot and the data you can clean during it. We identify the load-bearing fields for your use case, so you fix what the outcome depends on and stop polishing what it does not. Before or during is the wrong framing. It is both, in the right order.
Perfect data is a mirage. The right sequence is not.