Skip to content

Analyze product data for an online sports retail company to optimize revenue.

Notifications You must be signed in to change notification settings

HermawanHermawan/Optimizing-Retail-Revenue-in-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

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

  1. Counting missing values
  2. Nike vs Adidas pricing
  3. Labeling price ranges
  4. Average discount by brand
  5. Correlation between revenue and reviews
  6. Ratings and reviews by product description length
  7. Reviews by month and brand
  8. Footwear product performance
  9. Clothing product performance

Releases

No releases published

Packages

No packages published