Answers to complex business questions posed by fictitious online video streaming company's management board using SQL.
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.
- Relational databases
- SQL
- Database querying Filtering
- Cleaning and summarizing Joining tables
- Subqueries
- Common table expressions
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