TheLook is a fictitious e-commerce clothing site developed by the Looker team.
TheLook e-commerce 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 purpose of product discovery, testing and evaluate.
The purpose of this analysis is to understand and answer some business questions as regards the performance of theLook e-commerce marketplace, gain insights and provide some recommendation to increase revenue.
Dataset: theLook E-commerce Data
Data source: BigQuery Public Data
Dataset Structure: TheLook e-commerce database consists of 7 tables (‘distribution_centers’, ‘events’, ‘inventory_items’, ‘order_items’, ‘orders’, ‘products’, ‘users’) but in this analysis, we would only be working with the following tables:
- Order_items
- Orders
- Products
- Users