Rockbuster Movie Rental Analysis

Project Overview

• Objective: Rockbuster Stealth is a fictional movie rental company that wants to close its stores and move into online rentals. They want to stay competitive in this space and want to learn from their database of customers to help guide their transition.
• Agenda: Provide a detailed analysis of Rockbuster’s customer base that can help inform their shift into the online streaming arena, and provide information on:
  • Top performing countries
  • Most popular movies and genres
  • Top customers
  • Marketing recommendations
• Tools, skills and methodologies:
  • PostgreSQL was utilized to perform various joins, subqueries, and common table expressions (CTEs) to derive key information.
  • Created informative visualizations in Tableau to help communicate important findings.

Setting up the Database and Creating a Data Dictionary

• With the data itself being fictional, there are no official data sources to cite.
• The first step in this project involved the creation of a database environment in PostgreSQL, and then loading the data to begin analysis.
• Next, before EDA, I also created an entity relationship diagram and a data dictionary, which I could use as a reference for visualizing the connections between relevant tables, and cataloging data types, and assigning primary and foreign keys.

Exploratory Data Analysis

• Before utilizing more complex queries to discern movie rental usage and demographic profiling, I performed aggregations in SQL to find common film traits, including:
  • Average film length
  • Average rental duration
  • Average rental rates
  • Most common film rating

Using SQL Joins and Common Table Expressions

• With Rockbuster requiring information on their top-performing countries, cities and customers, I joined multiple tables of data to derive this information.
• Next, I used both subqueries and CTEs to find more information about the customers with the highest usage, and their locations, and compared each strategy to determine which was more efficient in terms of cost.

Conclusion and Next Steps

• Beyond the customers and the countries they reside in, I uncovered other important information to inform Rockbuster’s shift into the online arena.
• These areas included:
  • The most popular genres- overall, and by country.
  • The most popular languages, and the languages that need more movies in the database.
  • If you are interested in the whole picture, please refer to the files below.