In this project, I built an interactive Sales Performance Dashboard entirely in Microsoft Excel, using the Superstore dataset to analyze sales, profitability, customer segments, product performance, and regional trends.
My objective was to turn raw transactional data into an interactive business intelligence dashboard that monitors sales performance, uncovers key trends, and supports data-driven decision-making.
I combined PivotTables, PivotCharts, KPI Cards, Slicers, and other interactive filters to provide a comprehensive view of business performance.
This dashboard helps answer the following questions:
- Which product category generates the highest sales?
- Which region performs best?
- How do sales evolve over time?
- Which customer segment contributes the most revenue?
- Which products generate the highest sales?
- How does performance change when filtering by year, category, region, or segment?
The dashboard tracks:
- 💰 Total Sales
- 📈 Total Profit
- 🛒 Total Orders
- 📊 Profit Margin %
Analyzes monthly sales performance and identifies seasonality patterns.
Compares revenue generated across product categories.
Evaluates regional sales performance.
Shows contribution of each customer segment.
Highlights the best-performing products by sales.
Users can dynamically filter the dashboard using:
- Region
- Category
- Segment
- Year
- Sub-Category
The project uses the Sample Superstore Dataset containing approximately:
- 5,009 Orders
- Customer Information
- Product Information
- Sales Data
- Profit Data
- Regional Information
- Order Dates
- Data Cleaning
- Data Validation
- Data Structuring
- Pivot Tables
- Pivot Calculations
- KPI Development
- Business Analysis
- Pivot Charts
- Treemap Charts
- Line Charts
- Bar Charts
- Dashboard Design
- Slicers
- Dynamic Filtering
- Interactive Reporting
- Imported dataset
- Cleaned and validated data
- Created supporting calculations
Built multiple Pivot Tables to analyze:
- Category Performance
- Regional Performance
- Monthly Sales Trends
- Product Performance
- Customer Segments
Created an interactive dashboard featuring:
- KPI Cards
- Dynamic Charts
- Interactive Slicers
- Business Insights
excel-sales-performance-dashboard/
│
├── data/
│ └── Superstore_Sales.csv
│
├── dashboard/
│ └── Excel_Sales_Performance_Dashboard.xlsx
│
├── images/
│ ├── dashboard_overview.png
│ ├── dashboard_filtered.png
│ ├── raw_data_sample.png
│ └── pivot_analysis.png
│
├── README.md
│
└── LICENSE
- Consumer customers generated the highest sales volume.
- Technology was the highest-performing category.
- Sales showed strong growth during peak seasonal periods.
- A small number of products accounted for a significant share of revenue.
- Regional performance varied considerably across markets.
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Slicers
- Dashboard Design Techniques
Data Analyst focused on transforming raw data into clear insights using Python, SQL, Excel, and Power BI.
Feel free to explore my other projects and connect with me.
This project is licensed under the MIT License.