Data Quality Assessment - After Cleaning
Analysis of cleaned Cookie Dough Kuwait data showing quality improvements
View:
Total Records: 41,421•Assessment Date: 11/24/2025
Overall Data Quality Score
Average of all 5 quality dimensions
100.00%
Excellent+17.04%
Data Cleaning Impact
Through systematic data cleaning, we improved overall data quality from 82.96% to 100.00%, an increase of +17.04%.
Accuracy
+58.83%
Completeness
+19.14%
Consistency
+7.22%
Timeliness
+0.00%
Uniqueness
+0.00%
📊
Accuracy
Valid phone formats, email formats, area names, and transaction IDs
100.00%Excellent
Improved by +58.83%
Valid: 41,420 / 41,421
Before: 41.17% → After: 100.00%
Remaining Issues:
- •Invalid phone format: 0 records
- •Missing/invalid area: 0 records
✅
Completeness
All required fields present (Customer Name, Phone, Area, Transaction Date, etc.)
100.00%Excellent
Improved by +19.14%
Valid: 41,421 / 41,421
Before: 80.86% → After: 100.00%
Remaining Issues:
- •No missing required fields
🔗
Consistency
Logical relationships maintained (dates, totals, quantities, prices)
100.00%Excellent
Improved by +7.22%
Valid: 41,421 / 41,421
Before: 92.78% → After: 100.00%
Remaining Issues:
- •Note: 'Expected date before transaction date' rule excluded (business-acceptable)
- •Negative order total: 0 orders
⏰
Timeliness
Dates within valid business range (not future, after business start)
100.00%Excellent
Valid: 41,421 / 41,421
Before: 100.00% → After: 100.00%
Remaining Issues:
- •Future transaction dates: 0 records
- •Dates before business start (2020-08-30): 0 records
🔑
Uniqueness
No duplicate transaction IDs, customer IDs, or line items
100.00%Excellent
Valid: 41,421 / 41,421
Before: 100.00% → After: 100.00%
Remaining Issues:
- •Duplicate transaction IDs: 0 records
- •Duplicate customers: 0 records
Quality Score Legend
Green (90-100%): Excellent quality
Yellow (70-89%): Acceptable with issues
Red (<70%): Poor quality, needs improvement