☕ Coffee Sales Dashboard – Excel Data Analytics Project

---

📌 Project Title

Coffee Sales Dashboard: Dynamic Excel Visualization for Business Insights

---

🎥 Excel Dashboard Demo

---

📊 Project Summary

This project is inspired by Mochan's YouTube tutorial on building a comprehensive and interactive Excel dashboard for coffee sales. The dashboard is built using real-world-style data, transformed using advanced Excel functions and presented with visually intuitive pivot charts and slicers.

It covers the full analytical workflow — from importing and cleaning data to visualizing KPIs, trends, and top-performing products. Designed to be interactive and user-friendly, this dashboard helps stakeholders make fast, informed decisions.

---

🚀 What I Did

• 📥 Imported data from multiple sheets: Orders, Customers, and Products
• 🧹 Cleaned and transformed data using Excel Tables, XLOOKUP, and INDEX-MATCH
• 📊 Built dynamic Pivot Tables and Pivot Charts
• 🎛️ Added interactive elements like Slicers, Timeline, and Dropdowns
• 🎨 Formatted visuals for a sleek and professional dashboard layout

---

✅ Key Features

• Dashboard KPIs: Total Sales, Profit, Quantity Sold, AOV
• Visual Breakdown: Product-, Category-, and Region-wise performance
• Time-Series Trends: Analyze data over months using timeline filters
• Top Performers: Best-selling products and high-revenue regions
• Filters: Region, Category, Product Name, Month
• Clean, Minimal Layout: Easy to use and interpret

---

📁 Files Included

• Coffee Sales Dashboard.xlsx – Fully interactive Excel dashboard
• orders.csv, products.csv, customers.csv – Raw data sources
• README.md – Project documentation
• dashboard_images.png – Pooject demo

---

🛠️ Tools & Tech

• Microsoft Excel 365 / 2021
• Pivot Tables & Pivot Charts
• Excel Tables for Dynamic Range
• Advanced Formulas: XLOOKUP, INDEX-MATCH, IF, TEXT, SUMIFS
• Visual Features: Slicers, Timeline, Conditional Formatting

---

🧠 Use Cases

• 🛒 Sales Analysis for Retail or Coffee Businesses
• 📈 Marketing Insights for Region-Based Performance
• 🧾 Business Reporting for Inventory and Revenue Trends
• 🎯 Portfolio Project to Demonstrate Excel Proficiency
• 🧑‍💼 Management Decision Support through KPIs

---

🙌 Acknowledgments

• Mochan’s YouTube Tutorial – Source of inspiration
• Microsoft Excel community and dashboard creators worldwide
• Coffee ☕ — for keeping analysts awake 😄

---