Sales Dashboard in Excel

An interactive Excel dashboard that provides a clear snapshot of business performance and transforms raw sales data into actionable insights.

---

Project Overview

This project demonstrates how raw transactional data can be turned into a dynamic dashboard using Excel. The dashboard includes KPIs, slicers, and visuals that allow users to interactively explore business performance across multiple dimensions.

---

Features

• KPIs:

  • Total Sales
  • Total Orders
  • Average Order Value

• Slicers:

  • Category
  • Region
  • Segment

• Charts & Visuals:

  • Sales by Top Cities
  • Sales by Segment
  • Monthly Sales Trends

---

Visualizations Created

• KPI Cards → Quick snapshot of Total Sales, Orders, and AOV
• Sales by Top Cities → Bar chart of best-performing cities
• Sales by Segment → Vertical bar chart comparing customer segments
• Monthly Trends → Line chart for revenue growth patterns
• Interactive Filters → Slicers to drill down into specific markets

---

Key Benefits

• Spot top-performing markets and segments in seconds
• Track monthly sales patterns effortlessly
• Enable real-time exploration with slicer-driven interactivity
• Deliver data-driven decision support without extra tools

---

Tools & Skills Demonstrated

• Excel: Pivot Tables, Pivot Charts, Slicers
• Data Visualization: Business KPIs & Trend Analysis
• BI Reporting: Turning raw data into a visual story

---

Business Impact

This dashboard enables:

• Faster sales performance reviews
• Easy comparison of categories, regions, and segments
• Executive-friendly reporting without coding
• A reusable framework for future datasets

---

Project Structure

├── LICENSE                #License file
├── README.md              #Project Documentation
├── Sales Dashboard.xlsx   # Main interactive Excel dashboard