This project analyzes a cleaned IMDb movie dataset using SQL to provide data-driven recommendations for RSVP Movies, a film production company planning a global movie release.
RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.
The production company wants to plan their every move analytically based on data and have approached you for help with this new project. You have been provided with the data of the movies that have been released in the past three years. You have to analyse the data set and draw meaningful insights that can help them start their new project.
I have to use SQL to analyse the given data and give recommendations to RSVP Movies based on the insights.The entire analytics process has been divided into four segments, where each segment leads to significant insights from different combinations of tables.
IMDB_dataset_import.sql: SQL script to create and populate database tables.IMDB_question_solutions.sql: Answers to all case study queries.Executive_Summary.md: Key findings and strategic recommendations.Problem_Introduction.md: Problem background and objectives.IMDb_movies_data_and_ERD.xlsx: Dataset and ERD reference.
Based on the SQL analysis, the following strategic insights were derived for RSVP Movies:
- There is a downward trend in the number of movies produced over the years. The highest number of movies were produced in the month of March.
- Drama is the most popular genre with 4,285 movies and an average duration of 106.77 minutes.
- RSVP Movies can focus on the Drama genre for future films. Action and Thriller genres are also in the top three.
- Dream Warrior Pictures and National Theatre Live have produced the highest number of hit movies.
- Marvel Studios, Twentieth Century Fox, and Warner Bros are the top three production houses based on vote count—ideal global partners.
- Star Cinema and Twentieth Century Fox lead in multilingual hit movies and are strong candidates for global collaboration.
- James Mangold is the top director across the top three genres; he could direct the next project.
- Mammootty and Mohanlal are top actors by median rating and can be hired for strong audience appeal.
- Parvathy Thiruvothu and Andrew Garfield are the most successful Drama genre actors by super hit count.
- Vijay Sethupathi has high votes and a rating of 8.42 in India — a strong addition to attract Indian audiences.
- For Hindi movies, Taapsee Pannu is a strong choice, with a 7.74 average rating and high vote count.
- Advanced SQL (JOINs, Window Functions, CTEs)
- Data Cleaning & Aggregation
- Business-Oriented Data Analysis