Data Analyst
.png/:/cr=t:0%25,l:0%25,w:100%25,h:100%25/rs=w:806,h:453)
Rockbuster Stealth Analysis
A PostgreSQL based strategic analysis of movie rental data of Rockbuster Stealth, a fictitious company, to prepare to launch an online video rental service
Project Overview
Objective
Objective
Objective
Perform a strategic analysis of movie and rental data for the business intelligence department to assist in strategy development for the launch of an online video rental service in order to stay competitive in the industry.
Data
Objective
Objective
Dataset was provided as part of the CareerFoundry Data Course, sourced from PostgreSQL
Skills
Skills
Skills
Relational databases, SQL, Database querying, Filtering, Cleaning and summarizing, Joining tables, Subqueries, Common table expressions, Data Dictionary
Tools
Skills
Skills
PostgreSQL, Tableau, PowerPoint
Project Flow
Getting Acquainted
Database Querying in SQL
Filtering Data
Cleaning & Summarizing Data
Checking for and cleaning dirty data
Descriptive Statistics
Answering Business Questions
Performing Joins, Subqueries, and CTEs to answer business questions
Data Visualizations
Utilize Tableau to create visualizations
Presenting Results
Utilize PowerPoint and Tableau Dashboard to present insights
Analysis
Final Report
Recommendations
A phased growth strategy:
•Phase 1: Using current inventory launch online video rental service in India, China, and the US as these countries lead in # of customers, transaction count, and revenue generated
•Phase 2: Implement customer appreciation programs to recognize high lifetime value customers
•Phase 3: Expand current inventory starting with movies that are Sports and/or PG-13 as they generate the most revenue
TAKEAWAYS
•When working with larger datasets it is easier to manipulate, extract, and aggregate data in SQL than in Excel.
•Next time to improve on my analysis, I will remove films that generated no revenue from analysis.
Copyright © 2022 Shey LeGras - All Rights Reserved.
Powered by GoDaddy
This website uses cookies.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.