PROJECT DESCRIPTION
Sports clothing is a booming sector! This project will make use of SQLto analyze product data for an online sports retail company. In this case, it will deal with numeric, string, and timestamp data on pricing and revenue, ratings, reviews, descriptions, and website traffic. For the analysis, the project will use techniques such as aggregation, cleaning, labeling, Common Table Expressions, and correlation to produce recommendations on how the company can maximize revenue!
PROJECT DETAIL
- 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