Rockbuster, a global movie rental company, is transitioning to an online video rental service in response to the growing competition from streaming services like Netflix and Amazon Prime. This project involves collaborating with Rockbuster's Business Intelligence team to strategize the launch of this new online platform.
Our primary goal is to assist Rockbuster in leveraging their existing movie licenses effectively for the online service launch. This involves analyzing a relational database to understand current client dynamics and derive insights that can inform the online strategy.
The project revolves around a comprehensive dataset provided by Rockbuster, which includes details about their current clients and business operations. The dataset is structured as follows:
Fact Tables
- Payment: Records of payments made by customers.
- Rental: Details of movie rentals by customers. Dimension Tables
- Actor: Information about actors featured in the movies.
- Address: Addresses related to customers, staff, and stores.
- Category: Different genres or categories of movies.
- City: Cities related to customers and stores.
- Country: Countries related to customers and stores.
- Customer: Information about customers.
- Film: Details of movies available for rental.
- Film Actor: Association between films and actors.
- Film Category: Association between films and their categories.
- Inventory: Records of movies available in inventory.
- Language: Languages of the films.
- Staff: Information about Rockbuster staff.
- Store: Information about store locations.
To aid in the analysis and presentation of our findings, we created several visualizations using Tableau. These visualizations provide insights into customer behavior, rental trends, and other key aspects of the business. The storyboard of these visualizations can be accessed here: Rockbuster Visuals
- This repository contains SQL scripts used for analyzing the Rockbuster dataset.
- Tableau files for the visualizations are also included.