Netflix Content Strategy Analysis
The Business Problem
The Content Strategy team needs to know if they are producing enough 'TV-MA' content for international markets and whether the average duration of movies is dropping over time.
Project Overview
Netflix relies heavily on data to decide which movies and TV shows to produce. In this project, you will use Power BI to analyze a massive dataset of Netflix's historical catalog. You will build an analytical report that reveals the shift from movies to TV shows, geographical content dominance, and rating distributions.
Step-by-Step Implementation
Follow this structured path to complete the project successfully.
Step 1: Import via Power Query
Connect Power BI to the CSV file. Split the 'Cast' and 'Listed In' columns by delimiter into new rows to properly normalize the data.
Step 2: Data Modeling
Create a Date Table. Establish relationships between your main fact table and dimension tables (Countries, Ratings, Genres).
Step 3: DAX Measures
Write DAX formulas for 'Total Titles', 'Percent of Total by Type', and a moving average of release years.
Step 4: Report Design
Build a dark-themed UI matching Netflix's brand. Add a dynamic title and interactive KPI cards.
Expected Output
A multi-page Power BI report with a dark, sleek aesthetic (Red/Black) that clearly shows the explosion of original content from 2015 onwards.
Common Mistakes to Avoid
More Intermediate Projects
HR Employee Attrition Tracker
Write complex SQL queries to extract employee trends and build a Tableau dashboard for the HR department.
View Project
E-Commerce Database Optimization
Take a chaotic e-commerce dataset, normalize it into a star schema, and write performance-optimized SQL queries.
View Project