This project focuses on exploring and analyzing the Netflix Movies and TV Shows dataset using SQL. The goal is to extract meaningful insights about Netflix content such as movies, TV shows, ratings, genres, actors, and countries producing the most content.
Through various analytical queries, the project answers business-oriented questions related to Netflix's content library and viewing trends.
The dataset used in this project contains information about Netflix titles including:
- Show ID
- Title
- Type (Movie / TV Show)
- Director
- Cast
- Country
- Release Year
- Rating
- Duration
- Genre
- Description
- Date Added to Netflix
The main objective of this project is to perform exploratory data analysis using SQL and answer real-world business questions related to Netflix content.
Some of the analytical questions explored in this project include:
- Count the number of Movies and TV Shows available on Netflix
- Find the most common ratings for Movies and TV Shows
- List all movies released in a specific year
- Identify the top countries producing the most Netflix content
- Find the longest movie duration
- Analyze content added to Netflix in the last 5 years
- Identify TV shows with more than 5 seasons
- Find movies belonging to specific genres (e.g., Documentaries)
- Identify content without a director
- Find actors appearing in the most Netflix titles
- Categorize content based on keywords in the description
This project demonstrates the following data analysis skills:
- SQL querying
- Data exploration
- Data aggregation
- Window functions
- String manipulation
- Data filtering and transformation
- SQL
- PostgreSQL
- Data Analysis
- Dataset Exploration
- Netflix has a diverse library of both Movies and TV Shows
- Certain countries contribute significantly more content to the platform
- Content ratings vary depending on the type of content
- Some actors appear frequently in Netflix productions
- Keyword analysis can categorize content based on themes
- Perform visualization using Python or Tableau
- Build an interactive dashboard
- Apply advanced data analytics techniques
- Conduct trend analysis across years