A movie rental company planning to use its existing movie licences to launch an online service. A number of questions have been asked to inform the company’s strategy through data-driven answers
Key Questions
-
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
-
Tableau
Data
-
Historical movie rental revenues
-
Data: (SQL)
Skills
-
Relational databases SQL
-
Database querying & filtering
-
Cleaning & summarising
-
Joining tables
-
Subqueries
Analysis & Insights
Rockbuster’s sales data set was cleaned and analysed in PostgreSQL, using filters, table joins, subqueries & common table expressions.
A data dictionary was created to describe the relationship between variables.
Graphs were created in Tableau to visualise these insights and to draw conclusions.
-
Largest markets are Asia & Pacific, Europe and South / Latin America
-
More deaths in states with higher vulnerable populations (aged 65 and over)
-
Even spread of film rating sales, well balanced for current markets
-
Advantage to having exclusive sports and sci-fi film licences
Recommendations
-
Forward looking, 3-way strategy:
-
Strengthen in best performing markets (top left quadrant)
-
Diversify across weaker performing and most popular genres i.e. Thriller, Children and Horror
-
Diversify into bottom performing regions with a focus on emerging and larger markets i.e. Middle East and North America
​
-
-
Considerations:
-
Is the current film catalogue large enough for growth aspirations?
-
Cultural barriers to entry into new markets
-