Answering business questions for an online video rental company
Objective
Rockbuster Stealth LLC is a movie rental company that used to have stores worldwide. Rockbuster Stealth’s business intelligence (BI) department asked to help with the launch strategy for the new online video service. The BI department helps other departments with data-related queries, from inventory to customer insights.
Data set
The data set contains information about Rockbuster’s film inventory, customers, and payments, among other things.
​
Skills
-
Relational database: PostgreSQL
​
-
SQL
​
-
Database querying using ERD
​
-
Filtering
​
-
Cleaning and summarising the data
​
-
Joining tables
​
-
Subqueries
​
-
Common table expression(CTE)
​
Stakeholders requirements
-
Which movies contributed the most/least to revenue gain?
​
-
What was the average rental duration for all videos?
​
-
Which countries are Rockbuster customers based in?
​
-
Where are customers with a high lifetime value based?
​
-
Do sales figures vary between geographic regions?
Conclusion
Analysis of film data
-
Sports, sci-fi and animation are the top genres that made the highest films sales
-
Travel, Music and Thriller are the least purchased movies
-
The top 3 movies are Telegraph Voyage, Zorro Ark, Wife Turn
-
Most negligible revenue-generated films are Texas Watch, Oklahoma Jumanji, Duffe
​
​
Rockbuster customer base in
-
India, China and US are the top 3 countries
-
Total number 108 countries where Rockbuster customers are present.
​
​
Variation in global sales
-
Maximum sales by country is 6034.78, and minimum sale is 47.85. Average sales from all the countries are 567,00