Skip to content

Latest commit

 

History

History
35 lines (27 loc) · 1.48 KB

File metadata and controls

35 lines (27 loc) · 1.48 KB

SQL Analysis for Rockbuster Films

Rockbuster logo

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

Rockbuster logo