☕ Coffee Sales Analysis Dashboard
📌 Project Overview This project presents a Coffee Sales Analysis Dashboard built in Power BI to track sales trends, identify best-selling products, and uncover customer purchase behaviour. The analysis helps businesses optimise sales strategies, product focus, and marketing campaigns.
🔎 Business Questions / Problems
- Which coffee product generates the highest sales?
- Which month contributes most to revenue?
- On which weekday do customers purchase the most coffee?
- What are the overall sales trends across weekdays and weekends?
- Which coffee categories are most preferred by customers?
🔑 Key Insights
-
Total Sales Performance Achieved 112.25K total sales
-
Best-Selling Coffee Latte is the top-selling product
-
Best Month for Sales March recorded the highest sales
-
Top Weekday for Sales Tuesday generated maximum sales
-
Customer Preferences by Category Espresso-based drinks dominate sales (Latte, Cappuccino, Americano, Mocha)
-
Weekly Trend Higher sales on weekdays, with a dip on weekends
7.More sales in Aftrnoon
🎯 Business Outcomes
Product Strategy: Focus on Latte promotions and combos Seasonal Strategy: Replicate March’s successful campaign strategies in other months Sales Improvement: Target weekends with offers and loyalty programs Menu Innovation: Expand espresso-based drink variations (iced, flavoured, seasonal)
🎯 To increase revenue, the business should:
Promote Latte-based combos Replicate March’s successful sales strategies Launch weekend offers to balance sales Introduce new espresso drink variations
🛠 Tools Used Power BI – Data Visualisation & Dashboard Excel / CSV – Data Source DAX - For deep analysis outcomes SQL
👉 This dashboard helps coffee businesses make data-driven decisions to increase sales, identify customer trends, and strengthen product strategy.