Rockbuster Stealth LLC, a fictional movie rental company, seeks to launch an online platform to compete with the likes of Netflix and Amazon Prime.
I performed an analysis using SQL to answer complex business questions that could aid in preparing a launch strategy.
Key Questions
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?
Tools
PostgreSQL: Database querying, filtering, cleaning and summarizing, joining tables, subqueries, common table expressions
Excel: Reporting
Tableau: Visualizing and presenting results
Dataset
Data on Rockbuster’s film inventory, customers, and payments, among other things.
Business understanding: I read through the project brief to understand what was needed and to plan out the steps needed to meet the business goals.
Data understanding: I set up a database environment using PostgreSQL, I then extracted an entity relationship diagram for the dataset and created a data dictionary to inform my querying.
Analysis: I used queries to extract the information I needed
Presentation: I put together an excel report, created visualizations in Tableau and created a storyboard to send to the stakeholders.
The company wanted to know what movies were most popular and least popular.
I used queries to figure out which films brought the most revenue and the least revenue. Knowing this information would help inform the company on what films to advertise on their online platform that would draw the most customers.
Knowing the least profitable films could be useful if there is a limit on how many films can be on the platform.
I located the top 10 cities in terms of customer count and the top 5 customers in those cities in terms of revenue.
This information would help in deciding what locations to prioritize when marketing for the online launch.
It is important to retain these customers. The top 5 customers may be willing to follow the launch and join the platform so incentives could encourage them to do so.
The top 10 films should be displayed in advertisements and on the homepage.
When marketing for the launch, cities, and countries with the highest customer count should be prioritized.
The top 5 customers should be provided with discounts or free trials to encourage them to use the online platform.
All queries used in this analysis can be found in the GitHub Repo linked below.