SQL Analysis for Rockbuster Films

Descriptive analysis based on five business questions posed by executives of a fictitious film company called Rockbuster.

Project Brief

Introduction

Rockbuster Stealth LLC i s 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 i s planning to use i ts existing movie l icenses to launch an online video rental service i n order to stay competitive.

Key Questions

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 l ike to answer:

1. Which movies contributed the most/least to revenue gain?
2. What was the average rental duration for all videos?
3. Which countries are Rockbuster customers based in?
4. Where are customers with a high lifetime value based?
5. Do sales figures vary between geographic regions?

Dataset

Fictitious dataset for Rockbuster films

Deliverables

Queries

Data dictionary

Presentation - Answer to business question 5