Cafe Harmony Performance Dashboard

Excel operations dashboard analyzing hourly sales, customer traffic, and product performance

🎯 Challenge

Cafe Harmony, a popular neighborhood coffee shop, struggled with inefficient staffing, inventory waste, and long wait times during peak hours. Management lacked data-driven insights into hourly traffic patterns, product performance, and customer preferences, making it difficult to optimize operations.

💡 Solution

Developed an Excel operations dashboard tracking:

Hourly sales patterns and customer traffic by day of week
Product category performance (beverages, food, pastries)
Profit margin analysis by product type
Inventory turnover and waste tracking

Excel Pivot Tables Operations Analytics

Cafe Harmony Performance Dashboard

🎯 Challenge

💡 Solution

1️⃣ Morning Rush Dominates Revenue

2️⃣ Beverage Profit Margins

3️⃣ Afternoon Waste Problem

📈 Business Impact

🎯 Key Actions Taken

Staffing Optimization

Inventory Management

Product Mix Strategy