Movie Industry Insights
with SQL & Tableau
Project Background
The Business Intelligence department requires data-driven assistance in planning the launch of Rockbuster’s new online movie rental platform. Several of the other departments also need answers to ad-hoc business questions.
Objective
Use a relational database to provide data-driven answers to business questions to help plan a business strategy for 2020.
Questions
- Which kind of movies contributes the most/least revenue gain?
- What can we say about the basic statistics of the company?
- Where should the marketing budget be focused?
Skills
- Relational Databases
- Database Querying
- Filtering, cleaning, summarizing data
- Joining Tables
- Subqueries
- CTEs
Tools
- SQL
- Excel
- Tableau
What is the basic information about the rental business?
On average, movies are rented for 5 days with a rental rate of 3 Dollars per rent. The average movie length of the offered movies is 115 min. The costs to replace a film vary between 10 and 30 Dollars.
Where are most customers located, and where does the company make the most revenue?
The map and the bar chart clearly show the top countries for the movie rental company. India, China and the United States lead the market. It is also evident that the total revenue and the number of customers in a specific region correlate.
How are the sales for the top 5 genres different in each region?
The top genre in terms of numbers sold and the total revenue is Sports, followed by Animation, Action and Science-Fiction movies. The least popular genres are Horror, Travel and Music.
How are the sales for the top 5 genres different in each region?
Our Top 5 customers reside within countries in our Top 10 of revenue and customer count.
Conclusions & Recommendations
I recommend continuing a large budget share in the top 10 countries to adjust the Movie Company’s marketing strategy. We are already in more than 100 countries, so focusing on the top regions might be helpful. This is evident in that our top customers are in the principal areas regarding revenues. Nevertheless, effort should be put into acquiring new customers because as our customer base grows, so will the income. We should also invest in movies in the top 5, namely Sports, Animation, Action, Sci-Fi and Family.
Check my Tableau Dashboard for this project on Tableau.