Rockbuster Stealth Data Analysis Project
Leveraging Data Analytics Online Rental Strategy
Problem Overview:
Based on the task scenario, Rockbuster Stealth LLC, once a global movie rental chain, is pivoting to online rentals to compete with streaming giants like Netflix and Amazon Prime.
As a Data Analyst in the Business Intelligence (BI) Department, I supported Rockbuster’s online launch by leveraging data on customer behavior, revenue trends, and market segmentation which aligned with its 2020 strategy.
- Database Management – Loaded Rockbuster’s dataset into PostgreSQL RDBMS.
- SQL Analysis – Queried customer behavior, rentals, and revenue trends.
- Visualization & Reporting – Presented insights via SQL-based dashboards.
- Strategic Insights – Provided recommendations for market expansion.
Key Lessons Learned
SQL Query Optimization is Key – Efficient queries improve performance and insights.
Data Visualization Enhances Communication – Presenting SQL results clearly is critical for stakeholders.
Market Insights Drive Strategy – Data-driven decisions outperform intuition-based strategies.
Final Thoughts
This project showcases how data analytics and SQL-based reporting can drive business decisions in the digital transformation of the movie rental industry. The analysis provides actionable insights into customer behavior, revenue trends, and market opportunities, supporting Rockbuster’s transition to an online platform.