Netflix Analysis Dashboard

Table of Contents

• Project Overview
• Data Sources
• Tool Used
• Data Cleaning and Preparation
• Exploratory Data Analysis
• Dashboard Features
• Key Insights
• References

Project Overview

---

This project aim to provide insights into the Netflix's catalog and provide an interactive visualization that helps users explore trends in movies and TV shows. Specifically, this dashboard helps in:

-Identifying the total number of titles, ratings, genres, and locations covered in the dataset.

-Understanding the top genres based on the number of movies and TV shows.

-Exploring the distribution of content types (Movies vs. TV Shows) using pie charts.

-Analyzing content ratings to see the most common audience classifications.

-Observing trends in Netflix releases over time using line/area charts.

-Visualizing the geographical distribution of Netflix content using a map chart.

Data Sources

Netflix Data : The dataset used for this analysis was sourced from Kaggle. It contains information about Netflix movies and TV shows including:

• Title
• Type
• Release Year
• Rating
• Country
• And other relevant metadata

Tool Used

Microsoft Excel - Data Cleaning, Pivot Tables, Dashboard Design Download here

Data Cleaning and Preparation

In the initial data preparation , I performed the following task:

1. Data loading and inspection
2. Handling missing values
3. Checking for inconsistencies
4. Data cleaning and formatting

Exploratory Data Analysis

EDA involved exploring key trends in the dataset, including:

• Distribution of content types (Movies vs. TV Shows)
• Genre popularity among Netflix titles
• Content rating distribution
• Release trends over the years
• Country-wise distribution of Netflix content

Dashboard Features

The interactive Excel dashboard contains:

• Pivot tables
• Insights into Netflix catalog, including movie and TV show trends
• Data visualizations to explore content ratings , genres and geographical distribution

Key Insights

• Netflix has a higher number of movies than TV shows
• Documentaries are the most common genre (298 titles)
  • Stand-Up Comedy follows closely (273 titles)
  • International Movies and Dramas are also among the most featured genres
• There was a significant rise in content production from 2010 onwards
  • The highest number of releases happened in the late 2010s, showing Netflix's rapid expansion
• TV-14 is the most frequent rating (1693 titles) , indicating a preference for teen-friendly content.
• The global heatmap shows Netflix content was widely distributed, with North America, Europe, and parts of Asia having a large share.

References

• Dataset Source : [Netflix Movies and TV Shows Dataset]
  • (https://www.kaggle.com/datasets/shivamb/netflix-shows) (Sourced from Kaggle)