rsvp movie assignment upgrad

SQL_RSVP_Movies

Problem statement:.

RSVP Movies is an Indian film production company that wants to release a movie for the global audience in 2022. They have approached you, a data analyst and SQL expert, to help them analyze data from the past three years of movies to draw meaningful insights that can help them with their new project.

The problem statement is divided into four segments:

Segment 1: Analyze the number of movies released each year and month to identify the most popular time of year for movie releases.

Segment 2: Analyze the genres of movies released to identify the most popular genres.

Segment 3: Analyze the production houses that have released the most successful movies to identify the most successful production houses.

Segment 4: Analyze the actors and actresses who have starred in the most successful movies to identify the most popular actors and actresses.

• Executive Summary PDF.
• README File.

SQL-RSVP-Movies-Case-Study

Sql rsvp movies case study.

SQL queries performed on the IMDb database to provide recommendations to RSVP Movies based on insights.

Problem Introduction

RSVP Movies is an Indian film production company that 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 its every move analytically based on data and has approached you for help with this new project. You have been provided with the data on the movies that have been released in the past three years. You must analyze the data set and draw meaningful insights that can help them start their new project.

You are a data analyst and an SQL expert. You must use SQL to analyze the given data and give recommendations to RSVP Movies based on the insights. For your convenience, the entire analytics process has been divided into four segments, where each segment leads to significant insights from different combinations of tables. The questions in each segment with business objectives are written in the script.

Data Set and Database Creation

• Download the IMDb dataset.
• The first tab contains the ERD and the table details. Study that carefully and understand the relationships between the table.
• Inspect each table given in the subsequent tabs and understand the features associated with each of them.
• Open your MySQL Workbench and start writing the DDL and DML commands to create the database.

If you don’t wish to perform the data loading part, you can directly download the SQL script file containing all the commands and data required for the database creation and start directly with the querying.

Advanced Certificate in Data Science

12+ Hours of Learning Sessions/Week

Credentials, soft-skills coaching, interview prep, placement drive, batch start, limited seats available.

High School Diploma or 10+2

Options available

Book your free career counselling session today., hands-on immersive classes.

Learners will get to participate in intense practice sessions where they will learn to apply theoretical concepts to actual data, solve complex problems, and navigate the challenges that arise when working with real datasets. The Immersion Program is designed to enhance your critical thinking skills and problem-solving abilities. These will be offline sessions conducted at upGrad's Offline Learning Centre in Pune.

High-quality instructors and teaching assistants

In-person teaching from exceptional educators with average 10+ years of experience.

Smart Classrooms

Air-conditioned classrooms with high-speed internet facility, secure connection, projectors, speakers, comfortable seating, and smart TV arrangements.

Network with Peers

Interact with people who share similar interests to build your professional network.

Programme Overview

Key highlights.

"Our aim is simple: We strive to create high-impact, hands-on experiences that prepare students for meaningful and productive careers.” - Ronnie Screwvala, Co-Founder, upGrad

A learner who opts for an early exit has the option of continuing the course in the future from where they exited. The pedagogy and delivery model may stand changed from when the learner initially enrolled.  

For further clarification, please reach out to your admissions counselor.

Top Skills You Will Learn

Job opportunities, who is this programme for, minimum eligibility, programming languages and tools covered.

Advanced Certificate in Data Science from upGrad

Our team of experts

Content designed by india’s leading data science faculty and industry experts.

Kaustubh Singh

Behzad Ahmadi

Mirza Rahim Baig

Sajan Kedia

Rajesh Sabapathy

Vishwa Mohan

Kautuk Pandey

Ujjyaini Mitra

• Mathematics for DS/ ML
• Developing Logic in Programming + CRSIP DM + Excel
• Business Problem Solving using Excel
• Basics of SQL
• Advanced SQL - I
• Data Modelling
• Advanced SQL - II
• SQL Assignment
• Intro to Python
• Programming in Python
• Python for DS - NumPy and Basic Pandas
• Data Visualisation in Python
• Exploratory Data Analysis
• Python Assignment

Business Problem Solving + Visualisation

• Data Story Telling + Visualisation using Tableau
• Visualisation in PowerBI, AWS Quicksight & Google Looker Studio
• Structured Problem Solving + Business Problem Solving
• Dashboarding Assignment

Intro to ML

• Inferential Statistics + Hypothesis Testing
• Linear Regression
• Logistic Regression
• Capstone Project/ Guided Internship

Advanced ML

