This project is an interactive sales performance dashboard built in Microsoft Excel using the Superstore dataset.
It is designed to support business decision-making by providing a clear view of revenue trends, growth performance, seasonality, and sales distribution across categories and regions.
The dashboard emphasizes analysis, usability, and clarity, reflecting how Excel dashboards are used in real business environments.
The dashboard helps answer key business questions such as:
- How is total sales performance evolving over time?
- Which years show the strongest or weakest growth?
- How consistent are monthly sales patterns across years?
- Which product categories contribute the most to revenue?
- How do different regions perform relative to each other?
- How does performance change when filtering by year, region, or category?
-
Total Sales
Aggregated revenue based on current filters. -
Average Monthly Sales
Measures typical monthly performance and smooths short-term volatility. -
Year-over-Year (YoY) Growth %
Compares sales growth between consecutive years (2014 vs 2013).
All KPIs are fully dynamic and update with slicer selections.
-
Monthly Sales Trend (2011–2014)
Identifies growth patterns and seasonality. -
Annual Sales Trend
Highlights year-level performance changes. -
Seasonality Analysis (Average Monthly Sales)
Shows recurring strong and weak months across years. -
Sales by Category
Compares revenue contribution across product categories. -
Sales by Region
Ranks regional performance for comparative analysis.
The dashboard includes slicers for:
- Year
- Category
- Region
All charts and KPIs are connected to the slicers, allowing users to quickly explore different scenarios and drill into specific segments.
- Microsoft Excel
- Power Query for data preparation
- Pivot Tables and Pivot Charts
- Calculated Fields (Average, YoY Growth)
- Custom number formatting (K, M)
- Slicer connections across multiple pivots
- Dashboard layout and visual hierarchy best practices
No macros, VBA, or external BI tools were used.
- Data cleaned and transformed using Power Query
- Helper columns created for Year and Month analysis
- Consistent data model used across all pivots to ensure slicer integrity
- Business-first layout with KPIs at the top
- Minimal visual clutter
- Consistent scales and formatting
- Clear labeling for non-technical users
- Focus on insights rather than raw tables
The dashboard is intended to be readable by both analysts and business stakeholders.
- Superstore sales dataset
- Time period: 2011–2014
- Covers multiple regions and product categories
- Open the Excel file.
- Use slicers to filter by Year, Category, or Region.
- Review KPIs for high-level performance.
- Use charts to explore trends, comparisons, and seasonality.
This project was built as part of a data analytics portfolio to demonstrate:
- Strong Excel analytics skills
- Practical dashboard design
- Business-oriented data analysis
- Ability to build interactive reports without advanced BI tools
