- PostgreSQL
- Tableau
- DbVisualizer
Rockbuster Story
Overview
Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Currently, it is facing stiff competition from streaming services such as Netflix and Amazon Prime.
Objective
Planning to use its existing movie licenses to launch an online video rental service in order to stay competitive.
- Project Scale: One month
- Analysis based on the year: 2020
- Top Sales Regions: Mexico, Philippines, Turkey
- - Which movies contributed the most/least to revenue gain?
- - What was the average rental duration for all videos?
- - Which countries are Rockbuster customers based in?
- - Where are customers with a high lifetime value based?
- - Do sales figures vary between geographic regions?
- Extracting ER diagrams in DBVisualizer
- PostgreSQL RDBMS
- CRUD operations
- Database migration and ETL
- Cleaning, filtering and summarizing data in SQL
- Joining tables
- subqueries and CTE
- Visualizations
- Format: SQL relational Database
- Records: 17 tables
- Information: Rentals, film, customers, payment
-
Data Citation:
Rockbuster dataset
Last update: 02/15/2006
Recommendation
- Rockbuster has 600 customers in 109 countries. It is a great opportunity to grow as an online service. Next step would be to introduce a subscription-based rental program; however, further analysis is required to plan to find the most effective monthly fee to beat the competitors.
- To start the pilot service, we would recommend the top-3 revenue makers, which are the following countries: India, China, and the US.
- We suggest the marketing team to provide promotions within popular countries with highest number of customers; India, China, the United States, Japan, and Mexico.
Challenges and Limitations
Complicated database structure and dependencies which lead to complex SQL queries which are prone to error.
Tableau Story