📊 Excel Sales Performance Dashboard

---

📌 Project Overview

Developed an interactive sales dashboard in Excel to analyze 5K+ sales records, identify trends, and support data-driven decision making.

❗ Problem Statement

• Difficulty in tracking sales and profit trends
• Lack of visibility into regional and category performance
• Challenges in evaluating manager performance

💡 Solution

Built a dynamic dashboard using Pivot Tables, Charts, and Slicers to simplify data analysis and improve reporting efficiency.

🛠️ Tech Stack

• Microsoft Excel
• Pivot Tables & Charts
• Slicers
• Data Visualization

📊 Key Features

• Monthly Sales & Profit Analysis
• Revenue by Product Category
• Regional Sales Visualization
• Manager Performance Comparison
• Interactive Filters (Region, Category, Segment, Manager)

📈 Results & Impact

• Analyzed 5K+ sales records to identify key trends
• Identified top-performing categories and regions
• Improved decision-making using interactive filters
• Reduced manual reporting effort by 30%

🎯 Project Purpose

Demonstrates the use of Excel for building interactive dashboards and extracting business insights.

👨‍💻 Created By

Dudekula Reshma