📊 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:

• Top 10 Countries by Customer Count
• High Lifetime Value Customers
• Top 5 High-Performing Movies
• Top 10 Movie Genres