Skip to content

README.md

Latest commit

 

History

History
81 lines (54 loc) · 3.21 KB

README.md

File metadata and controls

81 lines (54 loc) · 3.21 KB
Raw

📊 Rockbuster Stealth LLC SQL Data Analysis Project

This project analyzes the video rental market for Rockbuster Stealth LLC, leveraging SQL for insights into customer behavior, high-performing regions, and revenue-driving strategies. The analysis supports the company's strategic transition into the digital streaming market.

🎯 Objectives

  • Identify key regions and customer segments for targeted marketing efforts.
  • Analyze rental trends and top-performing movie genres/titles.
  • Highlight high-value customers for strategic engagement.
  • Recommend data-driven strategies to optimize revenue and user satisfaction.

📂 Project Structure

  • Data: Contains SQL scripts for data extraction and transformation.
  • Notebooks: Includes Jupyter notebooks for visualization and analysis.
  • Reports: Key insights and recommendations derived from the analysis.
  • Dashboards: Tableau links to interactive visualizations.

📝 Key Insights

1. Regional Insights

  • India (19.05%) and China (16.83%) lead in customer count.
  • The United States (11.43%) and Mexico (9.52%) are significant markets in North America.
  • Japan, Brazil, and Russia also show high engagement potential.

2. High-Value Customers

  • India leads with 18.31% of high lifetime value customers, followed by China (17.61%).
  • High-value customers are distributed across Asia, North America, and Latin America.

3. Genre and Title Performance

  • Action and Comedy dominate as top genres globally.
  • Specific high-performing titles include localized content popular in India and Latin America.

4. Rental Metrics

  • Average Rental Duration: 4.98 days.
  • Rental Rates: Range from $0.99 to $4.99, with a focus on flexibility.

🚀 Recommendations

  1. Target High-Value Regions:

    • Focus on India, China, and the United States for marketing and engagement.
    • Leverage localized campaigns for Latin America.

  2. Expand Content Library:

    • Include regional and popular titles to attract diverse audiences.

  3. Flexible Pricing Models:

    • Introduce pay-per-view, short-term rentals, and subscription bundles.

  4. Enhance Personalization:

    • Build a recommendation engine to improve customer experience.

  5. Optimize for Mobile:

    • Ensure mobile-friendly platforms for emerging markets.

🛠️ Tools and Technologies

  • SQL: Data extraction, transformation, and analysis.
  • Tableau: Interactive dashboards and visualizations.
  • Python: Analysis and scripting for advanced insights.

📊 Visual Highlights

Interactive Tableau Dashboards: