This initiative focuses on analyzing IMDb data to provide strategic recommendations for RSVP Movies, an Indian film production company planning a global release in 2022.

Problem Introduction: RSVP Movies, renowned for its blockbuster hits, is looking to expand its reach beyond the Indian audience. To ensure the success of their upcoming international project, data-driven insights are crucial. This project involves analyzing three years' worth of movie data to provide actionable recommendations.

Your Role: As a data analyst, you will leverage SQL queries to analyze the IMDb dataset and derive insights that will help RSVP Movies make informed decisions about their global release strategy.

Analytics Process: The analysis is divided into four segments, each designed to uncover significant insights from different combinations of data tables. Your role is to answer specific questions within these segments to meet the business objectives.

Data Set and Database Creation: 1. Download the IMDb Dataset: - Access the dataset and review the Entity-Relationship Diagram (ERD) and table details to understand the data relationships.

2. Inspect and Understand the Data: - Examine each table and its features to interpret the dataset effectively.

3. Database Setup: - Create the Database: Use MySQL Workbench to execute the necessary DDL and DML commands. - Data Loading: Alternatively, download the SQL script file with all commands and data to streamline the process.