🧾 Executive Retail Strategy Dashboard (Excel)

An interactive Excel dashboard to monitor and analyze retail KPIs like total orders, sales, and profit. Built using Pivot Tables, GETPIVOTDATA, slicers, and charts for dynamic filtering and storytelling.

🔧 Tools Used

• Microsoft Excel (macOS)
• Pivot Tables & Charts
• Slicers (Region, Segment, Category, Order Date, Ship Date)
• Formulas: GETPIVOTDATA, SUMIFS, COUNTA

📊 Features

• KPI Cards: Total Orders, Sales, Profit
• Monthly Sales Trend (Line Chart)
• Top-Selling Products (Bar Chart)
• Sales by Category (Pie Chart)
• Interactive Slicers
• Dual date filters (Order and Ship Date)

📌 Insights

This dashboard enables retail managers to:

• Track performance across time
• Identify top-performing products
• Understand category and segment profitability

📷 Preview

📁 File

• Retail_Strategy_Dashboard_Athharv.xlsx — the complete working file

---

⭐ Feel free to clone, learn from, or improve this!