Project Overview
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. The following description provides a detailed account of the project's objectives, business problems, solutions, findings, and conclusions.
Objectives
- 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.
Technologies Used
- SQL (PostgreSQL)
- Data Cleaning & Analysis
- Business Intelligence
Key Findings
- Identified the distribution of movies vs TV shows.
- Determined the most common movie ratings.
- Found the longest movies and categorized content based on keywords.
Source Code & Dataset
GitHub Repository: Netflix SQL Project
Dataset: Kaggle Netflix Dataset