Café Harmony is a vibrant virtual café chain offering drinks, snacks, and light meals across four key city locations—Uptown, Airport, Suburbs, and Downtown. With an expanding customer base and growing demand, the business needed actionable insights to enhance sales, customer satisfaction, and product performance.
This project leverages Microsoft Excel to analyze a master dataset of 608 sales and feedback responses. I applied advanced Excel formulas and created an interactive dashboard using pivot tables, slicers, and visual charts to communicate key business insights and support strategic decision-making.
- Analyze sales performance by location and product
- Identify trends in customer satisfaction and demand
- Optimize stock levels and product availability
- Recommend targeted promotions for underperforming items
- Support employee performance with data-driven incentives
- Microsoft Excel
- Advanced formulas:
IFS,IF AND,COUNTIF,XLOOKUP,INDEX/MATCH - Pivot Tables & Charts
- Interactive Dashboard with slicers and KPIs
- Top Sellers: Cappuccino and Muffins
- Low Performers: Croissant and Latte (due to low stock and customer perception)
- Customer Feedback: Cappuccino has the highest negative ratings, despite being the top-selling item
- Milk Shortage is impacting latte quality and cappuccino consistency
- Bundle high-performing products (Cappuccino + Muffins) to drive higher revenue
- Promote Croissant and Latte via trendy bundles, discounts, and social media campaigns targeted at younger age groups (18–43)
- Offer healthy product alternatives for older customers (57+)
- Improve Latte performance by sourcing quality milk and adjusting price/taste
- Compensate top-performing staff with sales commissions to motivate performance
- Provide monthly/quarterly employee training to boost service and sales
- Investigate low feedback scores (1 & 2) to identify service gaps
- Improve product experience to convert average (3-star) reviews to 4 or 5 stars
- Review Cappuccino Ingredients: Conduct customer surveys, hire a coffee expert, and improve supplier quality
- Stock Optimization: Address shortages in milk, monitor ingredient usage, and forecast demand
- Feedback Analysis: Dive into comments to pinpoint dissatisfaction drivers and adjust service or product strategies
- 📊 Excel Dashboard (with formulas and visualizations)
- 📄 PowerPoint Presentation (summary of findings and recommendations)
📧 Email: osarohekhoragbon@gmail.com
💼 LinkedIn: linkedin.com/in/osarohekhoragbon
🌐 GitHub: github.com/OsarohEkhoragbon