Built an end-to-end analytics system that converted fragmented sales, cost, and fulfillment data into one clear decision layer. The system surfaces margin leaks, high-impact SKU opportunities, and performance shifts in near real-time so teams can act faster with confidence.
112K+
rows normalized
9
data sources unified
97%
validation pass rate
<5m
health check runtime
what made this project stand out
- Validation-first ETL workflows with anomaly flags and source confidence scoring.
- Executive-ready metrics layer tracking margin, churn risk, and growth efficiency.
- Automated alerting for sudden demand, inventory, and pricing behavior shifts.
- Root-cause drilldowns from board-level KPIs to SKU and channel diagnostics.
Python
SQL
ETL
Data Modeling
Validation
BI Dashboards
live case artifact
profit detective report preview
Explore the report directly on the page. This snapshot highlights the business narrative, KPI structure, and drilldown design used to turn raw operational noise into decision-ready insight.