Objectives
To analyze customer loyalty and film preferences, identify the locations of our loyal customers, strategically select films, align with the 2020 corporate strategy, and ensure a successful streaming platform launch.
Rockbuster LLC
Relevant Skills
Relational databases SQL Database querying Filtering Cleaning & summarizing Joining tables Subqueries Common table expressions
Insights & Recommendations
Given Asia's high revenue, we should create a loyalty reward program and initially launch the product in Asia, Europe, and North America. Further study of top genres and geographic preferences is needed, along with assessing lower-revenue areas for potential market opportunities.