Saltar al contenido principal
InicioSQL

proyecto

Optimizing Online Sports Retail Revenue

Principiante
Updated 12/2023
Analyze product data for an online sports retail company to optimize revenue.
Iniciar Proyecto De Forma Gratuita

Incluido conPremium or Teams

9 Tasks1,500 XP5,523

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.
Group

¿Entrenar a 2 o más personas?

Probar DataCamp for Business

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 HeadshotGeorge Boorman

Curriculum Manager, DataCamp

Ver Más

What do other learners have to say?