Amazon Sales Dashboard

This project analyzes Amazon sales data using Excel and Google Sheets to uncover insights about revenue, cancellations, and delivery performance. It highlights KPI tracking, PivotTable analysis, and dashboard design for recruiter‑friendly visualization.

Files in this Repository

• MINI PROJECT DATASET - WEEK 03.xlsx → Raw dataset and dashboard analysis
• Dashboard.png → Dashboard visualization
• XLOOKUP.png → Screenshot showing XLOOKUP usage for customer lookup

Dashboard Preview

XLOOKUP Example

Key Insights

• Total Revenue: $35,258
• Top 3 Performing Regions: North, West, South
• Highest-selling Product: Cookware Set Pro (PROD016)
• Electronics category generated $15,209 in sales
• North region had the highest cancellation rate
• 8% of orders delivered within 2 days

Techniques Used

• PivotTables for regional/category analysis
• XLOOKUP for customer name automation
• KPI cards and dashboards for recruiter-friendly visualization

Reflections

• Most Successful Category: Electronics
• Delivery Recommendation: Investigate North region logistics to reduce cancellations
• Learning Highlight: XLOOKUP simplified analysis by preventing errors and saving time

Learning Highlights

• Practiced KPI card design for recruiter-facing dashboards
• Strengthened storytelling with Excel visualizations
• Built a clean, structured README for portfolio presentation