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
More like this
Related projects
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
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project
Client-Level Audit Tool
Healthcare (Behavioral Health)
An audit workbook that pulls documentation data from the EHR and checks every client against state compliance rules: admission paperwork, daily summaries, group and one-to-one notes,…
View project