Rockbuster Stealth LLC

Introduction

Project Overview

Rockbuster is Stealth LLC is facing stiff competitions from streaming services. The project aims to provide data-driven insights to help Rockbuster Stealth LLC stay competitive in the evolving movie rental industry.

Project Objectives

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

Problem Statement

GameCo’s Executives assumed that sales for the various geographic regions have stayed the same over time. GameCo Needs to understand which types of video games are most popular, identify main competitors, and analyze sales trends across different regions to make informed decisions on game development and marketing strategies.

Movies and Revenue

data chart — Figure shows the top 10 generating revenue movie and bottom 10 revenue generating movie from Rockbuster

Methodology

Skills and Tools

Rockbuster’s film inventory
Customers and payments data.
Relational databases, SQL
Filtering

Subqueries
Common table expressions
Joining tables
Cleaning and summarizing

Statistics

Current Rental Rates and Average Duration

Countries Rockbuster Customers based in

Lifetime Value Customers Locations

chart showing top ten lifetime value customers

Findings and Recommendations

Create reward programs to geographic areas with high generating revenue.
It's crucial to keep a significant stock of movies available at the customer-preferred rate of $0.99 to remain competitive.
Decrease rental rates for low-demand movies.

Data Dictionary Project Repository

Analysis for Rockbuster LLC 2020 Company Strategy