📊 Excel Sales Performance Dashboard – Indian Retail Analytics

---

🧭 Table of Contents

• Project Overview
• Objective
• Tools Used
• Dataset Description
• Dashboard Features
• Key Insights
• How to Use
• Skills Demonstrated
• Future Enhancements
• Author

---

📘 Project Overview

This project showcases an interactive Excel dashboard built using a custom dataset of Indian retail sales across regions, states, cities, and products.
It helps business stakeholders quickly identify trends, top products, and top-performing salespersons.

---

🎯 Objective

• Analyze 500+ transactions from an Indian retail dataset.
• Create a dynamic dashboard using Pivot Tables, Charts, and Slicers.
• Deliver actionable insights about sales performance and regional trends.

---

⚙️ Tools Used

Tool	Purpose
🧮 Microsoft Excel	Data cleaning, analysis, and dashboard creation
📊 Pivot Tables	Summarizing data by region, product, and salesperson
🧭 Slicers	Interactive filtering by Region, Category, and Month
🪄 Charts	Visualization of top 5 products and monthly sales trends

---

🧾 Dataset Description

File: India_Retail_Sales_Dataset.xlsx
Contains columns like:

Column	Description
Date	Transaction date
Region	North, South, East, West
State / City	Geographic data
Category	Product group (Electronics, Apparel, etc.)
Product	Individual product sold
Quantity	U