Sales Performance & Business Insights Dashboard

# Sales Performance & Business Insights Dashboard

## Project Overview

An interactive sales dashboard developed in Microsoft Excel to analyze sales performance, customer behavior, product pricing, quantity sold, and profitability across different categories, cities, and time periods.

The dashboard was designed to transform transactional sales data into a clear business overview that supports faster performance analysis and decision-making.

## Business Challenge

The main challenge was to organize and analyze sales data from multiple dimensions and present the most important KPIs in a single interactive dashboard.

The analysis aimed to answer:

* Which cities generate the highest quantities?

* How do sales change throughout the year?

* Which product categories contribute the most to discounted sales?

* How are sales distributed between male and female customers?

* Which products have the highest prices?

* How do price and quantity vary across categories?

* Which categories show the strongest performance?

## Tools & Technologies

* Microsoft Excel

* Excel Tables

* Pivot Tables

* Pivot Charts

* Data Cleaning & Preparation

* Data Visualization

* Interactive Filters / Slicers

* Dashboard Design

## Key KPIs

* **Total Quantity:** 33,769

* **Total Sales:** 234,524

* **Total Customers:** 6,135

## Key Analysis

* Quantity by City

* Sales by Gender

* Monthly Sales Trend

* Profit Margin by Category

* Discounted Sales by Category

* Price by Product

* Price & Quantity by Category

* State and City filtering

## Key Insights

* New York recorded the highest quantity among the analyzed cities.

* Sales performance fluctuated throughout the year, with January recording one of the strongest monthly results.

* Electronics generated the highest discounted sales among the categories.

* Customer sales distribution between males and females was relatively balanced.

* Electronics and Home Appliances showed strong performance in terms of quantity.

* The dashboard makes it easy to compare product and category performance through interactive filtering.

## What I Learned

Through this project, I improved my ability to:

* Clean and organize raw sales data.

* Build Pivot Tables and Pivot Charts.

* Create interactive Excel dashboards.

* Choose appropriate visualizations for different business questions.

* Track and present KPIs effectively.

* Analyze sales trends over time.

* Compare products, cities, categories, and customer segments.

* Turn raw transactional data into meaningful business insights.

## Project Outcome

The final dashboard provides a centralized view of sales performance and allows users to explore the data interactively using filters, making it easier to identify trends, compare performance, and support data-driven decisions.