This project analyzes Rockbuster Stealth LLC, a global video rental company, using SQL and data analytics to uncover insights into customer behavior, pricing efficiency, and revenue distribution. The analysis forms part of my Data Analytics training (Achievement 3) and demonstrates how SQL can support strategic business decisions.
Key business questions addressed include:
- Where are Rockbuster’s customers and revenues concentrated globally?
- How do rental prices and durations impact revenue?
- Which customer segments and markets offer the greatest growth potential?
- What films and genres contribute most to revenue performance?
- SQL (PostgreSQL) – data extraction, transformation, and analysis
- Excel – supplemental calculations and cross-checks
- Tableau – interactive visualizations and dashboards
- Canva – professional presentation design
- Rockbuster maintains strong customer loyalty, with customers averaging 27 rentals annually.
- $4.99 rentals generated the highest revenue, despite being less frequent. Adjusting the $0.99 tier to $1.99 could drive significant gains.
- Top markets include China, India, Russia, and the U.S., while Brazil and Mexico show emerging potential.
- A handful of high-value customers contribute disproportionately to revenue, highlighting opportunities for loyalty programs.
- Genre analysis revealed that sports, sci-fi, animation, drama, and comedy are the most profitable.
Tableau Links:
- Expand in top markets (China, India, U.S.) and develop localized engagement strategies in Latin America.
- Optimize pricing by testing $1.99 entry-level rentals and bundling promotions at $2.99–$3.99.
- Launch VIP loyalty programs for high-value customers and “lookalike” targeting.
- Focus inventory growth on top genres and refine underperforming titles.
Doctor of Business Administration (DBA) Candidate | Sustainability & Data Analytics | charlottelinstudio@gmail.com