Skip to main content
Premium project

Optimizing Online Sports Retail Revenue

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

Start Project
9 Tasks1,500 XP

Loved by learners at thousands of companies


Project Description

Sports clothing is a booming sector! In this notebook, you will use your SQL skills to analyze product data for an online sports retail company. You will work with numeric, string, and timestamp data on pricing and revenue, ratings, reviews, descriptions, and website traffic. You will use techniques such as aggregation, cleaning, labeling, Common Table Expressions, and correlation to produce recommendations on how the company can maximize revenue!

Project Tasks

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

Technologies

SQL SQL

Topics

Data Manipulation
George Boorman Headshot

George Boorman

Core Curriculum Manager, DataCamp

George is a Core Curriculum Manager at DataCamp. He has experience in project management across public health, applied research, and not-for-profit sectors. George is passionate about health technologies and all things data science.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA