#04

Sales Intelligence Dashboard

Personal

Turned a raw 50,000-row sales export into a repeatable pipeline and an interactive dashboard that exposed where revenue was leaking.

key metrics · highlights
$12,000monthly revenue deficit uncovered
50,000rows analyzed
3 days → 4 hreporting cycle
mission briefing · details
  • >Pandas/NumPy aggregation surfaced underperforming SKUs hidden in raw spreadsheet exports.
  • >Ingestion, cleansing, aggregation and visualization automated in one reproducible Python script, with an interactive Power BI dashboard on top.
tech stack
PythonPandasNumPySeabornPower BI
year2023