SQL

Retention Behaviour of Clothing E-commerce

Background:

The clothing eCommerce management want to continue the analysis by understanding the retention behaviors of the user and how to increase the retention rate.

Analysis Work Path:

• SQL Aggregate Functions
• SQL Date Manipulation
• SQL Joins
• SQL Window Function
• Cohort analysis
• Insights and Recommendations

Project Slide

Check full slide in here: SQL Deck

Bigquery file: Bigquery