PROJECT DESCRIPTION
This projects aims to make use of SQL to analyze product data for an online sports retail company. For such purpose, several common techniques in SQL are applied, including aggregation, cleaning, labeling, Common Table Expressions, and correlation to produce recommendations on how the company can maximize revenue. The dataset used contains several columns such as pricing and revenue, ratings, reviews, descriptions, and website traffic. Each column contains observations in various format, such as numeric, string, and timestamp. Those observations.
PROJECT TASK
- Counting missing values
- Nike vs Adidas pricing
- Labeling price ranges
- Average discount by brand
- Correlation between revenue and reviews
- Ratings and reviews by product description length
- Reviews by month and brand
- Footwear product performance
- Clothing product performance