NETFLIX_SQL
Project
By Arkatava Saha
This project involves a comprehensive analysis of
Netflix's movies and TV shows data using SQL.
The goal is to extract valuable insights and answer
various business questions based on the dataset.
This PPT provides a detailed account of the
Project Overview
project's objectives, business problems, solutions,
findings, and conclusions.
Project Objective
Analyze the distribution of content types (movies vs TV shows).
Identify the most common ratings for movies and TV shows.
List and analyze content based on release years, countries, and
durations.
Explore and categorize content based on specific criteria and
keywords.
Database Schema
Solved 15 real life Business Problems
1. Count the Number of Movies vs TV Shows
2. Find the Most Common Rating for Movies and TV Shows
3. List All Movies Released in a Specific Year (e.g., 2020)
4. Find the Top 5 Countries with the Most Content on Netflix
5. Identify the Longest Movie
6. Find Content Added in the Last 5 Years
7. Find All Movies/TV Shows by Director 'Rajiv Chilaka'
8. List All TV Shows with More Than 5 Seasons
9. Count the Number of Content Items in Each Genre
10. Find Each Year and the Average Number of Content Releases in India on Netflix
11. List All Movies that are Documentaries
12. Find All Content Without a Director
13. Find How Many Movies Actor 'Salman Khan' Appeared in the Last 10 Years
14. Top 10 Actors Who Have Appeared in the Highest Number of Movies Produced in India
15. Categorize Content Based on the Presence of 'Kill' and 'Violence' Keywords
Count the Number of Movies vs TV Shows
Find the Most Common Rating for Movies and TV Shows
List All Movies Released in a Specific Year (e.g., 2020)
Find the Top 5 Countries with the Most Content on Netflix
Identify the Longest Movie
Find Content Added in the Last 5 Years
Find All Movies/TV Shows by Director 'Rajiv Chilaka
List All TV Shows with More Than 5 Seasons
Count the Number of Content Items in Each Genre
Find Each Year and the Average Number of Content Releases in India on Netflix
List All Movies that are Documentaries
Find All Content Without a Director
Find How Many Movies Actor 'Salman Khan' Appeared in the Last 10 Years
Top 10 Actors Who Have Appeared in the Highest Number of Movies Produced in India
Categorize Content Based on the Presence of 'Kill' and 'Violence' Keywords
Conclusion
1. The dataset contains a diverse range of movies and TV shows with varying ratings and
genres.
2.Insights into the most common ratings provide an understanding of the content's target
audience.
3.The top countries and the average content releases by India highlight regional content
distribution.
4.Categorizing content based on specific keywords helps in understanding the nature of
content available on Netflix.
5.This analysis provides a comprehensive view of Netflix's content and can help inform
content strategy and decision-making.
GITHUB LINK
