DATA ANALYST

ROCKBUSTER STEALTH LLC

Tools

 

  • Microsoft Excel

  • Microsoft Word

  • Microsoft PowerPoint

  • PostgreSQL

  • DbVisualizer

  • Tableau

Skills

 

  • Data Extraction and Cleaning.

  • Data Exploration.

  • Data Preprocessing.

  • SQL and Database Management: Querying and extracting data.

  • Joining tables

  • Performing subqueries

  • Using CTEs (common table expressions).

  • Creating a data dictionary

Data

 

  • Rockbuster Stealth LLC data

  • Project brief

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

 

Objective

 

Purpose of the analysis is to help with the launch strategy for the new online video service.

What Genre are popular by Revenue?

The top 10 revenue generating movies all have the maximum rental rate of $4.99, but their average rental duration is short at 4 days.

 

The bottom 10 revenue generating movies all have the minimum rental rate of $0.99, and a longer average rental duration of 6 days

What Movies Contributed Most/Least To Revenue Gain?

RockBuster Statistics

Top 10 Countries in terms of customers based in

 

  • INDIA

  • BRAZIL

  • CHINA

  • RUSSIAN FEDERATION

  • UNITED STATES PHILIPPINES

  • JAPAN

  • TURKEY

  • MEXICO

  • INDONESIA

Regions with the highest movie rental income include Asia, North America, and South America.

Which countries are Rockbuster customers based in

Where are customers with a high lifetime value based?

Market Expansion

 

  • Asia: Since Asia contributes the most revenue in sales, focus investments on marketing and customer engagement in this region could bring substancial returns.

  • Underperforming Regions: Create strategies to boost revenues in regions like Oceania, Central America and The Caribbean which currently have lower revenue contribution

Update Inventory

 

  • Take the films out of the inventory that produced no revenue and replace them with licensing for new release movies.

Customer Experience

 

  • Send surveys to lifetime customers to get their input on the new online video strategy.

  • Offer annual membership with unlimited streaming to all customers.

  • Launch promotions and deals to increase customers activity.

Top Performing

 

  • Focus on the top genres and ratings, like PG-13 and Sports.

  • Increase the variety and offer promotions and deals.

.

RECOMMENDATIONS

Ivonne Aspilcueta 

Data Analyst

 

Hermosa Beach, CA, United States