Rockbuster Stealth Analysis

Project Summary and Objective

Rockbuster Stealth LLC is a fictional movie rental company looking into launching an online video rental service, following the examples of Netflix and Amazon Prime.

This analysis supports the business intelligence (BI) in launching their new strategy with solving questions on video, movie characteristics in the database, customers locations, and regional sales analysis.

Tableau Storyboard available on https://public.tableau.com/app/profile/da77/viz/3_10_Rockbuster_Presentation_DA77/StorybookFINAL

Industry: enterainment, streaming.

Technologies used: SQL, PostgreSQL, Tableau, Excel.

Dataset

The dataset contains information about Rockbuster's film inventory, customers, and payments.

Key Questions

1. Which movies contributed the most/least to revenue gain?
2. What was the average rental duration for all videos?
3. Which countries are Rockbuster customers based in?
4. Where are customers with a high lifetime value based?
5. Do sales figures vary between geographic regions?

Key Analysis Performed

• Extraction of data entity relationship diagram.
• Identify and clean dirty data.
• Querying for ordering, limiting, filtering, grouping data.
• Create summary statistics.
• Joining tables.
• Performing subqueries.
• Common Table Expressions (CTE).
• Visualise findings with Tableau.

Resources

Dataset: http://www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip, accessed December 2025.