top of page
Outdoor Movie

ROCKBUSTER STEALTH

tableau.jpg

In this project I used  PostgresSQL to analyze data and answer questions about customer’s spending and rental habits.

DATA

Data loaded into RDMS and queried using PostgresSQL Files included customer data, inventory data, and sales data Rockbuster Stealth Data

​

Analytical Techniques

  • Relational Databases

  • Database Querying

  • Database Filtering Cleaning and Summarizing

  • Joining Tables Subqueries

  • Common Table Expressions

top 5 genres by rev.png
avg number of days rented.png

  • Data cleaned, using CRUD method

  • Data was further manipulated using SQL commands to filter, group and summarized to determine key insights

  • Board was interested in which counties Rockbuster customers are based in and where the highest spending countries

top 5 customers by country.png
revenue by country.png

Data was manipulated by applying:

  • CTE – common table expressions

  •  Subqueries

  • JOINs

  • Insights were extracted, and the aim was to determine where should Rockbuster focus its efforts and why

  • Trends and correlations emerged based on performing the more advanced commands

Results

  • Travel has the longest rental duration at almost 5.5 days

  • India: Has the most customers worldwide with 60 customers and revenue at $6,035

  • China: Has the second highest customers with 53 customers and revenue at $5,251

  • USA: Has the third highest customers with 36 customers and revenue at $3,685

Recommendations

  • With the analysis, we found out that the genre Travel has the longest rental duration. This means people like to watch these movies for a longer time span. It would be recommended to do more advertising with this genre and expanding home many movies in the Travel genre that are available to customers.

  • The analysis showed the India, China, and the United States had the highest number of customers and the highest revenue. More funds should be allocated to these countries for advertising as they have the biggest revenue and number of customers.

  • Having a reward system in place for the top 5 customers worldwide. If it is quarterly or yearly to give them a little something extra for being so loyal to the company. This may start a competition with the customers.

bottom of page