Which systems, which entities and which
definitions matter in your company is what the diagnostic finds out.
The modules are the same; their contents are yours.
Data Health Diagnostic
Two to three weeks: what disagrees, and what fixing it costs.
What's included
Inventory of systems, owners and update cycles. Where definitions conflict. One month's key numbers reconciled across sources. Event and integration checks. AI readiness. A gap list with fixed-price quotes.
Deliverable: a report with a one-page conclusion. Fixed fee.
Integration Layer
Every system connected read-only, on schedule, with lineage.
What's included
APIs where they exist, scheduled exports where they don't. Incremental loads. Lineage from source to table, documented.
Deliverable: connectors and their documentation. Fixed price.
Entity Resolution
One record per customer, product or supplier across systems.
What's included
Matching by rule on the identifiers each system holds. Survivorship rules for conflicting values. Merged records written back to the operating tools that need them.
Deliverable: master tables and write-back channels. Fixed price.
Definitions and Metrics
Revenue, margin and customers defined once, in writing.
What's included
Definitions agreed with finance and operations. Edge cases decided and documented: returns and refunds, currencies, cost allocation, de-duplication across systems. The same number in every report.
Deliverable: a definitions document and the metrics layer that implements it. Fixed price.
Dimensional Model
One model, one fact table per process, history kept.
What's included
Dimensions shared across the company; a fact table for each business process the diagnostic identifies. Business keys, hash keys and change history. Daily reconciliation against every source, with alerts.
Deliverable: the model, reconciliation reports, code and documentation. Ships with projects.
Managed Operations
Kept correct as systems change. Monthly.
What's included
Interface-change tracking, a monthly data-health report, new sources and definitions, incident handling.