📊 E-Commerce Sales Analysis Dashboard

🎯 Objective

To analyze customer behavior on an e-commerce website based on different factors such as age, gender, income, engagement, and product preferences.

📁 Dataset

• Source: Kaggle
• Rows: 1,000
• Columns: 15

🛠️ Tools & Techniques

• Microsoft Excel
  • Data Cleaning & Formatting
  • Pivot Tables
  • Charts & Graphs
  • Conditional Formatting
  • Interactive Slicers
  • Dashboard Layout Design

📈 Key Performance Indicators (KPIs)

• 💰 Total Sales
• 📦 Average Price of Item
• 👥 Total Customers

📊 Dashboard Features

• Visualized relationships such as:
• ⏱️ Time Spent vs Age Group
• 📄 Time Spent vs Pages Viewed
• 🌍 Location vs Total Spending
• 📰 Newsletter Subscribers vs Non-Subscribers
• Interactive Slicers for quick filtering
• Clean and modern dashboard layout

💡 Insights

The dashboard helps understand how customer engagement, demographics, and product interests influence overall spending and activity on the platform.

👤 Author

Mohammed Shamsuddin

• Github(https://github.com/Muhammed-Shamsuddin)