e_commerce_transaction

E-Commerce Transaction and Customer Segmentation

An Assignment for Python Model covers Data Cleaning & Preparation, EDA and Clustering Analysis

Situation/ Case Background

Gustavo just started an e-commerce startup based in Portugal that recently open an online website to sell their product. Fortunately, Gustavo is launching their website when the covid-19 hits and making them grow faster than ever. However, Gustavo is still not using targeted marketing which hurts their marketing budget as only a fraction of their user comes back to their website. Gustavo needs your help to increase their marketing conversion rate by doing more targeted marketing using customer segmentation so that it will not hurt their budget.

The data can be accessed here:

1. orders_dataset
2. customers_dataset
3. order_payments_dataset

Intermediate Tasks:

1. Cleaning the data consist of:

• Removing irrelevant value
• Handling missing value
• Removing duplicate values
• Handling Outliers
• Converting data types
• Combine the dataset into single dataset

2. EDA consist of:

• Evaluate descriptive statistics and provide the insight
• Visualize the order dataset and check if there is some pattern of the time-series data
  • Number of orders per month
  • Daily orders trend (which day of week is the busiest)
  • Percentage of orders per payment type

Advanced Assignment

3. Create user segmentation using cluster analysis. Based on your analysis and interpretation, please also give your recommendation for the business.

Customer Segmentation Result

Interactive Slide Deck