Analyze your Netflix data in Power BI

Hi Friends,

My cousin’s were discussing what to watch in Netflix on last weekends, Which triggered me this idea to analyze Netflix for anybody with just few click to download data and analyze in Power BI.

Netflix Power BI Dashboard

YES Wait! Before you search how to get Netflix data just read following steps, I am going to explain how to get your Netflix data and you can analyze your downloaded data in Power BI.

You can achieve this three steps

Step 1 – Get Netflix Data

Step 2 – Get Power BI Desktop.

Step 3 – Get my Netflix Power BI Template and Analyze

Step 1 – Get Netflix Data

In this step we will learn how to Download your Netflix Data for Netflix website.

Click on link –


When you click on “Download all”, will download CSV file on your computer with file name – NetflixViewingHistory.CSV


I know you will be curious to see data, Go ahead and open file it will have only two column, Do not change heading column as Power BI template is dependent on this heading !

Title and Date which is actually Last Date on which you watched given title


Step 2 – Get Power BI Desktop, If you already know what is Power BI please skip this step and jump to Step 3.

To download Power BI click on link –, Install software.

You can follow installation instruction from this link –

Step 3 – Download Power BI template

Click on link to download Power BI template from Microsoft gallery


Downloaded Power BI template should look like this


Click to open this file


As soon as you open Power BI template file it will prompt to input CSV file you downloaded using step 1

image image


Click on Load, Let Power BI load CSV file


That’s IT ! you are ready to analyze your Netflix Data.

Netflix Power BI Dashboard

How to use this Netflix dashboard-

This is chart will keep track of all your filters


For example if I will search, My wife’s favorite season in search Box – “Heartland”


It will show Heartland has 9 Series of season and 158 Episode


Season analysis chart will give you more details about season


On top you will find all date demographics, Which will show how you watch those episode


You can search for on movies or for specific year by just clicking on following table


If you want know which day you watch most click on sort button on this chart


What is PBIT file – A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.

Few points you should know regarding Netflix data –

  • This is view history analysis, Netflix does not give you each activity of your watched, for example if you watch any episode twice you will get only one stats for this with last watched date.
  • Data will not refresh from Netflix, You have to download your own data, But you can download any time new file and provide new input to power BI template.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s