A sales dashboard that shows where the money comes from
Years of sales records turned into a clear view by product, branch and month.
- Client
- Food distributor
- Timeline
- 4 weeks
- Scope
- Data cleaning, analysis, dashboard
The problem
Sales data lived in monthly spreadsheets with different layouts. Nobody could say which products or branches made the profit.
What we built
- Records were cleaned, joined and checked against the accounting totals.
- Sales and margin were broken down by product, branch and month.
- A dashboard that updates itself, with a short findings note for the owner.
5 yearsof records combined
14%of products made 60% of profit
1 clickto view any branch
Built with Python, SQL, Power BI.