# 📊 Coffee Sales Analytics Dashboard (Excel)

---

📌 Table of Contents

• 📖 Overview
• 🎯 Objectives
• 🛠️ Tools & Techniques
• 📂 Dataset Description
• 📊 Dashboard Preview
• 🔍 Key Insights
• 🚀 How to Use
• 📈 Project Workflow
• 📁 Repository Structure
• 👨‍💻 Authors and Contact

---

📖 Overview

This project presents an interactive Excel dashboard to analyze coffee sales across countries, customers, and product categories.

---

🎯 Objectives

• Analyze sales trends over time
• Identify top customers
• Compare country-wise performance
• Understand product demand patterns

---

🛠️ Tools & Techniques

• Microsoft Excel
• Pivot Tables & Pivot Charts
• XLOOKUP & INDEX MATCH
• Data Cleaning
• Slicers & Timeline

---

📂 Dataset Description

The project uses a single Excel workbook with multiple sheets:

• Orders (transaction data)
• Customers (customer details)
• Products (product details)
• Merged dataset created using lookup functions

---

📊 Dashboard Preview

---

🔍 Key Insights

🌍 Market Performance

• The United States contributes the majority of total sales.
• Ireland and the United Kingdom contribute smaller shares in comparison.

---

👥 Customer Contribution

• A small group of customers accounts for a noticeable portion of total revenue.

---

☕ Product Trends

• Different coffee types show varying sales across months.

---

📅 Time-Based Trends

• Sales fluctuate month to month, indicating some level of seasonality.

---

🚀 How to Use

1. Download the Excel file from the data/ folder
2. Open it in Microsoft Excel
3. Use slicers to explore the dashboard

---

📈 Project Workflow

1. Data collection (Orders, Customers, Products)
2. Data cleaning
3. Data merging using XLOOKUP & INDEX MATCH
4. Creating calculated fields (Sales)
5. Building pivot tables
6. Creating the dashboard

---

📁 Repository Structure

coffee-sales-dashboard/
│
├── 📁 data/
│   └── coffeeOrdersData.xlsx
│
│── 📁 dashboard/
│   └── dashboard.jpg
└── README.md

---

👨‍💻 Author & Contact

Author: Mohd Walid Ansari
Email: walidmohd2532001@gmail.com
GitHub: mohdwalid253
LinkedIn: Mohd Walid Ansari