1 of 17

IMDB MOVIE ANALYSIS

By

Jipson o s

2 of 17

OVERVIEW

  • Project Description
  • Approach & Tech-stack used
  • IMDB movie Analysis
  • Insights
  • Results
  • Drive Link

IMDB Movie Analysis

2

3 of 17

PROJECT DESCRIPTION

This project is about the analyse of the given dataset which includes the collection of movies and their details. In this project, first, we will clean the dataset and will find the following

  • Movies with the highest profit
  • Top 250 movies based on their IMDB score
  • Top foreign movies based on their IMDB score
  • Top directors based on their IMDB score
  • Audience favourite genres
  • Audience favourite actors

​

​

IMDB Movie Analysis

3

4 of 17

APPROACH & TECH-STACK USED

After downloading the dataset, I imported it to my personal MS Excel and analysed what these columns and rows mean. First I clean the data which is removing duplicate values, dropping columns etc I answered all the Questions one by one using MS excel. I imported all the answers Like tables and charts from MS Excel to PowerPoint. I modified the tables and charts by increasing the font size and colouring the tables and charts to more engagement with the users more. The tech-Stack used for making this project is MS Excel(which includes pivot tables, charts, and functions), PowerPoint and Google drive.

IMDB Movie Analysis

4

5 of 17

IMDB MOVIE ANALYSIS

1. Clean the Data

In this process, I clean the data in the following order

  • Dropped the columns which have no use for the data analysis
  • Dropped the rows which null values
  • Removed the duplicate rows

IMDB Movie Analysis

5

6 of 17

2. Movies with the highest profit

​

IMDB Movie Analysis

6

7 of 17

budget vs profit graph

​

​

​

​

​

​

​

IMDB Movie Analysis

7

8 of 17

3. Top IMDB movies

​

​

IMDB Movie Analysis

8

9 of 17

3. Top IMDB foreign films

​

​

IMDB Movie Analysis

9

10 of 17

4. Best Directors

​

​

​

IMDB Movie Analysis

10

Director name

mean of IMDB score

Charles Chaplin

8.60

Tony Kaye

8.60

Alfred Hitchcock

8.50

Damien Chazelle

8.50

Majid Majidi

8.50

Ron Fricke

8.50

Sergio Leone

8.43

Christopher Nolan

8.43

Richard Marquand

8.40

S.S. Rajamouli

8.40

11 of 17

5. Best Genres

​

​

​

​

IMDB Movie Analysis

11

Genres

popular genres

Drama

153

Comedy|Drama|Romance

151

Comedy|Drama

147

Comedy

145

Comedy|Romance

135

Drama|Romance

119

Crime|Drama|Thriller

82

Action|Crime|Thriller

55

Action|Crime|Drama|Thriller

50

Action|Adventure|Sci-Fi

46

12 of 17

6(1). Audience favourite actor

​

​

​

​

​

IMDB Movie Analysis

12

Actors

Mean of num_critic_for_reviews

Brad Pitt

245

Leonardo DiCaprio

330

Meryl Streep

181

Actors

mean of num_user_for_reviews

Brad Pitt

742

Leonardo DiCaprio

914

Meryl Streep

297

13 of 17

6(2). Number of votes users per decade

​

​

​

​

​

IMDB Movie Analysis

13

14 of 17

INSIGHTS

  • Movies with the highest profit are The avatar, Jurrasic world, Titanic and so on.
  • Highest-rated IMDB movies are The Shawshank Redemption and the highest-rated foreign film is “The Good, the Bad and the Ugly”.
  • The Best directors are Charles Chaplin and tony kaye with an Average IMDB score of 8.60
  • Leonardo Dicaprio is the audience’s favourite character.
  • Most Popular genre is Drama.
  • Most Number of voted users in the decade is the 2000s.

​

IMDB Movie Analysis

14

15 of 17

RESULTS

This project helped me a lot by engaging with the Advanced PowerPoint features and I feel by completing this project my presentation skills are now really improved. Also, My skills in MS Excel improved by doing this project and also get a chance to engage more with pivot tables, functions, formulas and different types of charts/graphs. This project gives a good example of how to extract and clean data.

​

IMDB Movie Analysis

15

16 of 17

EXCEL WORKBOOK LINK

Open this worksheet in excel for the right visuals.

IMDB MOVIE ANALYSIS

IMDB Movie Analysis

16

17 of 17

Thank you��Jipson o s�jipson00716@gmail.com

IMDB Movie Analysis

17