Logo

Data Management

Data Quality Intelligence

AI Generated Summary

Overall data quality score is 96.4%, down 0.8pt this week due to a rise in duplicate customer records from the CRM sync. Schema validation is passing on all critical tables. 3 issues are open in the resolution center.

Confidence 95.1% · generated 8 min ago

Enterprise Quality Score

−0.8pt this week

Completeness

98.1%

Consistency

97.4%

Validity

96.8%

Freshness

92.2%

Scored across 19 critical tables · 4 quality dimensions

Missing Data Analysis

Null rate by field

Duplicate Detection

Duplicate records by table

Schema Validation

customer_accountsPassed
revenue_transactionsPassed
product_catalogPassed
support_ticketsWarnings
model_predictionsPassed
billing_ledgerPassed
18 of 19 critical tables validated 97.4% pass rate

Consistency Analysis

Cross-source consistency score · heatmap

Data Freshness

customer_accountsFresh
support_ticketsStale (4h)
revenue_transactionsFresh
product_catalogFresh
model_predictionsFresh
billing_ledgerFresh
1 of 6 tables stale 92.2% freshness score

Data Profiling

Value distribution · customer_age field

Quality Trend Analysis

Overall quality score · last 14 days

Cleansing Recommendations

Run a deduplication pass on customer_accounts using email + phone matching to resolve 1,240 suspected duplicates.
Backfill support_tickets freshness by shortening the sync interval from 4h to 30m.
2 recommendations pending

AI Quality Insights

Duplicate rate increased after the latest Salesforce sync began writing without upsert deduplication — a config fix is recommended.

support_tickets freshness has drifted to a 4-hour lag, tracing back to a widened sync-interval change on the ticketing connector.

Schema warnings on support_tickets stem from an unannounced field-type change (priority: int → string) upstream.

Confidence 92.8%

Issue Resolution Center

1,240 duplicate customer records

Source: Salesforce CRM sync

support_tickets freshness degraded to 4h

Source: Zendesk sync

customer_age field has a 6.2% null rate

Source: customer_accounts table

3 issues open 2 resolved this week

Audit Timeline

Duplicate rate exceeded threshold

3 hours ago

Schema validation passed on all 19 critical tables

6 hours ago

Audit events logged today 14 events

Quality Alerts

support_tickets freshness degradedWarning
Duplicate rate above 5% on customer_accountsCritical
Active alerts 2 open