Welcome to the Coffee Sales Analytics Project by Ankit Poddar.
This project highlights how raw café-level data was transformed into decision-ready insights using Microsoft Excel — ideal for back-office reporting and analysis.
- 📊 Microsoft Excel – Pivot Tables, Charts, KPI Cards
- 🧹 Data Cleaning – Missing values, duplicates, and format fixes
- 📈 Data Visualization – Dynamic dashboards & drill-down charts
- 🧠 Analytical Thinking – Sales trends, promo impact, upsell strategy
- 🔍 Identified +18% revenue boost by shifting "Happy Hour" to Thursdays
- 📦 Flagged slow-moving SKUs with bundling suggestions to reduce waste
- 💡 Revealed that large coffee sizes contribute 45% of revenue — enabling targeted upsells
- ⏰ Uncovered peak sales hours and best-selling product combinations