📊 Global E-Commerce Sales Anlaysis (Excel)

An interactive Excel Dashboard built for analyzing global e-commerce sales performance with key business metrics, visualizations, and filters.
This project is ideal for showcasing data analysis, Excel pivot tables, and dashboard design skills.

---

🚀 Features

1. KPI Cards

• No. of Orders – Track total orders placed
• Total Profit & Total Sales – Monitor overall business performance
• Average Discount % – Measure promotional impact
• Average Delivery Days – Assess operational efficiency

2. Interactive Filters

• Slicers for:
  • Month
  • Region
  • Category
  • Payment Method
  • Customer Segment

3. Visual Insights

• Monthly Sales Trend – Line chart with smooth curves & data markers
• Profit by Region – Compare regional performance
• Sales & Profit by Category – Category-wise business contribution
• Profit vs. Discount – Bar chart showing discount impact on profit
• Customer Segment Share – Pie chart of customer segments
• Payment Method Share – Donut chart displaying transaction preferences
• Top 10 Products by Sales – Highlighting best-selling products

---

📸 Dashboard Preview

---

📈 Key Insights from the Dashboard

• 💰 Total Sales: ₹6,66,606.21
• 📈 Total Profit: ₹1,33,862.72
• 📦 No. of Orders: 500
• 💸 Average Discount: 8.13%
• 🚚 Average Delivery Days: 4.13 Days

Business Insights

• 🏆 South Region recorded the highest profit, followed by the East Region.
• 💼 Technology and Furniture categories drive most of the sales and profits.
• 🧑‍💼 Home Office segment accounts for the largest share (42%), showing strong B2C engagement.
• 💳 Cash (27%) and PayPal (24%) are the most preferred payment modes.
• 💡 Products like Laptops, Chairs, and Pens dominate the Top 10 Sales list.
• 📉 Moderate discounts (5–10%) yield higher profits, while higher discounts reduce profit margins.

---

🛠 Tools & Skills Used

• Microsoft Excel
  • Pivot Tables
  • Pivot Charts
  • Slicers & Timelines
  • Conditional Formatting
  • Custom Chart Formatting
  • Data Cleaning & Analysis

---

📂 Files in this Repository

File Name	Description
Ecommerce_Raw_Data.xlsx	Original dataset used for analysis
Global_Ecommerce_Sales_Analysis.xlsx	Final interactive Excel dashboard
Dashboard_Screenshot.png	Dashboard preview image
README.md	Project documentation

---

🧭 How to Use

1. Download the .xlsx files from this repository.
2. Open Global_Ecommerce_Sales_Analysis.xlsx in Microsoft Excel (2016 or later).
3. Use the slicers to explore sales performance interactively.
4. To rebuild the dashboard, start with Ecommerce_Raw_Data.xlsx and create Pivot Tables and Charts as shown.

---

🎯 Purpose of the Project

This dashboard simulates a real-world business scenario, enabling decision-makers to:

• Identify profitable regions and product categories
• Evaluate discount strategies and their profit impact
• Understand customer preferences and payment behavior
• Improve operational and delivery performance

---

⭐ Feedback

If you found this project insightful, don’t forget to ⭐ the repository and connect with me on LinkedIn!

---