This project analyzes the Maven Movie Rental database to gain insights into rental trends, customer behavior, and business performance. Using SQL queries, we extract meaningful insights that help improve decision-making for revenue growth, customer retention, and inventory optimization.
- Identify customer details (names, emails) for targeted marketing campaigns. Analyze customer rental patterns to improve customer engagement.
- Explore the rental inventory and classify movies based on rental rates and availability. Provide recommendations for expanding the movie collection based on popularity and rental rates. Revenue Optimization:
- Analyze rental rates to identify trends and the profitability of various pricing categories. Determine the most rented movie categories and ratings to maximize revenue.
- Help track and manage movie inventory effectively. Highlight gaps in the inventory and optimize stock levels.
- Database: MySQL
- Query Language: SQL
The Maven Movie Rental Database contains tables related to:
- Customers: Personal details, rental history
- Movies: Titles, genres, rental prices, and ratings
- Stores: Store locations and inventory data
- Payments: Customer payments and rental transactions
Here are some ad-hoc business questions answered using SQL:
-
What is the total number of movies in the inventory that are available for rent at the lowest rental rate of $0.99?
-
What is the distribution of movies across different rental rate categories?
-
Do movies with higher replacement costs have higher rental rates?
-
Which movie rating category has the highest number of films?
-
What is the most common movie rating in each store?
-
How does movie length correlate with rental duration and ratings?
-
Can we list all movies along with their category and language?
-
How many times has each movie been rented out?
-
Can we pull a list of movies available in each store, including title, description, and store ID?
-
What are the top 10 highest-grossing movies in terms of revenue?
-
Which store has historically generated the most revenue? How does it compare with other stores?
-
How much revenue do we generate per month?
-
Which customers have spent the most money on rentals?
-
How can we extract the first name, last name, and email address of all customers to prepare a comprehensive contact list for the marketing team?
-
Who are the top customers who have rented at least 30 times?
-
Could you pull all payments from our first 100 customers (based on customer ID)?
-
How many customers have made payments over $5 since January 1, 2006?
-
Could you write a query to pull all payments from those specific customers, along with payments over $5, from any customer?
-
Can we identify customers who have rented less than 15 times overall?
-
Which store does each customer visit, and are they active or inactive?
-
Do longer movies also tend to be more expensive to rent?
-
How many titles are available, categorized by their respective rental durations?
-
Can we categorize movies by length for better recommendations?
-
Which movies should be recommended to individuals based on specific demographics like cultural background or interests?
-
How many films include the "Behind the Scenes" special feature?
-
Can we list all staff members and advisors, and distinguish their roles?
-
The Manager from Store 2 is working on expanding our film collection there.
Could you pull a list of distinct titles and their descriptions currently available in inventory at Store 2?
-
How many movies has each actor appeared in?
-
Can we list all the starred actors in the movies?
-
Customers often ask which films their favorite actors appear in. Can we generate a list of all actors with each title they appear in?
- Clone the repository:
git clone https://github.com/Ritikrb126/Maven-Movie-Rental-Analysis
- Open the SQL file and execute queries on your database.
- Modify queries based on additional business requirements.
Feel free to contribute by improving queries, adding visualizations, or suggesting new analysis!
📧 Ritik Bhoyar
🔗 GitHub Profile