This project transforms raw Netflix data into an easy-to-use, interactive dashboard using Power BI. It gives a clear, visual way to explore everything in the Netflix catalog—from movies and TV shows to where they were produced and when they were released. Whether you want to see which genres are most popular or track how Netflix's library has grown over time, this dashboard makes understanding the data simple and fun.
This repository contains the following core files and directories:
Netflix Dashboard.pbix: The main Power BI project file containing the data model and interactive visualizations.Tables_Dataset.xlsx: The raw data source file containing the tables (e.g., Titles, Cast, Categories, Ratings) loaded into Power BI for analysis.Dashboard Preview/: A directory containing screenshot images of the completed dashboard.
The foundational table containing high-level details for every movie and TV show.
| Column Name | Description |
|---|---|
| show_id | Unique identifier for each Netflix title (Primary Key). |
| type | Specifies the format of the content (e.g., Movie or TV Show). |
| title | The official name of the movie or TV show. |
| date_added | The exact date the title was added to the Netflix platform. |
| release_year | The original year the content was produced or released. |
| rating | The maturity or age rating assigned to the content (e.g., TV-MA, PG-13). |
| duration | Total runtime for movies (in minutes) or total seasons for TV shows. |
Tracks the actors involved in each title, allowing for granular filtering by cast member.
| Column Name | Description |
|---|---|
| show_id | Unique identifier linking back to the netflix_titles table (Foreign Key). |
| cast | The name of an actor or cast member featured in the title. |
Captures the directors responsible for the content.
| Column Name | Description |
|---|---|
| show_id | Unique identifier linking back to the netflix_titles table (Foreign Key). |
| director | The name of the individual who directed the movie or TV show. |
Categorizes the titles into specific genres and sub-genres.
| Column Name | Description |
|---|---|
| show_id | Unique identifier linking back to the netflix_titles table (Foreign Key). |
| category | The genre or category the title falls under (e.g., Documentaries, Thrillers). |
Maps the geographical availability and production origin of the content.
| Column Name | Description |
|---|---|
| show_id | Unique identifier linking back to the netflix_titles table (Foreign Key). |
| country | The name of the country where the title was produced or released. |
Houses the lengthy synopsis text, keeping the core titles table lightweight.
| Column Name | Description |
|---|---|
| show_id | Unique identifier linking back to the netflix_titles table (Foreign Key). |
| description | A short text summary or synopsis of the movie or TV show plot. |
The Power BI data model follows a relational structure optimized for analysis. At the center is the netflix_titles table, containing the primary details for each movie and TV show. Relationships are established using the show_id field:
- One-to-Many (1:*) Relationships: The core
netflix_titlestable filters thenetflix_cast,netflix_directors,netflix_listed_in, andcountries_releasedtables. This enables complex cross-filtering, such as finding all titles by a specific director or all actors within a specific genre. - One-to-One (1:1) Relationship: The
descriptiontable is linked one-to-one, optimizing performance by separating long text fields from the main attributes.
Power BI Data Model View
Overview Page
Single Movie/TV View Page
To explore this dashboard locally on your machine, follow these steps:
- Power BI Desktop: Ensure you have the latest version of Power BI Desktop installed.
- Microsoft Excel: To view or modify the raw dataset in
Tables_Dataset.xlsxif needed.
Thank you and happy learning 😃