📊 Amazon Sales Performance Dashboard (Excel)
Business Intelligence Case Study | Pivot Tables & Dashboards
📌 Project Summary
This interactive Excel dashboard analyzes Amazon sales performance to identify:
Revenue trends by time and category
Top-selling products
Geographic sales patterns
Fulfillment performance & order cancellation behavior
📈 Key Insights
📦 Total Orders: 100K+
⚠ Cancellation Rate: 14.2%
🏆 Top Category: Set
🥇 High Revenue States: Maharashtra, Karnataka
🚚 Fulfillment: FBA drives higher revenue than Merchant
📊 Dashboard Preview Sales Trend & KPIs
Top Products & State Sales
🛠 Tools Used
Microsoft Excel
Pivot Tables
KPI Metrics
Charts & Slicers
Dashboard Design
📄 How to Use
Open the Excel file in files/amazon-sales-dashboard.xlsx
If prompted, enable editing
Refresh pivot tables (optional)
Use slicers to filter by Date, Category, or Fulfillment Type
📂 Repository Structure amazon-sales-excel-dashboard/ │ ├── README.md ├── files/ └── amazon-sales-dashboard.xlsx └── dashboard-preview.png
💡 Business Impact
This dashboard enables leadership to:
Monitor category performance
Identify high-cancellation channels
Optimize fulfillment strategy
Target high-performing geographic markets