Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services such as Netflix and Amazon Prime, Rockbuster Stealth is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive.
This project is a case study in which SQL was used to analyze Rockbuster’s business data and answer strategic questions that could guide the company’s move into online streaming.
The Rockbuster Stealth Management Board posed a series of business questions and expected data-driven insights. The main questions explored in this project include:
- 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?
The analysis is based on the Rockbuster data set, which contains information about film inventory, customers, payments, and more.
Note: Due to file size limitations, the data set is not included in this repository.
You can download it here: Rockbuster Data Set (dvdrental.zip)
- A3_Data_Project_Brief.pdf → Project overview and objectives
- Data_Dictionary_&_ERD.pdf → Data dictionary and entity relationship diagram (ERD)
Contains all SQL scripts used for analysis.
- SQL_Queries → Individual SQL queries for tasks such as summary stats, missing value checks, top customers by country, etc.
- SQL_Queries_Logic_Explanation → Explanations of SQL concepts (PDFs)
- Rockbuster_Stealth_Presentation.pdf → Final presentation prepared for the Rockbuster management board
This file (project documentation)
- PostgreSQL
- SQL
Data Analysis by Olga Gaffarova