Rockbuster Streaming Services
Rockbuster Stealth is a video rental service transitioning from a brick-and-mortar model to an online video rental service competing with Netflix and Amazon Prime. This new service will utilize their existing movie licenses and provide customers with streaming options in a bid to stay competitive.
-
Analyze customer behavior and sales performance
Identify key customer demographics and geographic markets
Leverage data insights to optimize market strategy
-
Relational databases
Database querying
Filtering data
Cleaning and summarizing data
Joining tables
Subqueries
Common Table Expressions
-
Fictionalized data set that contains information about Rockbuster’s film inventory, customers, transactions, and payments.
-
PostGRE SQL
Tableau
Rockbuster Entity Relationship Diagram
Question #1 - What genres generate the most revenue?
Starting a streaming service, it makes sense to start with the genres that are your highest-grossing and build from there. The treemap to the right shows that the sports genre is the highest-grossing, followed by Sci-Fi and animation.
The small sliver beneath the music box is the thriller genre, which constitutes the lowest-grossing genre by a substantial amount.
Question #2 - Where are the top customers located?
In order to create targeted marketing campaigns and get them in the places that will drive the most revenue, it’s important to get an idea for where those customers are located. The column chart below shows the top countries and the total amount paid from each, with India and China leading the rest of the world.
Aside from how much money was spent by each country, I wanted to make sure that the amount spent correlates somewhat with the number of customers from each country, so I decided to overlay both variables on a world map and look for overlap. Surely enough, China and India also contain the most customers. Note: the map below uses data from a filtered “Loyal Customer” subset, which is why the revenue values on the map don’t match the chart above.
Question #3 - What are the top genres in the top countries?
Now that China and India have been identified as the top countries in terms of both customers and rental revenue, Rockbuster wants to know the most popular genre rented in those countries.
Shown right is a table that contains the most rented genre for each of the top ten countries in terms of revenue. This will help tailor Rockbuster’s marketing approach in those countries.
