Background:

Rockbuster Stealth LLC is a fictional movie rental company that used to have stores around the world and is planning to launch an online video rental service.

Goal:

The board has asked a series of business questions, and they expect data- driven answers that they can use for their upcoming year’s company strategy.

Key business questions:

  • 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?

Data:

Fictional database containing information about Rockbuster’s film inventory, customers, and payments, among other things.

Tools/Skills:

  • Relational databases

  • Database querying filtering

  • Cleaning and summarizing

  • Joining tables

  • Subqueries

  • Common table expressions

  • SQL

  • Tableau

Findings:

Sports, sci-fi, and animation genres have the highest revenue. Thriller by far has the lowest revenue gain. PG-13 rated movies bring in the most revenue, while G rated movies bring in the least.

Rental durations vary from 0 to 10 days, with the average rental duration being 5 days.

India, China, and the US have the highest revenues, followed by Japan, Mexico, and Brazil.

Recommendations:

  • Movies are allowed to be rented for 3 to 7 days, which is in line with customers’ average rental duration of 5 days.

  • Rockbuster should focus on expanding high revenue categories including sports, sci-fi, and animation genres as well as PG-13 rated movies.

  • Sales figures are positively correlated with customer base, so by focusing on countries with a large customer base, Rockbuster will automatically be focusing on countries with high revenue as well.

  • Rockbuster should consider offering a loyalty program to top spending customers, as customers with a high lifetime value are not necessarily located in countries with a larger customer base or higher revenue.