This project explores Netflix's content catalog using SQL Server to uncover trends in content distribution, genre popularity, audience targeting, country-wise contribution, and platform growth over time.
The objective was to transform raw Netflix data into actionable business insights using SQL-based exploratory and analytical techniques.
This project aims to answer the following questions:
- What percentage of Netflix content consists of Movies and TV Shows?
- Which countries contribute the most content?
- Which genres dominate Netflix's catalog?
- Which ratings are most common?
- How much content is targeted toward Kids, Teens, and Adults?
- How has content production evolved over time?
- Which decades contributed the most content?
- Which directors have the highest number of titles?
- Which actors appear most frequently?
- How quickly has Netflix expanded its content library?
- Which genres dominated different release years?
| Metric | Value |
|---|---|
| Total Titles | 8,807 |
| Movies | 6,131 |
| TV Shows | 2,676 |
- Title
- Type
- Director
- Cast
- Country
- Date Added
- Release Year
- Rating
- Listed In (Genres)
- Aggregate Functions
- GROUP BY
- ORDER BY
- TRIM()
- Handling NULL Values
- STRING_SPLIT()
- CROSS APPLY
- Common Table Expressions (CTEs)
- DENSE_RANK()
- ROW_NUMBER()
- COUNT() OVER()
- Ranking Analysis
- Trend Analysis
- Running Totals
- Audience Segmentation
- Top-N Analysis
- Movies account for approximately 69.6% of Netflix content.
- TV Shows account for approximately 30.4%.
- Netflix's catalog is heavily movie-focused.
Top contributing countries:
- United States
- India
- United Kingdom
- Canada
- France
The United States dominates Netflix's catalog, while India has emerged as Netflix's second-largest content contributor.
Most popular genres:
- International Movies
- Dramas
- Comedies
- International TV Shows
- Documentaries
Netflix places a strong emphasis on international and drama-based content.
- TV-MA and TV-14 dominate the platform.
- Adult-oriented content forms the largest segment.
- Teen content is the second-largest category.
- Kids-focused content represents a relatively small share of the catalog.
Top Director:
Rajiv Chilaka — 22 Titles
A small group of directors repeatedly contribute content to Netflix's catalog.
Top Actor:
Anupam Kher — 43 Titles
Indian actors dominate the list of most frequently appearing actors.
Netflix experienced rapid content expansion after 2015.
Peak Growth Year: 2019
Approximately 1,999 titles were added during this year.
This period represents Netflix's most aggressive content acquisition phase.
International Movies dominated most release years, while Dramas frequently emerged as the leading genre in other years.
This highlights Netflix's continued investment in globally distributed content.
- Netflix is primarily a movie-focused streaming platform.
- The United States remains the largest content producer.
- India is Netflix's second-largest content market.
- International Movies and Dramas dominate the catalog.
- Adult-oriented content forms the largest audience segment.
- Netflix experienced rapid expansion between 2015 and 2019.
- Modern content from the 2010s dominates the platform.
- A small group of directors and actors appear repeatedly across the catalog.
Netflix-SQL-Analysis/
│
├── README.md
│
├── dataset/
│ └── netflix_titles.csv
│
├── sql/
│ └── netflix_analysis.sql
│
├── screenshots/
│ ├── 01_content_distribution.png
│ ├── 02_top_countries.png
│ ├── 03_top_genres.png
│ ├── 04_rating_distribution.png
│ ├── 05_top_directors.png
│ ├── 06_top_actors.png
│ ├── 07_content_growth.png
│ └── 08_genre_by_year.png
│
└── LICENSE (Optional)
B.Tech in Geoinformatics
Netaji Subhas University of Technology (NSUT)
- SQL Server
- Data Analysis
- Data Cleaning
- Exploratory Data Analysis (EDA)
- Window Functions
- Data Storytelling
- Business Intelligence Thinking
This project demonstrates how SQL can be used to transform raw data into meaningful business insights through data cleaning, exploration, trend analysis, ranking techniques, and window functions.