case study / 02

IMDb Film Analysis

When I first started the project, I initially had one goal: to see the most popular genres in foreign countries. Since the last complete year in the IMDB file was 2021, I chose to look at 20 years of data. 2001-2021. The data itself came in .TSV format, yet had escape characters saved in the rows. Due to this, I had to convert the files from TSV to CSV and rid it of the escape characters so I could load it into DBeaver for SQL analaysis.

Next I looked at the genre category for the top movies, but I found that movies in IMDB can be assigned up to three genres. Unfortunately, IMDB doesn't rank which genre is most fitting. This means that multiple genres can fall under the umbrella of drama. Crimes, thrillers, fantasy, and more can all also be drama. This created a map with very little variance.

The full results can be found here: GitHub link

The Tableau story can be found here: View it on Tableau Public

Interactive Tableau story

Best viewed on desktop. If the visualization does not load, open the story on Tableau Public.

← Back to projects