Rockbuster Stealth LLC Video Streaming Analysis
Provide insights that inform the strategy for launching Rockbuster Stealth’s video streaming platform in 2020 by analyzing customer data, rental patterns, and market performance using PostgreSQL, DbVisualizer, Excel and Tableau.
Data:
Entity-Relationship Diagram (ERD)
Techniques Applied:
Relational Databases, SQL, Database querying, Filtering, Cleaning and summarizing, Joining tables, Subqueries, Common Table Expressions (CTE)
Overview:
Rockbuster Stealth LLC is an international retail movie rental service currently operating with 2 stores and a website platform. Executives seek insights to develop a strategy for launching the company’s inaugural streaming platform. Stakeholders are most interested in the performance of different movies, average rental duration, customer location, and variance in sales across regions.
1. Data Collection and Preprocessing
Data from Rockbuster’s relational database included customer demographics, rentals, and film performance.
SQL queries and CTEs were used to clean and filter data for accurate analysis.
2. Key Visuals and Insights
Customer Distribution by Country
Customers span 109 countries, with India, China, the U.S., Japan, and Mexico leading in customer volume and revenue. Asia generates 50.1% of the overall revenue, highlighting its importance for expansion.Revenue by Movie Rating
PG-13 movies dominate revenue, indicating strong appeal across broad age groups, followed by R-rated films.Top Movie Genres by Rental Volume
Action, Drama, and Comedy are the most rented genres, with Action as the top performer. These genres should form the foundation of Rockbuster’s content library.
3. Key Findings and Strategic Recommendations
Expand Presence in High-Value Markets:
Given Asia’s contribution to revenue, Rockbuster should allocate 30% of its marketing budget to India and China, focusing on targeted campaigns that emphasize local content preferences, particularly action and drama genres. Additionally, Rockbuster should partner with regional distributors to provide more localized content.Leverage Content Preferences:
Since PG-13 and Action movies generate the highest rentals, prioritize licensing agreements with production studios to offer exclusive content in these categories. A 15% boost in marketing spend for family-oriented, PG-13 films is recommended for regions like the U.S. and Europe.Customer Retention through Loyalty Programs:
Launch a tiered loyalty program to reward repeat customers, with discounts or early access to new releases. Tailor this program regionally, offering higher rewards in Asia and North America to capitalize on high-volume markets.Enhance Data-Driven Decision-Making:
Implement real-time analytics to track user engagement on the platform, enabling Rockbuster to adjust content offerings dynamically based on region-specific trends. For example, if Comedy gains traction in Europe, shift promotional efforts accordingly.Localized and Niche Marketing:
Invest in localized marketing strategies, such as launching region-specific ads in India and China, and consider partnerships with regional influencers to drive brand awareness. In the U.S., leverage streaming trends like exclusive early releases to attract attention.
These recommendations provide a clear action plan to drive global growth, optimize content strategy, and boost customer retention, ensuring Rockbuster Stealth’s successful launch in an increasingly competitive streaming market.