Rockbuster Stealth LLC, formerly a brick-and-mortar video rental company, is looking to expand break into the online movie streaming space in order to keep up with market competition and current movie rental trends. In order to do this successfully, some key observations will need to be considered to fully understand global rental trends and sales. My goal is to make these observations to assist with the creation of a strategic growth plan.Rockbuster Movie Rental Analysis
Project Overview and Goal
Methodologies and Tools
Before starting the analysis, I created an Entity Relationship Diagram and a Data Dictionary. Using SQL queries, I analyzed the data to address key business questions and offer valuable insights and recommendations to the marketing team. To support my analysis, I used Tableau to create visualizations.
Data Exploration and Mapping:
Rockbuster Stealth movie rental data was accessed via PostgreSQL and consisted of 15 separate tables. Consistency checks/cleaning steps were performed within PostgreSQL and both a data dictionary and ERD (entity relationship diagram) were constructed for this project as part of the first phase. 
Entity Relationship Diagram generated for this project. A copy of the Data Dictionary with Primary and Foreign Keys is available in the Github Repo.
Querying:
After mapping the data and ensuring consistency, I used SQL to address a series of business questions from the Rockbuster marketing team. The questions varied in complexity, requiring me to apply subqueries and common table expressions. Though I had some prior coding experience, certain aspects of the SQL syntax required additional focus. With persistence and practice, I mastered these challenges and successfully integrated the query outputs into my analysis.
Example of SQL Queries and Outputs utilizing INNER JOINS and GROUPING as reported in Excel.
Data Visualization:
After successfully answering the business questions using SQL, I focused on conveying my insights to various stakeholders through meaningful and impactful visualizations. Given its many capabilities, Tableau was the ideal tool for this task. I developed a range of visualizations to explore key metrics such as revenue, ratings, geography, and customer spending.
Examples of Visualizations included in the Citibike Dashboard.
Recommendations / Response to Key Business Questions:
-
The countries with the highest customer density are India, China, and the United States. While the largest number of customers reside in these countries, this is not necessarily indicative of the highest profit.
India
China
United States
Japan
Mexico
6. Russian Federation 7. Brazil
8. Phillippines
9. Turkey10. Indonesia -
While the highest sales figures are in the countries with the most Rockbuster customers (India, China, United States), two of the top three cities are in the United States: Aurora and Citrus Heights. In the top 5, other cities include Acua, Mexico, Iwaki, Japan and Ambattur, India.
-
The top 5 spending customers are located in India, China, Japan, Mexico, and the United States, in that order.
-
Average rental duration for all films in the Rockbuster inventory is 4.9 days.
-
Focus marketing efforts to the top 10 countries when launching the streaming site. Encourage top-paying customers to remain loyal to the Rockbuster Stealth brand through various incentives. Invest in more film titles belonging to the top 10 grossing genres (including Foreign films), as well as diversifying the language of Rockbuster film inventory.