Skip to content

The RSVP movie dataset is examined in MySQL to obtain business insights for the impending film release..

Notifications You must be signed in to change notification settings

ketanmakde/SQL_RSVP_Movie_Assignment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

SQL_RSVP_Movie_Assignment

Problem Statement

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. The dataset contains 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.

Observations:

  • IMDB database consist of 7997 movies, out of which 3052, 2944, 2001 movies released in year 2017, 2018 and 2019 respectively.
  • Maximum movies are released in March and September, so these months are more profitable as compared to other months. Whereas release in July and December months are minimum.
  • Majority of movies releases in USA and India, due to its huge market potential.
  • In 2019, Drama genre topped the chart with 1078 movies followed by comedy and thriller.
  • 104.32 min is the average duration for all the movies. Action movies have highest screen time of 112.88 min, whereas drama movies have 106.77 min, slightly more than average time.
  • Drama movies have the highest count 4285 followed by comedy and thriller.
  • Dream Warrior Pictures and National Theatre Live Production houses give most hit movies.
  • James Mangold gives maximum 4 movies followed by Anthony Russo, Joe Russo & Soubin Shahir with 3 movies with average ratings more than 8.
  • RSVP movies can plan to partner with most voted production houses ‘Marvel Studio’, ‘Twentieth Century Fox' and ‘Warner Bros.’
  • In Indian context, 'Vijay Sethupathi' should be considered as top actor and 'Taapsee Pannu' considered as top actress on the basis of their ratings in recent year.
  • Shatamanam Bhavati (2017), The Villain (2018), Joker (2019) topped the chart in gross income.
  • In India, people speak multiple languages, so it is better to try Production Company having good record over multiple language that is 'Star Cinema' and 'Twentieth Century Fox'.
  • RSVP should also consider Sangeetha Bhaat, Fatmire Sahiti as actress and Aryan Gowda, Naveen D. Padil as actors for drama movies as all has topped in the category.

About

The RSVP movie dataset is examined in MySQL to obtain business insights for the impending film release..

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages