A breakdown of the Data Analytics process using SQL, applied to the Rockbuster Stealth movie database.
Rockbuster Stealth LLC is a fictional movie rental company that is looking for an analysis on their database, to answer some key business questions and objectives:
- Which movies contributed the most/least to revenue gain?
- What was the average rental duration for all videos?
- Which countries are Rockbuster customers based in?
- Where are customers with a high lifetime value based?
- Do sales figures vary between geographic regions?
See the whole project briefing here: Project Brief
To see queries used in the data analysis process, look here: Queries
To follow how the tables are structured, take a look at the data dictionary here: Data Dictionary
To see the final report generated about the dataset, look here: Final Report