Data
Careerfoundry provided an Data Set featuring Rockbuster data.
Rockbuster
Objective
Rockbuster Stealth LLC is a movie rental company that wanted to launch an online video rental service in order to stay competitive. analysed the existing data to help with the launch strategy for the new online video services for 2020.
Techniques applied
Data Cleaning and Summarizing, Relational Databases, Creating a Data Dictionary, Entity Relationship Diagram (ERD), Filtering Data, Jointing Tables, Subqueries
Tools
Analysis
Key Questions
Which countries and cities have the highest liftime value?
Results
India and China have the highest count of customers and the highest lifetime value followed by the Phillipines, the United States and Brazil.
The Top 10 cities are: Aurora, Iwaki, Cirtus Heightsm Ambattur, Shanwei, Acua, So Leopoldo, Tianjin, Cianjur and Tebokysary.
Key Questions
Which regions have the highest revenue?
Results
Asia, Europe and North America are the top regions in terms of revenue. The lowest revenue has Ozeania.
Key Questions
What are the top genre by revenue?
Results
The top genre be revenue is sports followed by Sci-Fi, Animation and Drama. Thriller is the bottom genre by revenue.
Further Insights
Recommendations
- Regional Marketing: Focus on advertising in the regions Asia, Europe and North America since theses region have a high revenue.
- Genre-based Marketing: Focus marketing on movies the genres with the highest revenue: Sports, Sci-Fi, Animation!
- Inventory update: Offer movies in other langues than english, e.g. especially Hindi and Mandarin since India and China have the largest customer base.
- Loyalty programm: Implement a loyalty & recommendation scheme to increase customer retention and to attract new customers.