The Look Ecommerce - EDA & Cohort Analysis

TheLook is a fictitious Ecommerce clothing site developed by Looker team. The dataset contains information about customers, products, orders, logistics, web events and digital marketing campaigns. The contents of this dataset are synthetic, and are provided to industry practitioners for the purposes of product discovery, testing and evaluation.

Problem Statement:

1. Create a query to get the total users who completed the order and total orders per month.
2. Create a query to get average order value and total number of unique users, grouped by month.
3. Find the first and last name of users from the youngest and oldest age of each gender.
4. Get the top 5 most profitable product and its profit detail breakdown by month.
5. Create a query to get Month to Date of total revenue in each product categories of past 3 months.
6. Find monthly growth of TPO (# of completed orders) and TPV (# of revenue) in percentage breakdown by product categories, ordered by time descendingly.
7. Create monthly retention cohorts (the groups, or cohorts, can be defined based upon the date that a user purchased a product) and then how many of them (%) coming back for the following 3 months.

For more detailed info please visit my project slide here or github here.