Product Analysis Report Generator
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and rate-of-sale outputs for every sales channel, complete with clustered charts.
- Industry
- FMCG / Retail Analytics
- Deliverable
- Product Analysis Report.xlsm
- Built with
- Excel VBA, Pivot tables, Charts
Before
Each sales report meant rebuilding pivots, filters and charts by hand for every channel.
After
Raw sales data goes in and Pareto, NIS and rate-of-sale reports with charts come out for every channel in one run.
More like this
Related projects
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by…
View project
Fire Extinguisher Service Report Generator
Fire Safety Services
Turns raw service visit data into printable inspection reports and certificates for each customer site. Reports are exported to PDF and CSV and follow-up reminders are…
View project
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project