Built by: Solape Olojede
Date: April 2025
Tools Used: Microsoft Excel (Pivot Tables, Slicers, Charts)
This interactive dashboard analyzes 5 years of grocery sales transaction data across various states and product categories. The goal is to provide visual insights into total sales, profit distribution, and category performance in an intuitive and filterable layout.
- Dynamic Slicers for filtering by:
- Year
- Product Category
- State
- Pivot Table Visualizations:
- Total Sales by Year
- Sales by Product Category
- Profit by State
- Clean, Organized Dashboard Layout for easy analysis
- Slicer Connections applied across all charts for interactive filtering
- Top-selling years and most profitable states
- Best-performing product categories
- State-wise profit breakdown for strategic targeting
Grocery_Sales_Cleaned.xlsx– Cleaned dataset with Pivot Tables and dashboardgrocery_dashboard.png– Screenshot of the final Excel dashboardREADME.md– This project summary
Visit my portfolio to view this and other projects.