Introduction

TheLook is a fictional eCommerce clothing website created by the Looker team.

Below is a database that includes comprehensive details such as orders and users from the platform. Although the database contains a total of 7 tables, we will focus on the following 4 tables:

• orders: Information about all customer orders.
• order_items: Detailed descriptions of items purchased for each order ID.
• products: Detailed descriptions of items sold on TheLook.
• users: Detailed descriptions of all customers.

Sources

Data Sources:

https://www.kaggle.com/datasets/mustafakeser4/looker-ecommerce-bigquery-dataset

or

https://console.cloud.google.com/marketplace/product/bigquery-public-data/thelook-ecommerce?q=search&referrer=search&project=sincere-torch-350709

Code Sources:

https://github.com/HoangNguyen5897/eCommerce

The dataset was last updated in January 2024, however latest data only goes up to mid-January 2024. In this project, I will use the data in 2023 for different analysis.

Business requirements

1. Exploratory Analysis

• Number of Customers and Completed Orders ach month
• Average Order Value (AOV) and Monthly Active Customers
• Customer Segmentation by Age and Genders