Video Rental SQL Analysis

1. Project overview

What:
In this scenario-based challenge, the analysis aims to provide data-driven answers to key business questions presented by Rockbuster Stealth Management to inform the 2020 company strategy. The following is based on data extracted via PostgreSQL and visualized in Tableau. Analysis of customer and sales data stored in a SQL database to inform the online transition of a video rental business.

Why:
Rockbuster Stealth operates video rental stores across the globe. The company is interested in an analysis of customer demographics and rental transactions to inform its strategy as it transitions into an online movie streaming platform.

How:
1. Query the data using PostgreSQL
2. Visualize key data insights with Tableau

2. Extracting and visualizing the data

Examining the data

Surfacing relevant insights from the PostgreSQL database included the following:

  • Writing SQL queries
  • Cleaning, grouping and summarizing
  • Joining tables
  • Writing subqueries and common table expressions
  • Draft Technical documentation

    • For more detail, feel free to have a look at the GitHub repository.

    Surfacing key insights:

    Management defined the key questions in this scenario, including:

  • How much do different movie genres and ratings contribute to rental revenue?
  • Where is the company's customer base located, including the top customers?
  • How do sales vary in different regions?

    • Visualizing Insights

    Some of the key insights were then visualized in Tableau (see Tableau Public). In addition, a presentation was prepared for management.

    3. Recommendations

    Some key insights resulting from the analysis:
  • Rockbuster has loyal customers all around the globe, indicating significant universal appeal to drive expansion.
  • While Rockbuster has global appeal, Management may wish to first focus its transition to streaming on its core markets in Asia and the Americas.
  • Rockbuster's customers enjoy its broad movie catalog in terms of ratings and genres, which should be maintained in the future.
  • However, the performance of individual movies should be continuously monitored to shape and expand Rockbuster's library.