Skip to content

Sql queries to help Rockbuster launch its online rental site

Notifications You must be signed in to change notification settings

Tanu-Shree-git/SQL-RockbusterLLC

Repository files navigation

Rockbuster Stealth Analysis

Project Objective

The main objective of this analysis is to aid Rockbuster's shift from a physical movie rental business to an online video rental platform by leveraging data-driven insights. These insights will help shape the company's strategy for 2020 market!

Key Questions

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?

Systems Used

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.

Data Overview

The dataset includes comprehensive information on Rockbuster’s film inventory, customer profiles, and payment transactions.

Visualizations on Tableau Public :

https://public.tableau.com/app/profile/fnu.tanu.shree/viz/RockbusterCustomerswithhighlifetimevalue/Dashboard1 https://public.tableau.com/app/profile/fnu.tanu.shree/viz/Customerlocationandcountaroundtheworld/Sheet1

About

Sql queries to help Rockbuster launch its online rental site

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published