Rockbuster Stealth Database Analysis

Rockbuster is a video rental company with plans to launch a digital streaming service.  The Rockbuster Management Board wants help answering key business questions to help the launch strategy.  I used PostgreSQL to analyze the data and provide insights.

Audience

Rockbuster Stealth Management Board

Data

Rockbuster Stealth Database:

Contains tables for payment, customer, rental, inventory, staff, category, rating, etc.

Techniques used for the project:

  • PostgreSQL

  • Cleaning, sorting and filtering data

  • Writing complex SQL queries

  • Merging tables within a database

  • Data visualization and storytelling with Tableau

Key Business Questions:

● Which countries are Rockbuster customers based in?

● Where are customers with a high lifetime value based?

● Do sales figures vary between geographic regions?

● Which movies contributed the most/least to revenue gain?

● What was the average rental duration for all videos?