ROCKBUSTER
Online Video Rental Service Analysis
BACKGROUND
Rockbuster is a movie rental company that used to have stores worldwide. Facing stiff competition from streaming services, Rockbuster management team plans to use its existing movie licenses to launch online video rental services to stay competitive.
​
Note: Rockbuster is a fictional company with generated data given.
MOTIVATION
Provide Rockbuster Management’s Board with data-driven answers regardings any ad-hoc business questions from various departments, providing the analysis for the management to prepare in transforming the business into an online video rental service.
DATA
The data is a relational database containing information about Rockbuster’s film inventory, customers, and payment among other things.
​
TOOLS & SKILLS
SQL:
- Relational database
- SQL & database query
- Filtering
- Cleaning & summarizing
- Joins
- CTE
​
Microsoft Powerpoint:
- Creating & presenting analytical findings
​
Tableau:
- Visualization
Online Video Rental Service Analysis
Using various SQL Queries, we managed to determine Rockbuster's ad hoc business questions, such as:
1.000 films licensed are currently active
The shortest film duration is 46 minutes, the most extended film duration is 185 mins, and on average, our film length is 155 minutes.
All of our films are in English.
The rental price varies for films. Our rental rate starts at $0.99 up to $4.99
We have customers present in 108 countries around the world.
Getting To Know Our Customer
With customers based in 108 countries worldwide, Rockbuster generated 52% revenue from the Top 10 Countries on the right table.
FOCUSING ON OUR CUSTOMERS
With over 1.000 active movie licensed and a customer based in 108 countries.We already have a great foundation to launch our streaming platform.
​
Customers with high loyalty are scattered across the world. Implementing a specified reward program for our loyal customer would be a great tool to maintain their loyalty to our product.
​
Asia Pacific Region is the highest region in terms of customer based - this region should be the priorities in our launching phase.
PROJECT'S REFLECTION
Coming Soon
​