Project Information:
- Languages/Tools: SQL
- Project Date: Sep 2023 - Oct 2023
- Github: Click Here
Description:
This project analyzes data for an online sports clothing company to boost revenue. It focuses on pricing, reviews, descriptions, ratings, revenue, and website traffic, using SQL queries on a database with product details, finances, reviews, traffic, and brands.
Results:
Adidas products, characterized by higher prices and significant discounts (around 33.45%), generate substantial revenue, while Nike employs a strategy of lower initial prices and infrequent discounts.
Encouraging customer reviews is crucial, as a strong positive correlation (0.65) between reviews and revenue suggests that increasing feedback can enhance sales performance across the product range.