Rockbuster DVD Video Rental
Background
Rockbuster Stealth LLC is 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 is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive.
Key Questions and Objectives
1. Which movies contributes most or least to revenue gain?
2. What was the average rental duration of videos?
3. Which countries are Rockbuster customers mostly located in?
4. Were are customers having highest lifetime values located in?
5. Do sales vary by different geographic regions?
Goal
As a Data Analyst at Rockbuster, I am supposed to address these business questions using SQL and visualizations in Tableau.
Context
This is a project I did as part of a course in data analytics at Career Foundry.
Data Sets
The database used for this project can be found in the following
link.
Data Sets
1) Data Exploration
Extract an entity relationship diagram and create a first draft of a data dictionary.
2) Data Querying
1. Data aggregation
2. Cleaning Data
3. Joins
4. Subqueries
5. Common Table Expressions
6. Views
Example of Queries - Which 10 movies contributed the most to revenue gain? Which is the rating for each movie? Which is the genre for each movie? What is the earning for each movie?
Data Analysis & Visualization
Which movies drives the most revenue?
The top 3 revenue generating moves are Telegraph Voyage, Zorro Arc, and Wife Turn.Among top 10 movies: Drama, Comedy, and music constitutes a majority of top 10 movies.Movies rated G and NC-17 constitutes a majority of top 10 movies
Where are most of customers located?
The three largest customer bases of customers are located in India, China, and United States. Countries with most customer base are among more populous countries in the world
Final Recommendations
