Data Quality
Cleaning applied: duplicate order_id rows dropped (first kept);
amounts that fail numeric parsing (N/A, unknown) excluded from revenue;
negative amounts kept as refunds (negative revenue);
region aliases normalized (TX/tx/Texas → Texas, CA → California, OH → Ohio);
mixed date formats (ISO, M/D/YYYY, “Mon D, YYYY”) parsed to quarters.