Customer and Rental Insights Analysis in SQL -- 2
Budget: $30 – $250 USD
Budget: $50
Time Estimate: 3–4 hours
Use SQL to analyze the Sakila DVD rental database to generate insights on customer behavior and rental trends. This analysis will help the business understand its top customers, popular films, and rental patterns, aiding in decision-making around inventory and marketing.
Key Requirements:
1- Data Extraction: Write SQL queries to retrieve data on customer demographics, rental frequency, and film popularity.
2- Data Analysis:
- Identify the top 10 customers by rental frequency and total spend.
- Calculate the most popular film genres and films, along with their rental counts.
- Analyze rental trends by time period (e.g., monthly or seasonal trends).
- Aggregation and Joins: Use SQL joins to combine data from multiple tables as needed (e.g., linking customer and rental data with film and genre data), and apply aggregation functions to generate summary metrics.
Deliverables:
- A document containing:
- The SQL queries used for the analysis.
- A summary of key insights, such as top-performing films, top customers, and high-demand periods.
- Any observations on customer or rental patterns that could be relevant for business strategy (e.g., "Action films are more popular among younger customers").
Dataset:
Use the Sakila database from https://dev.mysql.com/doc/index-other.html (https://downloads.mysql.com/docs/sakila-db.zip)
Time Estimate: 3–4 hours
Use SQL to analyze the Sakila DVD rental database to generate insights on customer behavior and rental trends. This analysis will help the business understand its top customers, popular films, and rental patterns, aiding in decision-making around inventory and marketing.
Key Requirements:
1- Data Extraction: Write SQL queries to retrieve data on customer demographics, rental frequency, and film popularity.
2- Data Analysis:
- Identify the top 10 customers by rental frequency and total spend.
- Calculate the most popular film genres and films, along with their rental counts.
- Analyze rental trends by time period (e.g., monthly or seasonal trends).
- Aggregation and Joins: Use SQL joins to combine data from multiple tables as needed (e.g., linking customer and rental data with film and genre data), and apply aggregation functions to generate summary metrics.
Deliverables:
- A document containing:
- The SQL queries used for the analysis.
- A summary of key insights, such as top-performing films, top customers, and high-demand periods.
- Any observations on customer or rental patterns that could be relevant for business strategy (e.g., "Action films are more popular among younger customers").
Dataset:
Use the Sakila database from https://dev.mysql.com/doc/index-other.html (https://downloads.mysql.com/docs/sakila-db.zip)