A Simple Way to Explore the Netflix Content Using Tableau

Sruthi Narapareddy
The Startup
Published in
4 min readAug 10, 2020

--

photo from https://www.pcmag.com/reviews/netflix

Are you struggling to perform EDA with R and Python?? Here is an easy way to do exploratory data analysis using Tableau.

Lets Dive in to know the process and look at the analysis !

Introduction

Netflix is the world’s leading internet entertainment service with 158 million paid memberships in over 190 countries enjoying TV series, documentaries and feature films across a wide variety of genres and languages. I was curious to analyze the content released in Netflix platform which led me to create these simple, interactive and exciting visualizations with Tableau.

Data Source
The dataset used in this EDA project is taken from Kaggle. Click here to download the data.

Data Description

Data has 12 columns which include show id, title, type, director, cast, country, release year, description, rating and genre of the movies/TV shows. Type column gives if each record is a movie or Tv show. Country column has all the countries a movie or show is released. Each movie or show belongs to one or more genres which is mentioned in the genre column separated by commas.

Data Transformation

In order to visualize top genres or country wise releases, the existing data has to be transformed. We don’t require any coding experience to do this. A simple understanding of Alteryx tool creates a pipeline to transform the data. Lets break down the transformation to 2 steps.
Step 1: Convert the text in country and genre columns to multiple columns.
Step 2: Transpose the columns to get a record for each genre or country.

See below, the screenshots of the workflow and data sample before and after transformation

Data Transformation workflow in Alteryx
Data before transformation
Transformed Data

EXPLORATORY DATA ANALYSIS

  1. Movies vs TV shows

Netflix platform even has the content which was originally released in 1965. For a better visual I have only displayed the releases from 2000. We observe that initially the percentage of movies is higher than TV shows but from 2019 Netflix has started to focus more on TV shows.

2. Country Wise Releases

United states has most total releases ( both movies and TV shows) followed by India and United Kingdom. The interactive dashboard is present here with dynamic parameters to see top N countries of highest releases.

Tree map showing the Top 10 countries w.r.t to no. of releases

3. Top Genres in Movies vs Tv shows

Movies and Tv shows are predominantly focused on international, dramas and comedies.

You can see below the top genres in each category. Click here for movies and here for Tv shows to interact with the chart and see the top N genres in each year or range of years.

Top Genres in Movies ( left) vs Tv shows ( right)

4. Country wise releases of each category
Both the categories has good presence in United states, India, and UK.

Releases per country for each category

Can access the complete dashboard from this link and Alteryx workflow is available on my GitHub

Conclusion

Netflix has major presence in United states and India. Its focus has shifted recently towards TV shows which was previously on movies. More TV shows released than movies.

--

--

Sruthi Narapareddy
The Startup

Data Science and Analytics professional with 2.5+ years experience in programming. Currently, pursuing masters in Business Analytics from UIC.