• Decision Trees
• Ensemble Models
• Natural Language Processing
• Neural Networks + Generative AI
• Project 2 - Wolves

Industry Projects

• Engage in collaborative projects with student-mentor interaction
• Benefit by learning in-person with expert faculty
• Regular in-person doubt resolution sessions to facilitate better subject understanding

Loan Approval EDA Assignment

In this assignment, you will work for a consumer finance company which specialises in lending various types of loans to urban customers and use EDA to analyse the patterns present in the data. This will ensure that the applicants are capable of repaying the loan and are not rejected.

Movie Dataset from RSVP movies ( SQL Case Study)

In this assignment, you will work on a movies dataset using SQL to extract exciting insights about popular films and the factors that drive a film.

Bike Sharing Assignment

Perform data analysis to understand the factors on which the demand for bike sharing systems vary on and help a company optimise its revenue.

Lead Scoring Case Study

In this case study, the company requires you to build a machine learning classification model wherein using some demographics and behavioural data of the leads (potential buyers), it will be able to identify the ones most likely to convert.

Airbnb Case Study

Understand the factors that drive the Airbnb business and help the team leads tackle problems and bottlenecks through extensive data analysis on UI tools.

Advanced ML Case Study - Telecom Churn

Telecom companies often face the problem of churning customers due to the competitive nature of the industry. Help a telecom company identify customers that are likely to churn and make data-driven strategies to retain them from the perspective of a data scientist.

The upGrad Advantage

Industry-leading course curriculum & content.

• 10+ tools and hands-on practice on 10+ case studies
• Learn from industry cases for practical application
• Course content and assignments designed in line with industry standards
• Mix of Live Classes & Recorded lectures for your convenience

Extensive At-centre Learning Support

• Personalised expert feedback on assignments and projects
• Regular training sessions of technical/softskills and aptitude every-week
• In-person dedicated doubt resolution sessions every day
• Dedicated practice problem/case study discussion sessions every Saturday

At-centre Placement Drives

• Regular soft-skills training sessions with experts to improve communication skills
• Regular employability tests to improve skillsets and speed
• Opportunity to interview with our hiring partners and connect with them
• Meet industry experts, upGrad teams and alumni in fun-filled Networking Basecamps!

Unparalleled Career Services

• Mentorship by industry experts to help you determine your Career Path & Options
• One-on-one coaching to help you get the best career transition
• Get on-demand mock interviews for when you have to prepare for interviews
• Use our AI-driven Top Resume Building tools to impress recruiters

Our Learners Work At

Over 500 Careers Transformed

Admission process.

There are 3 simple steps in the Admission Process which is detailed below:

Fill the Application Form

Fill out an application giving your basic profile details.

Shortlisting and block payment

Once shortlisted, pay a block fee of INR 5,000 (Non-refundable)

Offer letter and payment

Balance to be closed within 7 days or batch start date whichever is sooner.

Program Fees- Indian Residents

Inr 1,16,820 inr 85,000 (incl. taxes) for a limited time period, frequently asked questions, course eligibility, who is this program for.

Anyone who is looking to enhance their qualification with an advanced certification, boost their employability and increase their chances of landing a new-age job in Data Science, Gen AI with improved opportunities for career growth. (Do not take a gap)  

Is there an eligibility criteria for this program?

What is the admission process.

The admissions process is completely online. The following are the key steps in the application process: 

Step 1 - Fill Application form : Fill out an application giving your basic profile details.

Step 2 - Shortlisting and block payment: Once shortlisted, pay a block fee of INR 10,000 (Non-refundable)

Step 3 - Offer letter and payment: Balance to be closed within 7 days or batch start date whichever is sooner. 

Course Curriculum

What kind of certification will i get after completion of this course.

Post successful completion of this program, you will get an Advanced Certificate in Data Science.

How much time do I need to spend to achieve success in the program?

You will need to spend 20-25+ hrs/week to get optimum results and learn. 

Overall, this program will have video content broken down into small easy-to-complete segments that you can watch on the go-across devices. The remaining hours of engagement will be a mix of industry projects, live instructor sessions, mentoring sessions and online and offline meetups. 

How do I know that this program’s curriculum is the best?

The curriculum is developed by by globaly renowned faculty with special inputs from industry experts, which makes it extremely relevant to working professionals. 

Along with it, our Support Services, Career Assistance, and Live Sessions make it a classroom experience, which no one else in the market can offer. 

How would these real-industry projects help me?

