Rockbuster Stealth: what's in the store?

OVERVIEW

Rockbuster Stealth is a fictional brick-and-mortar movie rental company with stores around the world. The management plans to use existing movie licenses to launch an online video rental service. To make informed decisions, they need to know what is in the store and how the sales performed. Additionally, the marketing department wants to learn the company’s most loyal customers.

OBJECTIVE

To explore the inventory and revenues, the relational database management system PostgreSQL was used utilizing queries in pgAdmin4. The entity-relationship diagram with DBVisualizer was extracted to built data dictionary in Word. Findings were presented in PowerPoint with embedded Tableau’s storyboards.

DATASETS

The data set was around 3MB and contained several files with film inventory, customers, and payments, among other variables. No source for this data was provided.

TOOLS

PostgreSQL + pg4Admin + Excel + Tableau Public + Power Point + Word

This study project was part of my data analytics course with CareerFoundry.

• RESULTS OF THE ANALYSIS
• CASE STUDY PDF
• PROJECT'S FILES

BACK TO PROJECTS