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 – https://www.netflix.com/viewingactivity

image

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

image

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

image

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 – http://bit.do/pbidownload, Install software.

You can follow installation instruction from this link – https://docs.microsoft.com/en-us/power-bi/desktop-get-the-desktop

Step 3 – Download Power BI templatehttp://bit.do/pbinetflix

Click on link to download Power BI template from Microsoft gallery

image

Downloaded Power BI template should look like this

image

Click to open this file

image

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

image image

image

Click on Load, Let Power BI load CSV file

image

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

image

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

image

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

image

Season analysis chart will give you more details about season

image

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

image

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

image

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

image

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:

WordPress.com Logo

You are commenting using your WordPress.com 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