Rockbuster Rental Sales Analysis

Descriptive Analysis of Rockbuster Rental DVD Sales

Project Overview

Data was provided from Rockbuster, a fictional online movie rental business seeking data insights to guide their upcoming 2020 business strategy.
‍
Stakeholder questions to be answered included:
    - 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 a high lifetime value based?
    - Do sales figures vary between geographic regions?

Tools and Database

The software tools included:
    - PostgreSQL
    - Tableau
‍
The database included:
    - payment table
    - rental table
    - customer table
    - inventory table
    - film table
    - store table
    - staff table and other tables

Project Details

PostgreSQL was used to join tables and efficiently query data to gather information on revenue per country and other business questions. One such question was to find which countries are Rockbuster customers located in. To answer this question, data was customer count and revenue was aggregated over countries and then imported into Tableau. Below is the map of countries with customer count and revenue.

Other business questions were answered and filed out within a spreasheet delivarable with answers to each of the questions asked by the stakeholders. In addition to the spreadsheet, another visualization was created to display what movies contributed the most or the least to revenue. Below is that scatterplot. The key takeway from this visual is that movies with a high rental rate and a low rental duration had a stronger correlation to a higher rental revenue.

Want to get in touch?
Drop me a line!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Rockbuster Rental Sales Analysis

Want to get in touch?Drop me a line!

Want to get in touch?
Drop me a line!