Rockbuster Stealth LLC

Rockbuster Stealth LLC is a movie rental company with only two stores left. In order for them to continue, they want to expand into the online streaming market, but faces stiff competition from established streaming services such as Netflix and Amazon Prime. I need to tell them how to proceed.

DOWNLOAD FULL PROJECT

Data

Data set contains information about Rockbuster’s film inventory, customers and payments and their locations.
A relationship exists between two tables if a column name is present in both tables.

Skills

Relational databases
SQL
Database querying
Filtering
Cleaning and summarizing
Joining tables
Subqueries
Common table expressions

Project/Tools

Key Analysis

Top grossing countries and most customers

Overall, Rockbuster has 599 customers in 109 countries.
Sales figures vary greatly between geographic regions.
Countries with the most customers are also the highest grossing countries and they are as follow:

India – 60 customers and $6,032.79 spent
China – 53 customers and $5,247.04 spent
USA – 36 customers and $3,685.31 spent
Japan – 31 customers and $3,121.52 spent
Mexico – 30 customers and $2,984.82 spent

Most valued customers across the globe

Surprisingly, a little known island belonging to France, called Reunion, is home to Rockbuster’s most valued customer.
USA, third on the list of highest grossing countries, is home to two of the top 10 all-time best customers.
Brazil, Netherlands and Belarus make up the top five countries with high lifetime valued customers.

Highest grossing genres

Sports was the best performer with $4,892.19 in sales.
Making up the rest of the top five were the following:

Sci-Fi - $4,336.01
Animation - $4,245.31
Drama - $4,118.46
Comedy - $4,002.48

Thriller was by far the worst performing genre with only one movie and 11 sales, totaling $47.89.

Recommendations

Start with the most profitable movies.
Expand the best performing genres, by adding more movies.
Dub films in different languages, suited for the highest grossing countries at a minimum.
Consider rewarding the most valued customers.
Increase marketing budgets in the highest grossing countries.
Stay competitive with rental rates and subscription services.

My Code

CTE. Common Table Expression