An interactive Sales Dashboard built in Microsoft Excel using the Super Store dataset. It transforms raw sales data into meaningful business insights through Pivot Tables, Pivot Charts, KPI Cards, and Slicers. The dashboard provides dynamic analysis of sales, transactions, regions, categories, shipping modes, and customer segments.
This project is an interactive Sales Dashboard developed using Microsoft Excel. It transforms raw Superstore sales data into meaningful business insights through Pivot Tables, Pivot Charts, KPI Cards, Slicers, and interactive visualizations. The dashboard enables users to monitor sales performance, analyze customer behavior, and identify business trends effectively.
- Interactive Region and Year Filters
- KPI Cards for Sales, Transactions, Average Sales & Quantity
- Monthly Sales Trend Analysis
- Region-wise Sales Distribution
- Category-wise Sales Analysis
- Ship Mode Analysis
- Consumer Segment Analysis
- Top 5 Cities by Sales
- Clean and Interactive Dashboard Design
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Slicers
- Conditional Formatting
- Data Cleaning
- Dashboard Design
The project uses the Superstore Sales Dataset containing:
- Customer Information
- Order Details
- Product Categories
- Sales
- Profit
- Quantity
- Shipping Mode
- Region
- Order Date
Images/
Dashboard.xlsx
Superstore Data.xlsx
README.md
- Data Cleaning
- Data Analysis
- Dashboard Development
- Business Intelligence
- Data Visualization
- KPI Reporting
- Interactive Reporting
- Microsoft Excel
Mayur Rajput
B.Pharm + MBA (Integrated) Student | NMIMS
Passionate about Data Analytics, Business Intelligence, Excel Automation, Power BI, and VBA.
⭐ If you found this project useful, don't forget to star the repository.