memory/sops/data_quality_sop.md

SOP-DQ-01: Data Quality Standard Operating Procedure

Owner: Data Analyst desk.

Scope

All raw order data ingested by the Analyst before KPIs are computed.

Required steps

1. Remove duplicate rows on (OrderID, SKU).
2. Impute missing prices using the category-level median price.
3. Flag any row whose order date cannot be parsed as ISO-8601.
4. Compute data_quality_score as valid_rows / total_rows.
5. Report the top revenue category and its share of total revenue.

Escalation

• Escalate to the Chief of Staff if data_quality_score < 0.70.
• The Analyst report must include duplicates_removed, imputed_prices, and data_quality_score metrics.