This project presents an excel dashboard analyzing sales performance across a coffee shop chain. It delivers actionable insights into customer behavior, product trends, and store-level performance—designed for business stakeholders to make data-driven decisions.
- Total Sales: $698,812.33
- Total Footfall: 149,116
- Avg. Bill per Person: $4.69
- Avg. Orders per Person: 1.44
- Hourly Order Trends: Peak demand between 8–10 AM
- Category Sales Breakdown: Coffee (39%), Tea (28%), Bakery (12%), etc.
- Size Distribution: Regular (31%), Large (30%), Small (9%)
- Top Locations by Footfall: Hell’s Kitchen, Astoria, Lower Manhattan
- Top-Selling Products: Barista Espresso, Brewed Teas, Hot Chocolate
- Weekday Footfall Patterns: Balanced traffic across all days
- Excel (Data source)
- Data modeling and transformation
This dashboard enables quick identification of high-performing products, peak hours, and customer preferences—supporting decisions in marketing, inventory, and store operations.