Description

This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service. The dataset used in this project contains detailed information about Rockbuster's film inventory, customers, and payments, among other key business metrics. As part of the Business Intelligence (BI) team, I loaded and managed data in an RDBMS, performed SQL-based analysis, and provided actionable insights to support the company's strategic launch decisions. The results were compiled into a report presented to the management board to guide their decision-making process.

Topics Covered

Relational databases, data storage, SQL, data querying, filtering data, cleaning and summarizing data, joining tables, subqueries, and common table expressions

Tools Used

PostgreSQL database, pgAdmin4, DbVisualizer, and Tableau