Rockbuster Revenue Analysis
Background
RockbusterStealth LLC is a movie rental company that is planning to use its existing movie licenses to launch an online movie rental service.
Objective
Provide insights on high grossing regions, customers, and movies that will help lead strategy in launching the new online movie rental service.
Dataset
Rockbuster’s relational database consists of 15 tables containing data on film inventory, stores, customers, and rentals. The data was obtained from W3Schools.
Analysis Skills
Relational Databases, SQL, Database Querying, Filtering, Cleaning and Summarizing, Joining Tables, Subqueries, Common Table Expressions