Online Video Streaming Analysis Using SQL

Answers to complex business questions posed by fictitious online video streaming company's management board using SQL.

Overview

Rockbuster Stealth LLC, a ficticious movie rental company, is looking to launch an online video rental service using its current movie rental licenses. Rockbuster's business intelligence department wants a data-driven analysis of its stock to mitigate risks and maximize profits during the launch. The final report will provide actionable insights to the company's key questions.

Skills/Tools/Procedures

Relational databases
SQL
Database querying Filtering
Cleaning and summarizing Joining tables
Subqueries
Common table expressions

Links

Original data:
http://www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip

Data dictionary:
https://github.com/dheepika-chokkalingam/Online-Video-Streaming-Analysis-Using-SQL/blob/Test/Data%20Dictionary_Dheepika.pdf

Final report:
https://github.com/dheepika-chokkalingam/Online-Video-Streaming-Analysis-Using-SQL/blob/Test/Final%20Report_Dheepika.pdf

Tableau visualizations:
https://public.tableau.com/views/RockbusterLaunchProject/Story?:language=en-GB&:display_count=n&:origin=viz_share_link