Create Netflix dashboard with Tableau in 30 minutes
ฝัง
- เผยแพร่เมื่อ 15 ต.ค. 2024
- Create Netflix dashboard with Tableau in 30 minutes
Link to download the dataset(Steps to download the file: when you click on download, you can see the raw data, you can select all, copy and paste than into a CSV file or text file within your local working directory.) : github.com/Dat...
Link to Tableau Public: public.tableau...
Netflix
Tableau for beginners
Tableau desktop
Netflix movies
Netflix TV shows
Netflix series
Netflix dashboard
data analysis
data analyst
data science
Netflix ratings
Data Science Road Map
Coursera plus - with Coursera plus, you will have unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs-all included in your subscription including popular Professional Certificates from Google and Meta : imp.i384100.ne...
Data Science Path:
1. Data Science Math skills - Duke University: imp.i384100.ne...
2. Inferential Statistics - Duke University: imp.i384100.ne...
3. IBM Data Analyst: imp.i384100.ne...
4. Python for Everybody: imp.i384100.ne...
5. Data Science Specialization - Johns Hopkins University: imp.i384100.ne...
6. IBM Data Science: imp.i384100.ne...
7. Machine Learning Specialization: imp.i384100.ne...
8. Deep Learning Specialization: imp.i384100.ne...
9. MLOps Specialization: imp.i384100.ne...
10. DeepLearning.AI TensorFlow Developer: imp.i384100.ne...
11. TensorFlow Advanced Techniques: imp.i384100.ne...
13. TensorFlow Data & Deployment Specialization: imp.i384100.ne...
14. Natural Language Processing Specialization: imp.i384100.ne...
15. AWS Fundamentals: imp.i384100.ne...
16. Practical Data Science on AWS: imp.i384100.ne...
Get certified from Google:
1. Google Data Analytics: imp.i384100.ne...
2. Google Business Intelligence: imp.i384100.ne...
3. Google Advanced Data Analytics: imp.i384100.ne...
Get certified from Meta:
Meta Database Engineer: imp.i384100.ne...
Disclosure:
I may receive a commission if you click on and purchase from one of the links above.
Man. I came back just to comment. Unemployed for 6 months and I was hired from presenting this exact dashboard. I owe you a beer or something. 🍺 Thank you so much!
Congratulations 🎉🎉 really happy for you
Bro can u tell where i find this netflix CSV file
What job profile & your salary ??
@@oxygenyt7057 it’s in the job description.
@@lokeshpathak780 Business Intelligence, Metrics Analyst, 85k
This channel is top tier of all the data channels. The depth of your skills are unmatched. Do more on promoting the channel! Thank you for sharing your skills.
Hello!! Thanks a lot for this amazing feedback!! So glad to help :)
i’m doing a project based on my netflix viewing history, so this is perfect . thank you!
Wow!! You've made it look so easy yet such minute details have been put into consideration. By far one of the best tutorials I've seen. Thank you for helping us. ☺️ Much appreciated!
Wow, I have no idea how this channel came up as a selection but I am overjoyed that it did!!! I just created this beautiful dashboard as my first portfolio project. I am looking forward to tackling the Netflix project using Excel on your channel as well. Thank you so much.
This was a nice project. I’ve never used tableau before, but I like how simple it seems to be.
1:28 Total by year
5:26 Total by country
8:14 top 10 genre
11:00 distribution
13:40 ratings
16:00 description
18:38 date added
19:08 duration
19:36 rating
20:06 release year
20:40 genre
22:05 dashboard
This was the comment i was looking for, but how do you filter by year?
@@alinemath5030 click on date icon in tables --> change type to 'date' --> add date to columns --> open drop down menu and select year
This is the easiest tutorial.I am a beginner and I found it very easy to follow. Thank you so much. Definitely subscribing
My first time experiencing Tableau and I understood it so well.
Thanks a lot for the video.
I am facing problem in first sheet.When you add Date Added to column Year functon comes on its own.How does that happen?? Please explain
The thing is that we need to first change the data type to date and select Year :)
may I ask how did you get this data? i would like to get the updated version.
Hello, you can find the dataset on kaggle
Such a fantastics video! Clear step-by-step instructions; for a beginner but detailed to make us a professional! Thanks!
You gotta love Tableau, it's so easy to navigate, Top tier data visualization tool! Also this tutorial is super fun to follow along with, thank you sir!
I’m doing a final project based on netflix viewing history. Thank you so much! you save my life :)
hi i am also doing a same project, can u help me with it? please reply
Brother keep uploading great dashboards I learned a lot of new things here.👏
sorry dear, why i cannot count the data show id being line chart such as on minutes 2;00. even though I had clicked measure count distinct it didn't show the chart at all it's empty do I have a failure when I'm converting the data set? please enlighten me
Ty I was affraid on ussing Tableau but this tutorial show me a lot in short time
Thank you for very informative walkthrough of the project. It was wonderful experience of learning. Would like to see more on tableau projects! Keep up the good work.👍
thank you for the tutorial. when i'm trying to add the year, it adds also the months, but in your video, it adds only year count. how can i fix this , i appreciate your feedback.
Great Work ⭐️ the first video I watched in your channel, I excited to watch all videos 🤩 thank you so much ❤
Awesome!! Thank youuu!
total movies & tv shows when right make spelling mistakes otherwise perfect on a worksheet. thanks a lot for this efforts i am from india.
I'm also an aspiring Data Scientist, love this content, do more videos on tableau dude!
Please explain how to download that raw file in our desktop... it's difficult for beginners..
Link to download the dataset(Steps to download the file: when you click on download, you can see the raw data, you can select all, copy and paste than into a CSV file or text file within your local working directory.) : github.com/DataScienceRoadMapDSRM/Tableau-Dashboards-info/blob/main/netflix_titles.csv
from where can i download the netflix data file
THANKS BUDDY ,THIS IS MY 1ST AMAZING VIZ THAT I COMPLETED THANKS
Hi great video and thanks for this amazing walkthrough and sharing.
And man I have a question, when I import the file to tableu, in types appear Movies, TV shows and William Wyler, how I can eliminate that name? can you help me pls???
Thank you! Actually, you can check the column of the types and remove the third name from the dataset that you copied from GitHub, you need to do some data cleaning in this case :)
what does country mean? is it the country of origin of the movie, director, or casts? because there is a lot of country in other tv shows and movies
You are a pure angel! Thank you for sharing this beautifully designed & explained Dashboard
Very well explained! Thank you so much!
Most welcome!! Thank youuu!
When I'm dragging 'Date Added' in columns section, it is not grouped as year, it shows individual dates. What to do?r
Hi, please convert the field to date first
We want more such dashboard. Please upload more dashboards sir its awesome
Thank you. I created this dashboard for the first time using this video. very helpful and precise content.
can you share the data set ?
@@ushaswinikotagiri4664 search in kaggle
can anyone share the data link? i couldnt load the data sheet that is given in description
How to publish this like we can see in your link?
Where can I have this Netflix file..?
Hi, thanks for this. quick one pls. The Added date from yours excluded the dates completely and just the years were projected on the visualization. I am not achieving that in mine. Kindly explain how I can change that. Thanks
Hi, once you select your date, you can choose 'year' if yo want only years, and 'exact date' if you want the date displayed as it is, normally this will work :)
@@DataScienceRoadMap Thanks 😘
@@DataScienceRoadMaphow to do that kindly reply cuz this is my first visualisation 🙂
Bro what is frontend and backend of this project please reply me bro
Yes sure! We can put it this way, backend is everything you do that the client will not see, all the data cleaning, for example creating calculated fields, parameters, how you format and so on, and the frontend is the final result which is in our case the dashboard, the dashboard is what you will present at the end. I hope I answered your question :)
How did you link Map to the rest of the sheets.... it is not working for me
Hi, did you apply the same filter to all the worksheets?
At the start, change the data type to "'string" for field Date Added
Could you please tell me how can I create a portforlio using these kind of dashbords ? What services/sites should I use to make a Data Analyst/Science portfolio?
Hello, you can create a profile on Tableau public and add all your Tableau projects there, for other tools, you can also use GitHub
@@DataScienceRoadMap Thank you for your kind reply,I wish to ask some questions about data filed,Is there any possible way to contact you other than youtube?
Sorry I don't use social media! I just use TH-cam! So sorry!
@@DataScienceRoadMap okay🙂,then guess I will ask it from here🤝
Hello Sir.. I have downloaded your dataset but in your data, the year option is only coming but in my dataset, the whole date format is coming how can we solve this problem?
Hello, please change the data type
How di you clean the data? There are so many blank cells in the sheet. Or you created the dashboard without cleaning excel data?
Actually yes I used the file directly since it was ready and there are some missing data but it is the only information available and it is enough to create the dashboard :)
This is a great overview and tutorial. I will definitely check out the rest of your content.
Thank youu @Lukas Zavlek!!
I am enjoying learning tabelau. Thank you for the good video!!
I have a question. If preprocessing of data is required, which tool is used to proceed? sql,python,tableau pred??
@@esz4666 it depends, but Pandas is very useful for data manipulation, check out this dashboard where I used Pandas and created a dashboard based on the resulting files th-cam.com/video/_RT32my9PRQ/w-d-xo.html
@@DataScienceRoadMap Thank you very much for your help!!
I completed this project. Thanks 👍
In the map sheet, total movies &tv shows, the count is not visible when I move the mouse cursor. What is the reason behind it? Pls help.
Hello, I did not understand the issue, did you create an action filter?
Please I’m attempting this same data set as a project work when I put in my date and shown Id(it makes me filter which I do) but the issue is it doesn’t show me a line chart. Is there a reason why??? Please assist
Hi!! How can i download the database that you are using??
Hi, please check description for the steps to download the dataset :)
hi, i have a problem, when I try to drag CNTD to label he do something (I don't know what) but it's all confuse the CNTD doesn't appear to me twice in the marks it's the not the same as in the video, how can I fix this?
Hi Lorenzo, date_added data type should be converted to date, then select YEAR(date_added), normally it should work :)
@@DataScienceRoadMap it does not automatically convert, what to do?
How did you directly get YEAR in ate Added? I'm unable to get it.
hi, please change data type first :)
How did you filter the date in year format in 1:41?
Hi, please convert first the field to date
That was an amazing project and you made it look so easy. Can you please share how did you generate the link for the project?
I am not getting red color in the marks field for colour option and more colors option is also not showing. Only for border and Halo,the more colors option is coming.
So please help how do i get red in the colour option
Hello, when you select the color, you need to select more and get it from there :)
Thank you for sharing simple tutorial to made beautiful dashboard, I am doing first time Tableau dashboard refer this video.. it's fun
tried downloading dataset to opens up as json how to fix this ?
Please check the description for the steps to download it:)
Can I do this dashboard in tableau public
Hello, yes sure 😃
16:35 can you explain this part? how did you get single type like movie in the "type" box? im getting multiples values inside the "type" box
Hello! For the filter you select 'select single value' instead of multiple values, you need to customize your filter :)
Amazing Bro. Thank you so much. Took me a few hours, but I got there in the end! Much appreciated.
Hi, can i know how do you download the datasheet? since it only appears as a raw data in text file format if I clicked the linked in the description.
@@arisyamanisya8443 Copy and paste the file into a teext editor and save it as a .csv file
Brother i am facing problem to put show id in row while i am going to out show id into row it ask something which doesn’t see in your video. Plea help me brother.
hey, the link is redirecting to the code. unable to download the dataset. Kindly provide the link. thanks.
Hello, yes sure, normally when you click on it it will forward directly to the csv file: www.kaggle.com/code/chirag9073/netflix-data-analysis/data?select=netflix_titles.csv
Hi this was great work! Could you share the source of where you got the data from? Thanks!
Thanks, available in the description
somebody help @1.44 sec what should i do to get year date for file. for me its showing every days with years
Please you need first to change the data type into date then select Year
really helped!
Can't change date to year only, month shows too
Please change data type first
I am not able to split the data you have shared .
Please help me to do that
I did not really understand your issue, did you download the file and followed the different steps?
Thank you. I followed along and now have a nice dash for my portfolio!
How did "date added" automatically sort as "Years"?.. It's not the same for me (MM/DD/YYYY)
When data format is date and you select Year then normally it should work :)
I want to know is it a live project will the data change itself time to time??
On my GitHub repository it is the same data and not live
not able to get the data, it is showing, we cant show the files that r this big😕😕😕😕😕😕😕 How to download thn?
Please check the description for the steps to download the data
thank you sir
it was very helpful course for me who just started learning tableau
Hey, I created the dashboard but after selecting the country I'm not able to see the respective values for ratings, genre etc.
Hello, please check the filters :)
How should we decide which values we should take to make the dash board
If you follow from the beginning to the end, most fields will be used
Hello i really appreciate this work but i could not download the csv files; i would like to help me get them and thank you
When you click on download, you can see the raw data, you can select all, copy and paste than into a CSV file or text file within your local working directory:)
@@DataScienceRoadMap Aaaah thank you very much
I hope you're gonna be well
ur the great sir I never show in this teaching like you ❤ ❤
How to get base data file to create this dashboard?
Link to download the dataset(Steps to download the file: when you click on download, you can see the raw data, you can select all, copy and paste than into a CSV file or text file within your local working directory.) : github.com/DataScienceRoadMapDSRM/Tableau-Dashboards-info/blob/main/netflix_titles.csv
For those who copy the raw data, just know you will have to clean up the raw data. This is good practice. That way when you import into Tableau it will work correctly.
Please, how do I copy the raw file into a useable sheet?
how to do this?
yea dude fucking found out and the end of the process that there were nulls and some guys' name in movie type
@@temitayoakins3961 copy and paste the raw file into an excel file. From there you have to clean it up with delimiters. You got change the parameters of each column after that. If you don't do this, it won't work with tableau.
@@ushaswinikotagiri4664 copy and paste the raw file into an excel file. From there you have to clean it up with delimiters. You got change the parameters of each column after that. If you don't do this, it won't work with tableau.
just wow, you have made it so easy. it's appreciable.
is this dataset available on kaggle if yes provide link please.
having an issue while adding the date. instead of year wise, I'm getting it month wise
You can select directly your field as year, or you can change it in the column section
Thanks a lot...i completed this
How can I make it so that I can filter the titles by individual genres? So the viewer can use it as a tool to filter and find what to watch based on interest.
You put genre in the filter and you select the different types
@@DataScienceRoadMap Since the titles can have up to 3 different genres, I would like to filter the genres so that I can find a show or movie based on just 1 or 2 genres. So if something was Comedy, drama, international, I could see the title when I filter it by any one of the genres. That way I can find it if I search for just "comedy" or just "drama".
@@dhwani2028 yes, actually this was the problem and also why I did not use it as a filter in the first place, if we split the string into separated words, then we get three columns, which is not accurate, one way is to rearrange the dataset using pandas for example and create the dashboard with the new dataset, but I used the dataset directly with the available information in it :)
Has the data been changed as I'm getting different results
Hi Roopesh, no, data is the same on my GitHub, but if you have downloaded the dataset from kaggle, maybe they updated it :)
@@DataScienceRoadMap ok thanks
Not able to download this dataset. Can someone pls help?
Hi, I just created a Github repo where you can find the file, if you cannot download it, display it as raw data and copy paste to your local space and save as csv :) link: github.com/DataScienceRoadMapDSRM/Tableau-Dashboards-info/blob/main/netflix_titles.csv
Interesting dashboard, going to prac this now😊
I got a huge data in my description I don't know why... Problem arise from 6th slide
Hello! Maybe you need to check your filters :)
Hi.. I've completed.. Thnqq so much... These are really really helpful... N I've noticed you replied comment individually.. These means a lot.. ❤️
Bro what should i do with raw data i dont what can i do with that data please help me i have copied the raw data but dont know what should i do next please help
Hello Saketh, once you have copied your data into a text file, save it as .txt or .CSV file, then you can start working by uploading the file into tableau :)
@@DataScienceRoadMap I got the data from kaggle anyways thank you somuch for the video I am 16 and I am planning to become data analyst so I am preparing portfolios from now itself(future planning) thank you bro ❤️
Brilliantly done! Super simple to understand & implement! Thanks for sharing this!😊
how can I download data?
I am a beginner and learning how to be a data analyst. It is an unrefined data so can anyone tell me how I can refine it and convert it into csv file so that I can practice.
You can select all the data and save it within your local working directory, or you can save it as .txt and use online converter from text to csv :)
hello, Datalink is working but not able to download
Please check the description for the steps to download:)
I can thank u enough. This is so beautiful to look at
how did he converted date added column to year of date added......can anyone please let me know
Hello Krishna, you need first to convert date added to date data type, then select Year
Thanks a bunch now I get it ❤
Kindly ignore my other comments for the same
Hi! Thankyou very much for this tutorial, I have learnt a lot :). I do have one question about the dashboard.
I create dashboard and add action whereby when i click on different region, it will show the corresponding ratings, distribution, top 10 genres and total movies & tv shows by years according to the region i select.
However the 'top 10 genres' chart would only show 7 genres when i click on united states region, 4 genres for Australia, 9 genres for India, and same issue for other regions. May I know what could be the reason for this?
the setting for dashboard -> action -> 'Edit filter Action' is run action on select, clearing the selection will show all values.
source sheets : Total movies and Tv shows by country
target sheets : the 5 corresponding sheets ( ratings, top 10 genres, etc)
Hello @Bunny31, thank you for the comment, the reason for this is that for the countries selected, this is the only information available in the dataset, it is not an issue regarding the dashboard or the filters!
@@DataScienceRoadMap but if i do change the filter to show the top 15 instead of 10 (at the top 10 genre worksheet) it actually shows more! so I'm pretty confused.
Australia from 4 genre become 6 genres
US from 7 become 9
India from 9 become 14
@@SwanBaby31 aah ok so you have added the country filter in the top 10 genre worksheet? Well since we want top N ... You should right click on the country filter that you have added and click on add to context, normally it should work
@@DataScienceRoadMap I added the country filter with setting "select from list", i have right click on the country filter and click on added to context. but nothing changed :(
@@SwanBaby31 I created the filter using the action and I found the issue! You see, when you create your action filter, you give it a name, in my case I name it "filter 1". Once you will apply it on the worksheets and among those you have the worksheet of the top 10 genre, you go to that worksheet, you will find in the filters a new filter called Action(Country) and you add it to the context
Thanks man but your accent killed my whole night 😂
Thank you! Looking forward for such tutorials :)
Thanks for this tutorial and walkthrough. You are doing a good job
Wow sir i make excat ditto dashbaord and learn a lot thnx sir for help
Very nicely explained...extremely helpful for beginners like me
Please upload more tutorials like this.
Easy to Follow and advance skills, thanks sir!
Amazing walkthrough. Thank you so much!!
Thanks Man ! You are great!!!