Data Description:
Analyzing an E-commerce Customer Behavior and Purchase Dataset with SQL and performing Exploratory Data Analysis (EDA) to derive valuable insights to inform strategic decision-making in e-commerce.
Overview of the dataset:
• There are a total of 49,661 unique customers in the dataset. This count assumes that customers with the same name but different customer IDs are considered as separate individuals.
• There are more male customers than females.
• The majority of customers are around the age of 40.
• Among the four product types, Electronics is the most popular.
Asked Questions:
Explore demographics - Gender & Age I. Trends about Gender
- Gender distribution
- Purchase price distribution by gender
- Total & average price spent by gender and year
- Churn and returns by gender
II. Trends about Age
- Age distribution
- Compare age distribution by gender
- Average price spent by age range
Explore Trends About Products & Sales
- Product sales revenue by age group
- Sales Revenue by Product Category
- Monthly return and churn rate by year
Final Dashboard: