Rockbuster Business Analysis
SQL Database Querying
Project Overview
-
Rockbuster Stealth LLC is launching an online video rental service using its existing movie licenses to stay competitive with streaming services.
To drive 2020 strategy, Rockbuster management needs to better understand it's user and film data. Specifically:
Which movies contributed the most / least to revenue gain?
What was the average rental duration for all videos?
Where are high LTV customers based?
Do sales figures vary between geographic regions?
-
Rockbuster Strealth LLC database
Includes data on film inventory, customers, payments, rentals, staff, geographic location
See data dictionary
-
Data storage & structure
Database querying in SQL
SQL Joins
SQL Subqueries
SQL Common table expressions
Key Metrics
1,000
Total number of films
India(60)
Country with most customers
115 min
Average film runtime
$2.98
Average film rental price
182
Number of rentals in 2006
$61,312
Total rental revenue
20
Number of genres
5 days
Average rental duration
Analysis
What are the top geos?
What are the top genres?
Films in the Sports category have driven the most revenue at $4,892 while Thriller has driven the least $48.
The average revenue driven across all film categories is $3,607.
Recommendations
Focus marketing and investment into top revenue-driving films and categories like Sports, Sci-Fi and Animation.
Cater to countries with largest customer concentrations by licensing more films with most popular languages & categories in those regions.
Build loyalty by rewarding customers with high LTV or high sales with perks like free rentals and no late fees.
Deploy incentivized surveys to solicit customer feedback on rental price, duration and customer experience. Use results to test and iterate on business strategy.
