Rockbuster Stealth, a fictional movie rental company, is preparing to launch an online service in order to keep up with the competition. To prepare for a successful launch, the company has ordered a data analytics project to obtain valuable insights and recommendations.
The final project can be found here.
The analysis has been done querying a relational database, containing data on film inventory, customers, payments, and more.
Rockbuster Data Dictionary includes table descriptions and the Entity Relationship Diagram.
- pgAdmin 4 for PostgreSQL
- Tableau
- Excel
- Gamma.app
-
Data Cleansing: Conducted data cleaning operations, addressing issues such as duplicates, inconsistent data formats, and handling missing values.
-
Table Integration: Strategically determined join types and order to optimize computational efficiency during table integration processes.
-
Exploratory Data Analysis: Utilized basic descriptive statistics like maximum, minimum, mean, or mode for variable insights, while employing GROUP BY and ORDER BY clauses to address more complex analytical queries.
-
Common Table Expressions (CTEs) & Subqueries: Developed Subqueries and recreated them using Common Table Expressions (CTEs) to enhance code readability and facilitate code reusability.
-
Results Presentation: Compiled findings and recommendations into a cohesive presentation, effectively answering key project questions and providing actionable insights.