📊 E-Commerce Sales Dashboard (Excel)

🔍 Objective

Analyze sales performance and customer behavior to identify high-revenue opportunities and enable data-driven decision-making through an interactive Excel dashboard.

---

🧰 Tools & Techniques

• Excel
• Pivot Tables & Pivot Charts
• Data Cleaning & Transformation
• Slicers / Combo Box Filters
• KPI Metrics & Conditional Formatting
• Data Modeling for Dashboards

---

📈 Dashboard Highlights

• Dynamic KPI cards linked to combo-box filters
• Trend analysis for monthly revenue growth
• Top products and regional performance ranking
• Customer segmentation insights
• Fully interactive dashboard enabling drill-down and comparative analysis

---

🧠 Dataset & Workflow

Sheet	Description
Sales Data	Raw transactional dataset
Working	Cleaned, structured & transformed data used for KPI calculations and filters
Dashboard	Final interactive KPI dashboard

Data Preparation Steps

• Removed duplicates and handled null values
• Standardized date formats and category fields
• Built lookup tables to support combo-box and slicer-based filtering
• Created calculated metrics:
  • Revenue
  • Quantity Sold
  • Average Order Value (AOV)

---

🔑 Key Insights

• Identified highest revenue-generating product categories and customer groups
• Revealed regional contribution to overall sales performance
• Detected seasonal / monthly sales trends and growth patterns
• Automated reporting via dashboard, reducing manual reporting effort by 40%

---

📁 Repository Contents

📦 E-Commerce_Dashboard_using_Excel
┣ 📂 Dashboard_Screenshots
┃ ┣ DASHBOARD.png
┃ ┣ KPI_CARDS.png
┃ ┣ PRODUCT_CATEGORY_ANALYSIS.png
┃ ┗ CUSTOMER_SEGMENT_PERFORMANCE.png
┣ 📄 PROJECT_1_E-COMMERCE_DASHBOARD_AYUSH_VISHWAKARMA.xlsx
┗ 📄 README.md

Note: Make sure the screenshot filenames above match your actual file names in the Dashboard_Screenshots folder.

---

🚀 Future Enhancements

• Build a Power BI version of the same dashboard
• Add forecast visuals for future sales prediction
• Integrate automation using Excel macros or a SQL-based data pipeline

---

👨‍💻 Author

Ayush Vishwakarma — Data Analyst

• LinkedIn: https://www.linkedin.com/in/ayush-d-vishwakarma
• Portfolio / GitHub: https://github.com/ayush-vkarma