Rockbuster Stealth: Cracked & Queried

Background

Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services such as Netflix and Amazon Prime, 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.

Key Questions and Objectives

The Rockbuster Stealth Management Board has asked a series of business questions and they expect data-driven answers that they can use for their 2020 company strategy. Here are the main questions they’d like to answer:

a. Which movies contributed the most/least to revenue gain?

b. What was the average rental duration for all videos?

c. Which countries are Rockbuster customers based in?

d. Where are customers with a high lifetime value based?

e. Do sales figures vary between geographic regions?

Data Set

Client provided Rockbuster's film inventory, customer information and payments.

Tools Used

a) PostGreSql

b) DbVisualizer

c) Tableau

Coding Queries

a) Performing Subqueries

b) Joining Tables

c) Common Tables Expressions

Tableau Visualization