Analyse the data set and draw meaningful insights that can help RSVP start their new project.
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. Provided with the data of the movies that have been released in the past three years. Analyse the data set and draw meaningful insights that can help them start their new project.
IMDB+dataset+import.sql contains the movie data set
IMDb+movies+Data+and+ERD+final.xlsx contains ERD and schema
- Use SQL to analyse the given data and give recommendations to RSVP Movies based on the insights.
- Study the ERD and the table details carefully and understand the relationships between the table.
- Divide analytics process into four segments, where each segment leads to significant insights from different combinations of tables.
- The questions in each segment with business objectives are answered.
Executive Summary and Recommendation is made after the analysis.
Executive_Summary_and_Recommendation.pdf contains data insights and Proposals.