Rockbuster Stealth LLC is a video rental company that is trying to break into the online video rental service. Their goal is to stay competitive against competitors like Netfilx and Amazon Prime and this project is to use the data to successfully launch the online video service.
- What was the average rental duration for all videos?
- Which movies contributed the most and least to revenue gain?
- Do sales figures vary between geographical regions?
- In which countries are Rockbuster’s customers based?
- Where are customers with a high lifetime value located?
- What movie genres generate the most revenue?
- pgAdmin4: For managing PostgreSQL databases.
- PostgreSQL: Relational database management system (RDBMS) used to store and query Rockbuster's data.
- Tableau Public: Platform for creating and sharing interactive data visualizations.
The dataset includes comprehensive information on Rockbuster’s film inventory, customer profiles, and payment transactions.
- Film Inventory: Details about available movies, genres, and rental durations.
- Customer Information: Data on customer demographics and rental behavior.
- Payments: Records of transactions and revenue details.