Using SQL for in-depth analysis of a company's growth prospects and performance.
Link to the Tableau storyboard
This project aims to understand the potential of the customer base of the analyzed business. By analyzing the data, the project answers the main business questions outlined by the management, analyzes the tastes and preferences of the customers, and determines whether they can be satisfied by the existing inventory.
● Which movies contributed the most and 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?
● What movie genres are most popular in the countries with the highest sales?
● Does the inventory match the customer interests in the top 10 countries? Are the most popular genres well represented?
● What genres do our top customers prefer?
Q1: List of all movies, including title, length, total rentals, total revenue, rate, rental duration, genre, rating, actors, number of copies.
Q2: Customer count, total revenue, and the average amount paid by country.
Q3: Top 10 customers: name, location, total movies rented, total money spent.
Q4: Genres rented by top 10 customers.
Q5: Total number of rentals and revenue of each genre and rating by country.
Contact: Adilya Zaripova [email protected]
This project was created for an SQL training challenge.