Our programs have a strong experiential component that will prepare you to apply your learning on the job. Learn-Experience-Apply, Case Studies and industry projects will help you to experience real-life challenges of a data scientist.   

These will enable you to step into shoes of leading data scientist at companies and put to use the theoretical learning in an experiential manner. Post this program, these will serve as a portfolio of projects you can illustrate to boost your job placement opportunities or to advance your career.

What kind of support does upGrad offer?

- Student Support is available 7 days a week, 24*7

- You can write to us via [email protected]  Or for urgent queries, use the "Talk to Us"  option on the Learn platform

- Additionally, an upGrad buddy will enhance the learners’ experience by engaging with them to ensure they are on track with upcoming deadlines, and submissions, offer guidance and resolve their non-academic queries.

- Extensive academic support through the Discussion Forum, and weekly TA-Sessions. Just like in a university, your batchmates will help you with any academic queries. This will happen via the Discussion Forum.

- Other than your peers, you also have TAs (Teaching Associates) for any academic query. Your academic queries will be solved by the Faculty and TAs in 36-48 hours

Refund Policy/Financials

How much do i pay to block my seat.

You need to pay ₹ 5,000 to block your seat, which is non-refundable. 

No Cost Credit Card EMI FAQ's

0% EMI with Finance partners /Credit card option availability will vary program wise. 1. Which banks allow using 0% Credit card EMI or Credit card EMI? No cost EMI is available on credit cards from all major banks (American Express, Bank of Baroda, HDFC Bank, ICICI Bank, IndusInd Bank, Kotak Mahindra Bank, RBL Bank, Standard Chartered, Axis Bank, Yes Bank and State Bank of India). 2. Is there any minimum transaction limit ? Yes. 50000 is the minimum. 3. Standard Chartered Bank offers 18 or 24 months No Cost EMI ? No. ONLY 12 months is available irrespective of the Program enrolled. 4. Will I have to pay any extra amount for EMI transaction? If you are availing 0% credit card EMI, upGrad will not charge any processing fees or down payment for these transactions. Your bank may levy GST or other taxes on the interest component of the EMI. 5. Are there any fees or down payment? Certain banks charge nominal processing fees between INR 99 - 500 on 0% Credit Card EMI transaction. If charged, will be billed in the first repayment installment. 6. Can I use my International credit card for 0% credit EMI or Credit Card EMI? Only the Indian bank credit cards can be used. But you can pay the amount using the Credit card option in one shot / part payments, and later you can convert into EMI from your respective bank. The tenures and interest charged will depend on your bank. upGrad will not charge any processing fees or down payment for these transactions, this will be purely between you and your bank. 7. Are there any charges in case I opt for cancellation/refund from the course after paying balance with no cost EMI ? Yes, there will be additional charges to the extent of interest paid by the upGrad to the bank, you will be refunded only Principal amount, i.e. the amount actually deducted/blocked from your card. This deduction will be in addition to the amount mentioned in the refund policy shared with your offer letter. 8. Can I Pay Using Multiple Credit Cards ? Multiple cards can be used to complete the payments using Part payment option make sure to inform the learner, minimum transaction is INR 50000 to opt for 0% CC EMI E.g. Amount to be paid: 150000. I can pay using 2 Credit cards. Yes, Example : HDFC Card – Part payment – INR 100000 ICICI Card – Part payment – INR 50000 9. How can I opt for Credit card EMI if my bank is not listed in the 0% Credit card EMI or Credit card EMI? You can pay the amount using the Credit card option in one shot / part payments, and later you can convert into EMI from your respective bank. The tenures and interest charged will depend on your bank. upGrad will not charge any processing fees or down payment for these transactions. 10. Why is the entire amount blocked on my credit card? Initially your bank will block the entire amount from your available purchase limit and from your next billing cycle, you will be charged the EMI amount. As you start paying your EMI, your credit limit will be released accordingly. For example, if you have made a payment of ₹100000 on 6-months EMI and your credit limit is ₹200,000 then initially your bank will block your credit limit by ₹100000. After payment of your first month EMI of Rs.15000, the blocked amount will come down to ₹85000. 11. Why is interest getting charged on No Cost EMI? Your bank will charge you interest. However, this interest charge has been provided to you as an upfront discount at the time of your payment, effectively giving you the benefit of a No cost EMI. The total amount paid during the entire EMI tenure to the bank will be equal to the amount to be paid to upGrad. Eg. Amount payable to upGrad: INR 405000 Let's say Amount deducted at the time of transaction: INR 379850 (Principal amount) Bank charges interest of 12-15% per annum on INR 379850 [Note: Interest factor is reducing rate and not Flat rate] EMI AMOUNT = INR 33750 x 12 = INR 405000 Effectively, you have taken loan on 379,850 instead of 405,000

