A PowerPoint presentation with the full analysis is available here
The full Data Dictionary for this project can be found here
The interactive presentation on Tableau is available here
Rockbuster Stealth LLC is a fictional movie rental company that used to have locations all over the world. To remain competitive, the management team intends to use its existing movie licenses to launch an online video rental service.
The goal of this project is to assist Rockbuster Stealth's business intelligence department in launching a strategy for the new online video service.
The open source dataset can be downloaded here. It includes data about Rockbuster's film inventory, customers, and payments, among other things.
First and foremost, I created the ERD to quickly see what information each table holds and decide which table(s) to query to answer specific questions.
After that, I created a Data Dictionary. Creating it is critical for comprehending the data before delving into it. Moreover, it provides a fast reference to the data type of each variable and its relation to other database tables.
One of the questions raised by Rockbuster's management team was which countries its clients lived in and how sales figures differed across different geographic regions. As we can see from the below query, the most profitable countries for Rockbuster are, in order, India, China, the United States, Japan, and Mexico.
Another significant question was the location of high-value clients. Below is a list of the 5 most profitable Rockbuster customers, including their country, city of residence, and total amount spent.
The management team at Rockbuster also inquired about the most rented movie genres and the most profitable movies. The genres are listed on the below visualization in alphabetical order. As we can see, Animation, Sports and Action movies are most frequently released, while Horror, Travel and Music are the least frequently rented. The films that contributed the most to revenue increases are also presented in the below graphic, in order of revenue.
Rockbuster has 599 customers in 109 countries. It's a fantastic opportunity to launch an online video rental service worldwide. I would advise Rockbuster’s executives to prioritize the top five countries in terms of client numbers and revenue (which are respectively India, China, The United States, Japan, and Mexico) when allocating the funds in order to maximize their earnings.
Given that the top customers live all over the globe, I would suggest adding movies to the database in languages other than English.
In my opinion, it is important to take genre popularity into consideration when making marketing decisions, therefore it would be appropriate to propose more Sports, Animation and Action titles.
