top of page

Rockbuster Stealth LLC

Rockbuster Stealth LLC, a company with a global network of physical movie rental stores, is launching an online video rental service.

Objective

This project uses data analytics to guide Rockbuster's transition to an online service model in 2020. The insights will inform key decisions and strategic planning.

Data

  • Rockbuster Stealth LLC data

  • Project brief

​Skills

  • Database querying

  • Filtering, cleaning, and summarizing data

  • Joining tables

  • Performing subqueries

  • Using CTEs (common table expressions)

  • Creating a data dictionary

  • Creating an ERD (entity relationship diagram)

Tools

  • Microsoft Excel

  • Microsoft Word

  • Microsoft PowerPoint

  • PostgreSQL

  • DbVisualizer

  • Tableau

Rockbuster customers around the world

RB 1.png

Regions with the most significant movie rental income include Asia, North America, and South America. India stands out as the country with the largest customer base and highest revenue generation.

Descriptive Analysis

Revenue performance of the top 10 movies. "Telegraph Voyage" is the top-grossing movie, with a revenue of $215.75.

RB2.png
RB3.png

The top 10 countries with the most customers are also the countries with the most sales. They make up 52.59% of all total customers and 51.92% of total global revenue.

Conclusions & Recommendations

​Customer Experience

  • Prioritize online customer experience

  • Invest in a user friendly intutive online platform that offer a seamless browsing and rental experience.

Value added Services

  • Offer subscription packages with tiered pricing and exclusive benefits.

  • Consider introducing features like early access to new releases, ad-free streaming, and personalized movie queues.

Market Trends

  • Continuously monitor market trends, competitor activity, and customer feedback.

  • Be prepared to adapt the online service model based on evolving consumer preferences and technological advancements.

Strong online presence

  • Establish a strong online presence through social media, content marketing, and influencer collaborations.

  • Focus on building a loyal customer base through loyalty programs and exclusive offers

bottom of page