Is there any deferral or refund policy for this program?

Refund policy: (programmes with prep-session component) .

• Student must pay an applicable caution money for the enrolment to the Programme. This caution amount will be adjustable against the total Programme fee payable by the student.
• You can claim a refund for the amount paid towards the Program at any time, before the Program Start Date, by visiting www.upgrad.com and submitting your refund form via the "My Application" section under your profile. You can request your Admissions Counselor to help you in applying and withdrawing for a refund by sending them an email with reasons listed. Processing fee of Rs. 10,000/- will be levied. If less than Rs. 10,000/- have been paid in total, student shall not be eligible for any refund in such case.
• Student shall not be eligible for any refund under any circumstances if any such refund requests are raised post Cohort Commencement Date and student will continue to pay the EMI for loan (if applicable) and such loan cannot be cancelled. This is also applicable for those students who could not complete their payment and could not be enrolled in the cohort opted for. However, the student can raise a request for Pre-Programme deferral as per the policy defined below for the same.
• In case of a refund, student will be solely responsible for any cancellation of loan, including but not limited to applicable loan cancellation charges levied on the total cancelled loan amount.
• Student must pay the full fee within 7 days of payment of Caution Money or Cohort Commencement Date, whichever is earlier, otherwise the admission letter will be rescinded.
• Request for refund must be sent via e-mail in the prescribed Refund Request Form. The refund will be processed within 30 working days of commencement of the program after being duly approved by the Academic Committee.

1st Deferral (pre or post programme commencement) is free for all enrolled students with the following conditions:

• The Executive Post Graduate Program learners should complete the course in a maximum duration of 3 years from the initial batch start date.
• The Advanced Certificate Program learners should complete the course in a maximum duration of 2 years from the initial batch start date.

2nd deferral will be charged as explained below. 

 2nd Deferral Policy: (Pre- Programme Commencement) 

• If a student, due to unavoidable circumstances is unable to commence with the cohort and requests for a deferral before the cohort starts, we provide the opportunity for the student to defer to another batch.
• However, the student will be required to pay 50% of the total course fee amount (inclusive of taxes) before the deferral can be approved. Till this is completed, the student will be assumed to be continuing in the same cohort.
• A student can request for deferral only once and to either of the scheduled cohorts to start in the next 1 year from the batch start date of initial batch the student enrolled for.
• The student has time till the current cohort launch date to make the payment of the 50% program fee, post which the deferral request will expire. Once the deferral window expires and the student now asks for a refund, the above-mentioned applicable refund policy will apply.
• The fee applicable to the deferred student will be as per prevailing fee for the batch student as opted to defer to (No additional deferral fee is required to be paid).

2nd Deferral Policy: (Post Programme Commencement) 

• If a student is facing severe issues in dedicating time to the course, we provide the opportunity for the student to defer to another batch.
• The student will be required to pay a deferral fees of 10% of the total course amount fee + Taxes if any along with the differential program fees between the two cohorts.
• The deferral request will be approved once the deferral fee is paid.
• Till this is completed, the student will be assumed to be continuing in the same cohort.
• The student has 7 days (including holidays and weekends) from the date of deferral request to make the payment of the deferral fee post which the deferral request will expire, and the student will continue as part of the current cohort.
• If the student completes the deferral payment, the student’s login will be disabled, the student will leave the deferred cohort and the student will start learning on the new cohort from the point of the last assignment that was graded in the deferred cohort. All grades and progress till that point will be carried forward as it is to the new cohort. For clarification, the grades of the graded assignments will be carried forward, whether the student had submitted these grading during the initial stage.
• The deferral can only be requested during the batch for which the student has enrolled is ongoing. Once the batch has completed, deferral requests shall not be entertained. For clarification, the batch completion here shall mean the “last grace deadline” as communicated by upGrad.

upGrad Learner Support

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

RSVP Movies is an Indian film production company & they are planning to release a movie for the global audience in 2022 and the company wants to plan their every move analytically based on the data.

riyamehta21/RSVP-Movies-Case-Study

Folders and files, repository files navigation, rsvp-movies-case-study.

Problem Statement: We have the data of the movies that have been released in the past three years. We analysed the data set and draw meaningful insights that can help them start their new project.We used SQL to analyse the given data and give recommendations to RSVP Movies based on the insights.