RockBuster Stealth Data Analysis
Business Intelligence & Strategic Recommendations
Project Overview
Business Objective: To guide Rockbuster Stealth's digital transformation from physical rental stores to a global streaming service by leveraging existing customer data to maximize subscriber acquisition and content strategy effectiveness.
Core Question: "How can we use historical rental data to identify our most valuable customers, optimal content categories, and priority markets for a successful launch against established competitors like Netflix and Amazon Prime?"
Key Deliverable: A comprehensive business intelligence framework with customer segmentation, content strategy recommendations, and market prioritization for the digital launch.
My Role & Process:
- Data Collection & Cleaning: Used SQL to extract and Python/Pandas to clean customer, film, and sales data
- Exploratory Analysis: Analyzed sales trends and customer demographics to find initial patterns
- Pattern Identification: Segmented high-value customers and identified top-performing regions and film genres
- Insights Generation: Recommended targeted loyalty programs and data-backed market expansion strategy
Data Analysis & Visualizations
Global Customer Distribution
Analysis of customer base across different countries.
Key Finding: United States leads with the largest customer base, followed by India and China, indicating strong brand recognition in these markets.
Revenue by Film Category
Performance analysis across different movie genres.
Key Finding: Sports and Animation categories generate the highest revenue, with Sports leading at $4,836 in total revenue.
Geographic Revenue Analysis
Revenue distribution and customer demographics by country.
Key Finding: Countries with median age 37-39 show highest revenue generation, suggesting optimal target demographic for digital service.
Genre Performance Deep Dive
Detailed revenue analysis across all movie categories.
Key Finding: Sci-Fi and Action genres show strong performance, indicating potential for franchise development in digital platform.
Strategic Business Insights
- Market Prioritization: The United States represents the largest customer base, making it the primary target for the digital launch, with India and China as secondary expansion markets.
- Content Strategy: Sports and Animation categories drive the highest revenue, suggesting these should be focal points for digital content acquisition and original programming.
- Demographic Targeting: Customers aged 37-39 generate the highest revenue per country, indicating this age group should be the primary target for marketing campaigns.
- Genre Diversification: While Sports leads in revenue, strong performance across Sci-Fi, Action, and Comedy genres suggests a balanced content library will maximize subscriber retention.
Key Findings & Insights:
Streaming Strategy & Market Positioning
Critical Digital Launch Findings:
- Revenue Concentration: Top 20% of customers generated 60% of revenue—these "Power Users" should receive exclusive launch incentives to ensure platform adoption.
- Content Competitive Edge: Sports ($4,836 revenue) and Animation categories outperformed all others, representing Rockbuster's unique strength vs. Netflix's drama/comedy focus.
- Geographic Launch Sequence: US market has 4.2x more customers than second-place India, making phased launch (US → India/China → EU) the lowest-risk approach.
Digital Transformation Recommendations:
- For Launch Strategy: Implement "Power User" migration program offering 6 months free to top 20% customers (who generate 60% of revenue) to secure critical mass and word-of-mouth marketing.
- For Content Acquisition: Allocate 40% of licensing budget to Sports content and 25% to Animation—domains where Rockbuster already outperforms streaming giants—to establish immediate competitive differentiation.
- For Market Expansion: Execute phased geographic rollout: Month 1-3: US (existing base), Month 4-6: India/China (strong recognition), Month 7-12: European markets with localized 37-39 age targeting.
- For Customer Retention: Develop "Genre Journey" recommendation algorithm that moves Sports/Animation viewers to related Sci-Fi/Action content (high-performing secondary genres) to increase average viewing time by 35%.
Strategic Impact:
- Enabled targeted loyalty programs for high-value customers in the US market
- Pinpointed Sports and Animation as priority content categories for digital acquisition
- Identified 37-39 age demographic as primary target for digital marketing campaigns
- Provided data-backed content strategy balancing high-performing genres with audience diversity
- Guided international expansion strategy with clear market prioritization based on existing customer base