• - Rockbuster Stealth LLC - 

    A fictional movie rental company with physical stores around the globe, Rockbuster Stealth LLC is planning to launch an online video rental service.

     

    Objective

    The purpose of this analysis is to help the launch strategy by looking at revenue gain, rental statistics, and geographic regions.

    Data

    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
  • Map of the world showing countries with the most customers and sales

     

    Rockbuster Customers Around the World

    Regions with the highest movie rental income include Asia, North America, and South America. India is the country with the most customers and the most revenue generation.

    RockBuster Statistics

    1,000

    Number of films in Rockbuster's library

    PG-13

    Most common rating of films, making up 22.30%

    599

    Total number of Rockbuster customers

    $211.55

    Most revenue generated by one customer

    5 Days

    Average rental duration of all films

    Line and bar chart of top 10 countries with the most customers and revenue

    Top 10 Countries

    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.

    Bar chart of the top 10 movies with the most and least sales

    Top 10 Movies With the Most & Least Generated Revenue

    The top 10 movies all have a rental rate of $4.99 and an average rental duration of 4 days.

     

    The bottom 10 movies all have a rental rate of $0.99 and an average rental duration of 6 days.

     

    Rockbuster can increase revenue by increasing movie prices and increasing rental duration of best-selling movies.

  • Conclusion & Recommendations

    Customer Priority

    Survey customers to get their input about the online launch. Consider starting a loyalty reward program for lifetime value customers.

    Increase Revenue Options

    Offer a monthly subscription alongside one-time rentals to reach more customers. Price movies over $4.99. Newer movies, for example, can cost more as their newness will be the incentive to rent them.

    Increase Rental Duration

    Launch promotions or deals to increase rental duration (e.g., rent for 4 days, get the 5th day free.)

    Focus on Top Countries

    Focus market on the top 10 countries, as they have the most customers and generate the most revenue.

    Cookie Use
    We use cookies to ensure a smooth browsing experience. By continuing we assume you accept the use of cookies.
    Learn More