Objective

For this student project, I assumed the role of a data analyst contracted by the Business Intelligence (BI) division of Rockbuster Stealth to contribute to the launch strategy for their new online video service. My primary responsibility involved providing data-driven solutions to various departments, ranging from inventory management to customer insights. The Rockbuster Stealth Management Board had presented a series of business inquiries, and they anticipated receiving data-backed responses to inform their 2020 company strategy.

Data

As this is an SQL-based project, it's important to note that each table in the database falls within two categories: fact and dimensions. Here is the link for the entire dataset http://www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip

Fact Tables

• Rental

• Payment

Dimension Tables

• Film

• Staff

• Customer

• Address

• Inventory

• Actor

• City

• Country

• Store

• Category

• Film_actor

• Film_category

• Language

Tableau Visualizations

https://public.tableau.com/app/profile/xavier.herrera1185/viz/Task3_10-SQLInsights/Sheet10?publish=yes