A demo project using PostgreSQL and pgAdmin to clean, document, query, and analyze data from a fictitious movie rental company, Rockbuster Stealth LLC.
Rockbuster Stealth LLC, a fictional movie rental company with a global presence, is adapting to the competitive landscape posed by streaming services like Netflix and Amazon Prime. To stay relevant, the management is strategically transitioning from physical stores to an online video rental platform, leveraging their existing movie licenses.
As part of this initiative, I, a data analyst hired by Rockbuster Stealth's business intelligence (BI) department, am tasked with providing data-driven insights to inform the launch strategy for the new online service.
The Rockbuster Stealth Management board has posed critical business questions, seeking data-driven answers for their 2020 company strategy. The key questions include:
- Identification of movies contributing the most/least to revenue gain.
- Determination of the average rental duration for all videos.
- Analysis of the countries where Rockbuster customers are based.
- Identification of customer segments with a high lifetime value.
- Evaluation of sales figures variation across geographic regions.
The dataset for this project was supplied by Rockbuster and encompasses information about the company's film inventory, customers, payments, and more. To facilitate the analysis, the data was loaded into a PostgreSQL database.
The database comprises the following tables:
- Payment
- Rental
- Store
- Film_Actor
- Inventory
- Film_Category
- Customer
- Staff
- Actor
- Film
- Category
- Address
- Language
- City
- Country
This structured database forms the foundation for answering the posed business questions and guiding Rockbuster Stealth's strategic decisions for the online video rental platform launch.
Language: PostgreSQL
Software: pgAdmin, DbVisualizer, Excel, Tableau
Deck created in Tableau