Skip to main content
OperationsJanuary 28, 20263 min read

Why Every ZAAI Project Starts with Data Quality Assessment

Before we build a single model, we spend 2–6 weeks understanding your data. Here's what we look for, what we commonly find, and why skipping this phase guarantees garbage-in-garbage-out.

Luís Roque
Luís Roque
Founder & Partner

Introduction

Every AI project begins with a promise: better forecasts, smarter automation, clearer insights. But the promise only holds if the data can deliver. We've seen too many initiatives fail because teams rushed to model building without understanding what was actually in their systems. At ZAAI, we allocate 2–6 weeks to data quality assessment before writing a single line of model code. It's not bureaucracy—it's the foundation everything else rests on.

What We Assess

We systematically evaluate four dimensions across every project:

Completeness — Are the fields we need present? Do we have coverage across the time range, geography, or product hierarchy we care about? Gaps in completeness often surface as "why didn't the model predict that?"—because the model never saw it.

Consistency — Do definitions align across systems? A "sale" in the ERP might differ from a "sale" in the POS. Unit of measure, currency, and aggregation rules must be explicit. Inconsistent definitions produce models that learn noise, not signal.

Freshness — How current is the data? Batch loads that run weekly create lag. Real-time systems can have different lag profiles by source. Stale data means stale predictions.

Granularity — What level of detail exists? Can we drill from aggregate to SKU, from region to store? Granularity determines what questions we can answer and what we cannot.

Common Findings

Across manufacturing, retail, finance, and compliance projects, we see recurring patterns:

Gaps — Missing periods, missing stores, missing product lines. Sometimes the gap is structural (a system wasn't live yet); sometimes it's operational (a load failed and nobody noticed). We map gaps before modeling so we know what we're forecasting into.

Duplicates — The same transaction or record appearing multiple times with slight variations. Deduplication logic varies by source; we need to understand and standardize it.

Misaligned timestamps — Order date vs. shipment date vs. invoice date. Which "date" drives the business process? Misalignment causes models to learn the wrong lead times and seasonality.

Missing external signals — Promotions, holidays, weather, competitor actions. Internal data alone often underperforms; external enrichment requires knowing what's available and how to join it.

Why This Phase Matters

Models are only as good as their inputs. A demand forecast trained on incomplete data will systematically miss certain products or periods. A reconciliation engine fed inconsistent definitions will produce false positives and false negatives. A compliance classifier trained on mislabeled documents will fail audits.

The 2–6 week assessment isn't a delay—it's risk mitigation. We've turned down projects where the data couldn't support the ask. We've redesigned scopes when assessment revealed that the real problem was upstream data, not downstream modeling. And we've accelerated projects where assessment gave us confidence to move fast.

In our manufacturing engagement with 2,000 time series, the assessment revealed that 12% of SKU-customer combinations had insufficient history for reliable forecasting. We designed the hierarchy and reconciliation strategy around that reality. In our fashion retail financial automation, we discovered that bank statement dates didn't align with ERP posting dates—fixing that alignment was Phase 0 before any ML.

Conclusion

Data quality assessment is the least glamorous part of an AI project. It doesn't produce dashboards or demos. But it's the phase that determines whether the rest of the project succeeds or fails. We start there because we'd rather know the truth early than discover it in production.

Tags:

Data QualityMethodologyMLBest Practices

Talk to ZAAI about a system like this.

We build AI products and bespoke systems for enterprises that need them in production, not in a deck.

Book a call