analytics-pipeline - KPI report from a messy CSV

A deliberately messy fictional sales CSV becomes a repeatable KPI report, with every cleaning action and anomaly surfaced for review.

The problem. A polished chart can still be confidently wrong. Duplicates, invalid quantities, missing values and fat-fingered revenue silently distort dashboards. The useful deliverable is not the number - it is the number together with the reasons a human should question it.

Committed output: $120,691.08 total revenue across 397 clean orders, $304.01 average order value, 113 unique customers - plus the list of rows that were dropped or flagged and why.

Raw input included exact duplicates, missing regions, non-positive quantities, mixed date formats and missing revenue. None of it was quietly averaged away.

Code: github.com/jigonyoo/analytics-pipeline