Skip to main content
HomeSQL

Project

Optimizing Online Sports Retail Revenue

Beginner
Updated 12/2023
Analyze product data for an online sports retail company to optimize revenue.
Start Project for Free

Included withPremium or Teams

SQLData Manipulation45 minutes9 Tasks1,500 XP5,527

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Project Description

Optimizing Online Sports Retail Revenue

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!

Optimizing Online Sports Retail Revenue

Analyze product data for an online sports retail company to optimize revenue.
Start Project for Free
  • 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

    Join over 16 million learners and start Optimizing Online Sports Retail Revenue today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.