ROCKBUSTER STEALTH
Overview
OBJECTIVE
To develop a strategy for transitioning Rockbuster Stealth, a movie rental company, to an online platform by analyzing customer demographics, rental durations, geographic sales variations, and revenue contributions of movies.
TOOLS ​
SKILLS
-
Relational Databases
-
Database Querying
-
Filtering
-
Cleaning and summarizing
-
Joining Tables
-
Subqueries
-
CTEs
DATA
Sourced from CareerFoundry.
Data sets contains data on sales, films, and customers for a fictional movie company.
Analysis
Movie Rental Revenue Across Continents (Map)
I explored how sales revenue varied between the different geographical regions.
Movie Rental Revenue Across Continents (Pie Chart)
KEY INSIGHT: Nearly half of Rockbuster's total revenue and customer base comes from Asia, while the other half is distributed across Europe, North America, South America, and Africa.
Top 5 Genres by Revenue
I also analyzed the top 5 genres by revenue.
KEY INSIGHT: The top 5 genres are Sports, Sci-Fi, Animation, Drama, and Comedy.
Recommendations
-
Allocate a great amount of marketing resources to Asia since half of Rockbuster’s customers are based there and they generate almost half of all revenue.
-
Market more films within the genres that produce the most revenue.
-
For an efficient online transition, I would suggest closing the physical stores that are left and then reallocating those resources toward the online platform.
-
Develop a program that rewards top customers to increase retention.