Rockbuster stealth llcRockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing competition from streaming services such as Netflix and Amazon Prime, the Rockbuster Stealth management team is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive
Objective: Examine the data of a movie rental company and respond to important business inquiries regarding revenue, customer actions, and regional sales to provide insights to aid their 2020 plan.
Procedures: Relational Databases, Database Querying, Filtering, Cleaning & summarizing, Joining tables, Subqueries, Common table expressions, Query optimization
Tools used: Excel, SQL, Tableau, Powerpoint
Data: Rockbuster Data Set
Which movies contributed the most/least to revenue gain?
What was the average rental duration for all videos?
Which countries are Rockbuster customers based in?
Where are customers with a high lifetime value based?
Do sales figures vary between geographic regions?
KEY QUESTIONS
Extraction of an Entity Relationship Diagram
The top movie genres at Rockbuster are Sports, Sci-Fi, Animation, Drama & Comedy
PG-13 followed by NC-17 rated movies generate the most revenue
Example SQL Coding
RESULTS
Image 1
Displays an inner join showing the count of customers for Rockbuster by country
Image 2
Displays an inner join code to show the sales broken down by movie ratings
Rockbuster’s Customers
Total customers = 599
Total countries represented =108
Top 5 Countries are:
India (60)
China (53)
United States (36)
Japan (31)
Mexico (30)
41 Countries have 1 customer
14 Countries have revenue > $1000
RECOMMENDATIONS
Focus on expanding the movie library, specifically in the top genres that generated the most revenue ( Sports, Sci-Fi, Animation, Drama, Comedy
Focus on marketing in countries that generate the most revenue (India, China & the United States)
Incorporate a reasonable monthly subscription fee to attract customers & discounted yearly fee to gain long-term customers
