top of page

Movie Streaming Launch Strategy

Rockbuster Stealth LLC, a global movie rental company, is adapting to the evolving market by countering competition from streaming giants like Netflix and Amazon Prime. The management team aims to leverage their extensive movie  licenses  by  initiating  an  online  video  rental  service  to  ensure competitiveness.

Watching a Movie

Overview

PROBLEM:

• Streaming services are a fierce competitor to the Rockbuster Stealth. To remain competitive, they made the decision to launch an online video rental service, but they need specific information on the customers, movies, and markets they should focus on. 

​OBJECTIVE:

• Perform an analysis to help with the launch strategy for the new online video service and to answer management’s business questions.

Skills

Relational databases

Joining tables

Database querying

Subqueries

Filtering, Cleaning & Summarizing

Common table expressions

Tools

PostgreSQL

PowerPoint

Tableau

Data

Company Data

Key Observations

Order Distribution by day of week

  • Our major markets are centered in India and China, forming the leading regions for our business. Nearly half of our customer base originates from the Asia-Pacific region.

  • Significant portions of our customer demographic come from North and South America. However, our progress in establishing a foothold in the European market is currently slower compared to other regions.

  • Highest Grossing Revenue is Analysed in order to Plan.

  • Top Performing Actor are analysed to understand the fame.

  • Revenue generated by genres analysed to understand the audience.

  • Top 5 Revenue generating Genres and Bottom 5 Revenue Generating in Terms of genre is also analysed in order to promote or eliminate the Genre.

  • Lowest Grossing Revenue is Analysed in order to Provide eliminating recomendations.

Recommendations

  • Focusing our attention on our largest markets.Concentrate more on the markets of India, China, and the United States because they have by far the most existing clients and revenue.

  • Emphasizing our most popular titles,  genres, and actors.The categories of "Sport," "Foreign," "Family," "Documentary," and "Animation" should be expanded because they are the most profitable.

  • Reaching out to our top customers to  get feedback.Customers who have a high lifetime value should be rewarded for their loyalty.

bottom of page