Netflix_analysis_SQL

Netflix Originals Data Analysis: Exploring Trends and Insights

Objective:

The objective of this project is to analyze the Netflix Originals dataset using MySQL queries to extract meaningful insights and trends. By performing various SQL operations such as GROUP BY, HAVING, ORDER BY, LIMIT, JOINS, WINDOW FUNCTIONS, and SUBQUERIES, participants will gain hands-on experience in data analysis and be better prepared for data analyst job roles.

Dataset:

Netflix_Originals Genre_Details

Datasets Description:

1. Netflix Originals: This dataset contains information about Netflix Originals including title, genre ID, runtime, IMDb score, language, premiere date, etc.
2. Genre Details: This dataset contains information about genres such as genre ID and genre name.

Analyses to make:

• What are the average IMDb scores for each genre of Netflix Originals?
• Which genres have an average IMDb score higher than 7.5?
• List Netflix Original titles in descending order of their IMDb scores.
• Retrieve the top 10 longest Netflix Originals by runtime.
• Retrieve the titles of Netflix Originals along with their respective genres.
• Rank Netflix Originals based on their IMDb scores within each genre.
• Which Netflix Originals have IMDb scores higher than the average IMDb score of all titles?
• How many Netflix Originals are there in each genre?
• Which genres have more than 5 Netflix Originals with an IMDb score higher than 8?
• What are the top 3 genres with the highest average IMDb scores, and how many Netflix Originals do they have?