ROCKBUSTER VIDEO

MOTIVATION

• Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services companies, the Rockbuster Stealth management team is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive.

• With the aim to provide insights for the management team, 1000 rented films from 599 individual customers were analysed and a data dictionary was produced. 

• The dataset was uploaded into a relational database management system (RDBMS), the PostgreSQL, where queries were developed to analyze the data and answer the key business questions raised by the team. 

• Insights were presented in Tableau's Storyboard where you can see below and via Tableau Public. 

QUESTIONS

1. What were the average rental duration, rate, and replacement cost for all videos?

2. Which countries and cities are Rockbuster customers based in?

3. Where are customers with a high lifetime value-based?

4. Do sales figures vary between geographic regions?

VISUALISATIONS

Average film rental duration, rate, and replacement cost.

Top 5 customers in the top 10 cities who have paid the highest total amount to Rockbuster

These are the Top 5 customers who should be rewarded as Rockbuster's most loyal customers. 

Casey Mena from Turkey is the customer with the highest amount paid to Rockbuster.

The Storyboard and visualizations can be accessed via Tableau Public.

RECOMMENDATIONS

• Focus on building a better brand image in India, China, and United States, respectively. 

• Identify opportunities to increase the average rental duration and the average rental rate by customer.

• Produce a marketing strategy in the top 10 cities to increase the numbers of customers where there is already a Rockbuster infrastructure established.