The Sales Performance Dashboard is an interactive Excel visualization that compares 2023 vs 2024 sales data across multiple regions and product categories. It highlights year-over-year performance, profitability, and quantity sold — helping identify top-performing products and regions driving business growth.
- Dynamic KPIs & Charts – Tracks key metrics like Sales, Profit, Quantity, and Cost for both years.
- Regional & Product Insights – Visualizes performance by region and product type.
- Interactive Filters – Easily switch between categories using slicers.
- Year-over-Year Trends – Compare monthly revenue trends for 2023 and 2024 side-by-side.
- Clean Visual Design – Dark-themed layout for clarity and executive presentation.
- Microsoft Excel – Pivot tables, charts, and slicers for interactivity
- Data Modeling – Aggregated yearly and quarterly calculations for trend comparison
- Power Query – Data cleaning and transformation
- Visualization Design – Custom dark layout with KPIs, bar charts, and line graphs
Clean, interactive Excel dashboard visualizing sales performance for 2023 vs 2024, including profit margins, quantity sold, and product-wise comparisons.
- Download the Excel file from this repository.
- Open in Microsoft Excel (2016 or later recommended).
- Use slicers and filters to explore different product categories and regional insights.
- 2024 saw a 34% profit increase compared to 2023.
- The South region led in total sales for both years.
- Monitors and Mice were top-performing products in 2024.
- Consistent upward trend in sales across major categories.
Toluwani O. — Data Analyst | Excel, SQL & Tableau
🌐 Portfolio: https://tolusdigitalcorner.com