In this project, I worked on cleaning raw sales data and transforming it into meaningful insights using Microsoft Excel. I applied pivot tables and interactive filters to organize information by city, product, payment method, and customer. The analysis highlighted key performance metrics such as total quantity sold, total revenue, and profit across five major cities.

Mumbai emerged as the top-performing city with the highest revenue and profit, while Chennai showed the lowest figures. The final dashboard included a 3D bar chart for clear visualization, making it easy to compare city-wise performance at a glance.

This project demonstrates my ability to:

Perform data cleaning and structuring

Build pivot tables for multi-dimensional analysis

Apply filters for dynamic exploration

Create professional charts for business insights

Impact: The analysis provided actionable insights into regional sales performance, helping identify strong markets and areas for improvement.