Frutta Secondary Sales Dashboard
A central sales-reporting view for understanding SKU performance, field activity and territory results in an FMCG operation.
The business challenge
Manual reports arrived in inconsistent formats. Management needed a clearer view of products, reps and regions rather than relying on disconnected summaries or gut feel.
My contribution
I mapped the sales data pipeline from field reports to management decisions. I focused on data structure and accessibility, designed a normalised data model and defined business KPIs including MTD revenue, cases sold, outlet coverage and rep compliance.
Main activities and deliverables
- Centralised SKU-level reporting.
- Rep-performance tracking and territory comparisons.
- Regional achievement breakdowns and ASM-level filtering.
- Performance views that identify top and bottom performers.
Reporting outcome
The dashboard brings product, field and territory reporting into a shared management view. Figures visible in the approved capture describe its reporting period; they are not revenue attributed to my work.
Tools and platforms
- Advanced Excel
- Power BI
- Google Sheets
- Data modelling
- GitHub Pages