About
GameCo wants to use data to inform the development of new games. As such, they are looking for a descriptive analysis of a video game data set to foster a better understanding of how GameCo’s new games might fare in the market.
Data
- Rockbuster’s internal database which includes data on their film inventory, customers, and sales.
Goals
- Provide data driven answers to aid in the development of an marketing online strategy.
Tools
- Relational Databases
- SQL
- Tableau
Data Mining
To start this analysis, I first had to pull the relevant data from the provided database. To do this, I had to write accurate and efficient queries using joins, subqueries, and common table expressions.
Key Questions
Which movies
contributed the
most/least to
revenue gain?
Which countries
are Rockbuster
customers
based in?
Where are
customers with
a high lifetime
value based?
Do sales figures
vary between
geographic
regions?
Analysis
Revenue by Genre
The top five genres for revenue are not the top five for the number of titles. This suggests that there is not a strong correlation between rental revenue and available movies.
Revenue by Rating
The top two ratings for revenue are PG-13 and NC-17. These two ratings also have the highest number of titles available. This suggests there could be a correlation between rating and revenue, however, a deeper investigation may reveal other factors.
Top Locations for Sales
The top 5 countries for both revenue and customers are:
•India
•China
•United States
•Japan
•Mexico
Conclusions
- Focus on high performing regions
- India
- China
- United States
- Japan
- Mexico
- Expand offerings in high performing genres
- Comedy is one of the top 5 genres, but has fewer offerings than the other 4
- Offer loyalty programs to attract and retain customers
Ryan Weber 