Data Quality Report
Overall quality score: 90.3/100 — Excellent
7
Tables
550,688
Total Rows
4
Clean Tables
0
Duplicates
Table-Level Quality Report
| Table | Rows | Columns | Missing Cells | Missing % | Duplicates | Status |
|---|---|---|---|---|---|---|
| Customers | 99,441 | 5 | 0 | 0.00% | 0 | Clean |
| Orders | 99,441 | 8 | 4,908 | 0.62% | 0 | Partial |
| Order Items | 112,650 | 7 | 0 | 0.00% | 0 | Clean |
| Payments | 103,886 | 5 | 0 | 0.00% | 0 | Clean |
| Reviews | 99,224 | 7 | 145,903 | 21.01% | 0 | Issues |
| Products | 32,951 | 10 | 3,058 | 0.93% | 0 | Partial |
| Sellers | 3,095 | 4 | 0 | 0.00% | 0 | Clean |
Known Data Issues
Many reviews have no comment text — review_comment_title and review_comment_message are frequently empty.
Mainly missing order_approved_at and order_delivered_customer_date for non-delivered or older orders.
product_category_name and product dimensions are missing for some items.
Data Lineage & Sources
olist_customers_dataset.csv
Customer profiles with zip code and state
olist_orders_dataset.csv
Order headers with status and timestamps
olist_order_items_dataset.csv
Line items linking orders to products
olist_order_payments_dataset.csv
Payment records by type and value
olist_order_reviews_dataset.csv
Customer review scores and comments
olist_products_dataset.csv
Product catalog with category and dimensions
olist_sellers_dataset.csv
Seller profiles with location
product_category_name_translation.csv
Portuguese → English category translation
olist_geolocation_dataset.csv
Zip code geo-coordinates (not joined)
Ask the AI Analyst
"Explain database schema" or "Draw ER diagram"