1 of 31

IMDB Movie� Analysis

Project By

Abhash Kumar Padhy

2 of 31

CONTENTS

  • Introduction
  • Project Description
  • Approach
  • Tech-Stack Used
  • Insights
  • Results

​

3 of 31

INTRODUCTION

  • IMDb movie analysis project is a data-driven exploration of the movie industry using data from the IMDb database. This type of project typically involves collecting, cleaning, and analyzing data from IMDb to gain insights into various aspects of the movie industry.

​

  • IMDb movie analysis project is the process of using data from the IMDb database to gain insights into the movie industry. This can include analyzing trends in movie ratings, popularity, and genre, as well as the performance of individual actors, directors, and studios.

4 of 31

PROJECT DESCRIPTION

  • The project is used to help to understand how IMDB movie analysis works with data. Making use of unstretched data into meaningful insights through data.

​

  • These data can be used to data cleaning and visualize and get even more clarity in the bigger picture. This data will help to understand the factors that contribute to a movie's success.

5 of 31

APPROACH

  • To execute this project firstly I am understanding the dataset that is given to me and then I am using the Excel for clean the data and then using MySQL for writing my SQL queries as question is asked to achieve the result.

​

  • Then I am run the queries in the MySQL workbench, if there is an error then I modified for the correct result.

6 of 31

TECH-STACK USED

7 of 31

INSIGHTS�

  • While making this project I learnt about the Excel, how to implement the clean data and as necessary remove null values and duplicate values.

​

  • While making this project I learnt about the SQL, how to implement the queries, how to implement the queries and about the various in built functions that can be used to get the data.

​

  • The insights gained from the project can be used by industry professionals, filmmakers, and movie fans to better understand the movie industry and make informed decisions about what types of movies to watch, produce, or invest in.

​

​

​

​

​

​

​

8 of 31

RESULTS�

A. Clean the data:-

​

  • Dropped 14 unwanted columns from the dataset
  • Cleared all the null values and duplicates
  • Reduced 5044 data to 3724
  • Deleted Blank cells

9 of 31

  • OUTPUT:

​

10 of 31

B. Find the movies with the highest profit?

​

SQL query;

​

11 of 31

OUTPUT:

​

12 of 31

C. IMDB Top 250 and its ranking:-

​

SQL Query;

​

13 of 31

  • OUTPUT:

​

14 of 31

  • Top Foreign Lang Film:-

SQL Query and Output:-

​

15 of 31

D. Find the best directors:-

​

SQL Query;

​

16 of 31

OUTPUT:

17 of 31

E. Find popular genres:-

​

SQL Query;

​

18 of 31

  • OUTPUT:

​

19 of 31

F. Create a new column of lead actors and their movies:-

​

SQL Query;

​

20 of 31

  • OUTPUT:

​

21 of 31

Charts:-

22 of 31

G. Find the critic-favorite and audience-favorite actors:-

Mean num_critic_for_reviews :-

SQL Query;

​

23 of 31

  • OUTPUT:

​

24 of 31

  • Charts:-

25 of 31

  • Mean of the num user for review:-

SQL Query;

​

​

26 of 31

  • OUTPUT:

​

27 of 31

  • Charts:-

​

28 of 31

  • Year Decade vs Number of votes :-

SQL Query;

​

29 of 31

  • OUTPUT:

​

30 of 31

  • Charts:-

​

31 of 31

THANK �YOU