📊 Sales Report Dashboard (Excel Project)

📊 Dashboard Preview

---

📌 Project Overview

This project is an interactive Sales Report Dashboard built using Microsoft Excel.
It helps analyze sales performance, customer behavior, and business trends using visual insights.

---

🎯 Objectives

• Analyze monthly sales and order trends
• Compare customer distribution by gender
• Track order status (Delivered, Cancelled, Returned)
• Identify top-performing states
• Analyze age group vs gender contribution
• Identify highest performing sales channels

---

🛠️ Tools & Skills Used

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Data Cleaning
• Data Visualization
• Dashboard Design

---

📊 Dashboard Features

1. Sales & Order Comparison

• Monthly analysis of sales amount and order count

2. Men vs Women Analysis

• Gender-based sales contribution

3. Order Status

• Delivered vs Cancelled vs Returned orders

4. Top Performing States

• State-wise sales performance

5. Age vs Gender Analysis

• Customer segmentation by age and gender

6. Sales Channels

• Performance across platforms like Amazon, Myntra, Flipkart

---

🔍 Key Insights

• Women contribute the majority of sales
• Most orders are successfully delivered
• Top states drive a large portion of revenue
• Online platforms like Amazon and Myntra lead in sales

---

📂 Project Files

• sales_report_dashboard.xlsx → Main dashboard
• dashboard_preview.png → Dashboard image preview

---

🚀 How to Use

1. Download the Excel file
2. Open in Microsoft Excel
3. Navigate through different sheets
4. Interact with charts and analyze insights

---

📈 Learning Outcome

• Built an end-to-end Excel dashboard
• Gained experience in data analysis and visualization
• Improved business insight generation

---

👤 Author

Aspiring Data Analyst