Grocery Sales Dashboard

Built by: Solape Olojede
Date: April 2025
Tools Used: Microsoft Excel (Pivot Tables, Slicers, Charts)

---

📊 Project Overview

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.

---

🧩 Key Features

• 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

---

💡 Key Insights

• Top-selling years and most profitable states
• Best-performing product categories
• State-wise profit breakdown for strategic targeting

---

📁 Files Included

• Grocery_Sales_Cleaned.xlsx – Cleaned dataset with Pivot Tables and dashboard
• grocery_dashboard.png – Screenshot of the final Excel dashboard
• README.md – This project summary

---

🔗 Live Portfolio Site

Visit my portfolio to view this and other projects.