This project dives into Netflix's global content library using MySQL and Power BI to uncover trends, insights, and patterns in the platform's vast collection of movies and TV shows.
To analyze and visualize the Netflix Titles dataset from Kaggle to answer key business questions, such as:
- Which countries produce the most content?
- What genres are most common?
- Who are the most featured actors and directors?
- What’s the range of content in terms of age, duration, and ratings?
- MySQL: Data cleaning and transformation, solving business queries
- Power BI: Visualizing insights and building an interactive dashboard
- Total number of Movies vs. TV Shows
- Top contributing countries
- Most frequent genres, actors, and directors
- yearly content addition trends
- Longest movie and TV show
- Top ratings
- Categorization based on content description (Love, Horror, Action, etc.)
- Categorize movie based on its duration
- Country-wise availability of both Movies and TV Shows
- Oldest and newest titles
- 🎥 Netflix’s library is ~70% Movies
- USA leads in content count, followed by India & UK
- 🧑🎤 David Attenborough is the most featured actor
- 🧑Rajiv Chilaka is the most frequent director
- 🎭 Drama is the most dominant genre
- ⏱ Longest movie: Black Mirror: Bandersnatch (317 mins)
- 📺 Longest TV Show: Grey’s Anatomy (17 seasons)
- 📆 Most content added in 2019
- And many more....
This project dives into Netflix’s vast library to uncover patterns in its global content. From identifying that around 70% of the content is movies to finding that the USA leads in total titles, the data reveals how Netflix structures its offerings.
We discovered David Attenborough as the most featured actor, Drama as the dominant genre, and 2019 as the year with the highest content addition. Insights like these show how data can tell the story behind what we watch every day.
- Dataset - Kaggle's netflix_titles dataset is used
- SQL Queries – Used to extract and manipulate data
- Power BI Dashboard – Visual representation of the insights
- Report (PDF) – Summary of findings and business insights
This project showcases how data analysis can transform raw information into compelling stories. By combining SQL querying with interactive Power BI visuals, we delivered actionable insights into Netflix’s content strategy.