This is a retail sales

This is a retail sales and profit dashboard I built from scratch to turn complex spreadsheet data into easy-to-read visuals. The main goal of this project was to make a messy dataset meaningful so a business owner can instantly check how their store is performing.

Here is how I worked on this project:

Data Cleaning: I went through the entire raw file in Excel, filtered out bad entries, and organized the rows to make sure the dashboard numbers are completely accurate.

KPI Tracking: I used Excel formulas to pull out core business metrics, such as total revenue, total orders, and the overall profit margin (12.47%).

Designing Charts: I set up clean visuals to show key trends, like sales by shipping modes, customer segments, and a breakdown of top-performing products.

I also added dynamic slicers, so you can click on any region or year and the whole screen updates automatically. I handled this entire project manually from start to finish.

Tools used: Advanced Excel (Pivot Tables, Slicers, Formulas, Dashboard Design)