Project Overview
This project involved analyzing detailed sales data from a coffee shop to uncover trends, assess performance, and support decision-making. By leveraging descriptive analytics techniques, the project aimed to identify the best-performing items, sales patterns, and areas for operational improvement. The insights were designed to guide strategies for enhancing profitability and customer satisfaction.
Key Outcomes
- Identified the top-selling products and peak sales periods, enabling targeted promotions and inventory optimization.
- Analyzed customer preferences to support personalized marketing campaigns.
- Delivered actionable insights on underperforming items, leading to data-driven recommendations for menu adjustments.
Tools Used
- Microsoft Excel
- Pivot Tables
- Charts
- Descriptive Statistics
