Data Analysis for Rockbuster’s Streaming Launch

Rockbuster Stealth

Case Study: Using SQL and Tableau to answer business questions for a streaming launch

Data analysis project by Stephen Helvig

Q3/August

2025

3

2

1

Rockbuster is pivoting to online streaming to stay competitive�

Data insights guide catalog strategy, market focus, and customer growth

Why we’re here

Rockbuster Stealth

Q3 / August

2025

All ratings and categories perform proportionally well → catalog depth drives revenue

India & China dominate due to large customer bases, not higher per-customer spend

With high-value customers worldwide, streaming is essential to engage them effectively

Quick takeaways

What is the average rental behavior?

Where are Rockbuster customers located?

Which customers deliver the highest lifetime value?

Do sales vary across regions?

Which films, categories, and ratings drive revenue?

Rockbuster Stealth

Q3 / August

2025

Business Objectives & Questions

Data Overview

2025

Rockbuster Stealth

Q3 / August

Film Dataset

Customer Dataset

Business Relevance

958 films in catalog

599 customers across 108 countries

Accounts created in 2006

Majority tied to store 1, most marked active

Top markets by customer count: India, China, US, Japan, Mexico

Avg. rent duration: ~5 days

Avg. rental rate: $2.98

Avg. film length: 115 minutes

Avg. replacement cost: ~$20

Most common rating: PG-13

Most common release year: 2006

• Catalog and customer base are already global, reinforcing streaming viability

→ Revenue declines gradually. No single blockbuster dominates

→ Top films earn 3–4x the median, but most titles contribute steadily

→ Insight: A broad catalog is key. Variety ensures stable revenue, not just a few hits

Top Performing Films

Revenue by Rating

PG-13 leads in total revenue (~23%)�

Every rating performs proportionally to its catalog size → more films = more revenue�

Insight: Growth depends on catalog expansion across all ratings, not just PG-13

Revenue & Rentals per Film / Revenue by Category

Sports leads overall, but Sci-Fi, Animation, Drama, and Comedy are close behind�

Revenue and rentals per film are fairly consistent. Music produced the top film while still being a smaller category�

Insight: All categories are fairly efficient. Balanced catalog growth matters more than chasing “winner” genres

Revenue Distribution by Country

India & China together account for ~20% of Rockbuster’s revenue�

Revenue is broadly distributed, with contributions across Asia, the Americas, and Europe

​

Insight: Revenue strength appears tied to population size and market scale, which raises the question of how the customer base aligns

Customers by Country

India (60) and China (53) have the largest customer bases, followed by the US (36), Japan (31), and Mexico (30)�

Customer counts mirror revenue distribution, confirming that scale in population drives both metrics�

Insight: Some mid-sized markets like Japan and Mexico generate strong customer bases relative to size, setting up the question of per-customer value

​

Top 20 LTV Customer Locations

High-value customers are globally dispersed, found in places like Réunion, Belarus, the Netherlands, Brazil, and the US�

Their locations do not always align with the largest markets by revenue or customer base�

Insight: Rockbuster’s most valuable customers can emerge anywhere, showing the need for global retention and personalization strategies

Key Insights

2025

Rockbuster Stealth

Q3 / August

1. Catalog depth drives growth: Revenue scales consistently with film availability across categories and ratings�
2. Content strategy: Niche films can outperform averages, proving the value of variety alongside mainstream genres�
3. Markets & customers: India and China dominate in total revenue and customer base, but mid-sized regions (Japan, Mexico) deliver strong per-customer value�
4. High-value individuals: Top customers are globally scattered, showing retention and personalization should extend beyond large markets

Recommendations / Next Steps

2025

Rockbuster Stealth

Q3 / August

1. Expand catalog breadth
1. Add depth across all ratings and categories, not just top performers
2. Emphasize variety to capture broad customer demand
2. Prioritize content investment
1. Secure additional rights in top-demand genres (Sports, Sci-Fi, Animation, Drama)
2. Maintain niche categories that can produce stand out performers (Music, Documentary)
3. Leverage global reach
1. Streaming removes geographic barriers → scale acquisition across all high-population markets
2. Ensure platform and marketing are accessible in major �global regions (Asia, Americas, Europe)
4. Personalize retention efforts
1. Use viewing history, recommendations, and tailored offers�to keep customers engaged and maximize lifetime value

Thank you

Rockbuster Stealth

Q3 / August

2025

If you have any questions, contact: stephenhelvig@gmail.com