Investigate all 10 planted data quality issues across the BI schema
Something is very wrong with the numbers the board deck pulled last week. Revenue totals don't match between reports. Product counts look off. One region is showing up that shouldn't exist. I need a full data quality audit before we present anything externally. Find every issue you can — I've been told there are at least 10 problems buried in this database. Document what you find.
Each hint you reveal reduces the XP you can earn. Try the query first.
Check dim_products for duplicate product names: SELECT product_name, COUNT(*) FROM dim_products GROUP BY product_name HAVING COUNT(*) > 1
Look for the ghost region: SELECT r.region_name, COUNT(s.sale_id) FROM dim_regions r LEFT JOIN fact_sales s ON r.region_id = s.region_id GROUP BY r.region_name
Investigate hire dates: SELECT employee_id, hire_date FROM dim_employees WHERE hire_date > '2026-01-01' OR hire_date LIKE '%/%'