Portfolio

Rockbuster

Objective

Provide insights to the Marketing department with the launch strategy for the new online video service.

Problem

Streaming services are a fierce competitor to the Rockbuster Stealth. To remain competitive, they made the decision to launch an online video rental service, but they need specific information on the customers, movies, and markets they should focus on.

Data

Project Brief
The database used for this project can be found in the following link.

Techniques Applied

Data Cleaning and Summarizing
Relational Databases
Creating a Data Dictionary
Entity Relationship Diagram (ERD)
Filtering Data
Jointing Tables
Subqueries

Tools

Data Exploration and Querying

1. Database Exploration

Extract an entity relationship diagram and create a first draft of a data dictionary.

What are the top 10 cities within the top 10 countries?

2. Data Analysis

TOP 5 HIGHEST SPENDING CUSTOMERS

These 5 customers are Rockbuster’s most loyal customers.
The client who spends the most is Arlene Harvey. She spent a total of $111.76.

WHICH OF ROCKBUSTER’S GENRES ARE MOST PROFITABLE?

Rockbuster’s most profitable film genre is sports.It was the genre that generated the highest income $4,892k for the years 2005- 2006.The lowest earning genre is Thriller with only $135k generated.

Summary

CUSTOMERS

• Most of the Rockbuster’s customers are in India and China, so marketing efforts and target points should be focused towards these regions.

GENRES

• Revenue by genre shows that sports, sci-fi and animation films have larger shares of company revenue.
• This information can be used in Rockbuster's selection report of movie titles to offer on its new online service.

MOVIES

• Rockbuster customers have a preference for movies like Telegraph Voyage and Zorro Ark, which would be indicative of investing more in this type or genre of film, either in a more personalized type of marketing and promotions.

Recommendations

Most of the Rockbuster’s customers are in India and China, so marketing efforts and target points should be focused towards these regions. Revenue by genre shows that sports, sci-fi and animation films have larger shares of company revenue. This information can be used in Rockbuster’s selection report of movie titles to offer on its new online service. Rockbuster customers have a preference for movies like Telegraph Voyage and Zorro Ark, which would be indicative of investing more in this type or genre of film, either in a more personalized type of marketing and promotions