As a movie rental company that faces strong competition, the management team wants to launch an online video rental service.
KEY QUESTIONS
Which movies contributed the most/least to revenue gain?
Which countries are Rockbuster customers based in?
Do sales figures vary between geographic regions?
Where are customers with a high lifetime value based?
Conclusions: start the develop of the online version in the countries with the highest sales generated. Motivate the customers that bring the highest revenue to switch to online market
SKILLS/TOOLS/PROCEDURES
Relational Database, SQL, Database quering, Filtering,
Cleaning and summarizing, Joining tables, Subqueries, CTE