Rockbuster Sleath Online Video Service Launch
Project Overview:
Rockbuster Stealth LLC, a movie rental company with stores worldwide, now has decided to enter the online video rental space using its existing movie licenses to remain competitive with services like Netflix and Amazon Prime.
​
Objective and Scope:
Analyze the current performance and develop a launch strategy for the online video service
Tools:
Postgres SQL
pgAdmin 4- RDMS used
Lucid chart to fabricate ERD
PowerPoint for Presentation
​
My Role:
In this project, I took on the roles of a business intelligence analyst and storyteller. I developed a data dictionary, extracted business insights by retrieving data with SQL queries from relational database. Created a presentation and shared insights and recommendations with the executive team.
​
Techniques and Business Questions
Skills and Techniques:
​
Relational databases
Database querying
Filtering
Cleaning and summarizing data
Joining tables
Subqueries and Common Table Expressions
Insight development
Presentation development
Storytelling
​
​
Key Business questions:
​
Movies with most/least to revenue gain?
Average rental duration for all videos?
Countries Rockbuster customers based in?
Customers with a high lifetime value based?
Sales figures vary by geographic regions?
​
Data Prep and Exploration
​
Loaded the data into PostgreSQL and generated the entity relationship diagram (ERD).
Created a data dictionary (linked below).
Familiarized myself with the data to start formulating answers to the business questions.
Organized, sorted, and filtered the data using various SQL queries.
Conducted queries to identify any dirty data that could affect the analysis; none was found, so no cleaning was necessary.
Developed a data profile with summary statistics.
Aggregating data on PostgreSQL
Top and Bottom Revenue-Generating Movies
High Lifetime Value Customers
Insights Derived from Key Business Questions
​
​
Movies with most/least to revenue gain?
Highest revenue generating title: Telegraph Voyage $215.75
Lowest revenue generating title: Duffel Apocalypse $5.94
​
Average rental duration for all videos?
5 days
​
Countries Rockbuster customers based in?
Rockbuster has a wide range of customers globally across 109 countries and 6 continents
​
Customers with a high lifetime value based?
Turkey, Mexico, Indonesia, China, and the U.S. have high-value customers
​
Sales figures vary by geographic regions?
Sales vary by Geographic region with the highest sales in India
Techniques and Business Questions
Skills and Techniques:
​
Relational databases
Database querying
Filtering
Cleaning and summarizing data
Joining tables
Subqueries and Common Table Expressions
Insight development
Presentation development
Storytelling
​
​
Key Business questions:
​
Movies with most/least to revenue gain?
Average rental duration for all videos?
Countries Rockbuster customers based in?
Customers with a high lifetime value based?
Sales figures vary by geographic regions?
​
Top 10 Countries by Customer Count (using Joins)
Top 5 Customers in the Top 10 Countries (using CTE)
Recommendations
Customers and Sales Revenue
​
Recommend prioritizing the online video rental service launch and marketing budgets in key countries (India, Turkey, Mexico, Indonesia, China, and the U.S) and then expand to other countries.
India also brought in the highest revenue of $6, 034.78 and has highest customer count. Turkey, Mexico, Indonesia, China, and the U.S. have high-value customers.
Genres and Ratings
​
Suggest boosting content in movies of top genres (Sports, Sci-Fi, Animation, Drama, and Comedy) and rating (PG-13) through partnerships, refining the library and limiting films in lower-performing genres (Classics, Children, Travel, Music and Romance) and ratings (G).
​
Average Rental Duration
​
Average rental duration: 5 days. Introduce special discounts or free coupons for rentals exceeding 5 days during the initial 3 months post-launch might attract more customers.