Sales Performance Dashboard

This project focuses on analyzing sales performance and transforming raw data into actionable business insights using Power BI.

The goal was to build an interactive dashboard that enables decision-makers to monitor performance, identify trends, and optimize business strategies.

What I did:

Cleaned and prepared raw sales data using Excel

Designed a structured data model for analysis

Built an interactive Power BI dashboard for real-time insights

Key Features:

Tracking Total Sales, Total Profit, Total Orders, and Average Order Value

Monthly Sales vs Target performance analysis

Profit distribution by region

Discount trend analysis to evaluate its impact on profitability

Dynamic filtering by product category and sub-category

Key Insights:

Increasing discounts negatively impacts overall profit margins

Certain regions contribute more to profit despite lower sales volume

Sales performance shows fluctuations across different periods

Business Value:

This dashboard helps businesses make data-driven decisions by highlighting performance gaps, identifying growth opportunities, and improving overall sales strategy.

Tools Used:

Power BI

Excel