A TABLEAU PORTFOLIO PROJECT to showcase ADVANCED visualization skills
Вставка
- Опубліковано 8 лип 2024
- 🎉 Sign up to Pecan for free ➡︎ lp1.pecan.ai/data-prep-lp/?ut...
GET YOUR DATA JOB ➡ mochen.info/
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-por...
AI JOB QUEST: Change the way you apply to jobs ➡ mochen.info/ai-job-quest-lp/
PATREON ➡ / mo_chen
1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Project Walkthrough
04:38 Create a New File and Import Data
05:50 Average House Sales Price Line Chart
07:23 Map
09:40 Distribution of House Prices (Histogram)
11:37 Distribution of Bedrooms (Histogram)
12:52 Distribution of Bathrooms (Histogram)
14:05 View vs Condition Heatmap
16:37 Filters incl. Calendar Widget
19:58 Building the Dashboard
30:33 Publishing Your Dashboard Online
31:57 Outro
┋The project┋
Dataset ➡︎ github.com/mochen862/king-cou...
Tableau Public link for the dashboard ➡︎ public.tableau.com/app/profil...
Thanks so much for taking a little time out of your day to watch this!
🎉 Sign up to Pecan for free ➡︎ lp1.pecan.ai/data-prep-lp/?
Can your channel be set to auto translate?
I like your channel but I can't get auto translate to Indonesian.
looks like you should set it up in your channel's studio.
Hi Mo, I have just started my journey to become a data analyst and your videos have been super helpful. Especially this one as I had no experience in tableau, but your explanation and guidance in this video was simple and easy to follow, it made a seemingly daunting task seem easy to do. Thank you
Hi Mo! I just wanted to say thank you for taking the time of your day to create a tutorial on how to design a beautiful dashboard. I learned so much and can't wait to use what I learn for my future projects.
This is SO GOOD! Thank you!!
Awesome Mo! Thank you so much for this video. Explained very well and helped me understand more functions of Tableau!
among the clearest tableau tutorials I've come across. I felt creating something interactive would be more challenging, but you made it seem quite easy. Thanks!
Glad it helped! Thanks a lot for watching 😁
Thanks so much for the help Mo! I've been looking for a quality step by step Tableau project. I've been wanting to learn how to use it and make a project to learn better. This was BY FAR, the best tutorial I've found! Extremely thorough and helpful. Just published it to the cloud!
Nice, great to hear you liked the video!
thank you for the video!!
Thank you for good quality video. This is a great starting point for Tableau Portfolio!!
Thanks a lot for this. You made it soo easy to follow.
Thank You So Much This was Awesome
Thank You... You made my day
I try my best! Thanks for watching!
Mo thanks for the video, one thing I found was that some distribution of bathrooms on the x-axis would start with 1.8 instead of a whole number. I wasn't too sure how to fix it on the graph so I left it as it is. Maybe check the data and see why some bathrooms start with 1,8 :)
Thank you so much for this awesome tutorial. Glad to come across your channel.😁
Thank you for this perfect, sense-making tutorial. Everything explained clearly and simply. Helped me out a lot!
Glad it helped! Thanks for watching 😃
Hi, Mo! Thanks for tutorials. Please add more videos on creating interactive dashboards in Tableau.
Your video was very thorough. I’m a super novice so I appreciate something with no ambiguity. Thanks
Glad it was helpful!
Thank you so much Mo! I am a complete beginner, and this was super easy to do and grasp!
Glad it was helpful! Thanks a lot for watching 😃
Damn man...i learned more with your video than my university courses....periode. Great work so far! Keep going u rock !
That's great to hear! Thanks a lot for watching 😁
Excellent video. Thank you Mo! My first Tableau public project to my portfolio and I am proud of it.
So you should be! Well done 😃
Hi Slinqee, I'm trying to start a porfolio, and read your comment, so do you follow @mo-chen step by step and you put this dashboard he did into your tableau public as your first practice? i hope not bother you with my question
Concise but on point learn a lot from this video. Thanks for making this tutorial
Thank you Mo for this wonderful tutorial. The copy formatting is a game changer for a beginner like me! Appreciate it :)
Glad it was helpful! Thanks for watching 😁
Just Built my first Tableau Dashbaord, cannot thank you enough
Glad you found it helpful!
Just what i need Mo! really thank you, i'm doing my first project and the map implematation was what i need to understand!
Great, I’m glad you liked it! Thanks so much for watching 😃
Excellent content
Awesome tutorial. I was able to follow your thought process from the beginning to the end. Thank you!
Glad it was helpful!
Thanks Mo, more dashboards please
Thanks, Mo! Your video helped me a build my first project on Tableau
Fantastic! I’m so glad to hear this 😃
Mo, that was absolutely helpful.
Thanks a lot!
Great video - as always!
Glad it was helpful 😄
Extremely helpful! Thanks!
Glad it helped!
Thankyou so much Mo for this tutorial. I have watched almost videos of yours they are very informative . Adding this tableau projects in my portfolio.!! :)
Glad it was helpful 😄
Great one!
Nice one mate! I'm glad you liked it.
Thanks Mo!
it was a very pleasant and refreshing exercise!
Glad you enjoyed it!
Thank you so much for this tutorial. Subbed.
I'm glad you liked it! Thanks for the sub 😃
what a neat way to make a calender filter. Thanks!
I'm glad you liked it 😁
Well documented and explained. Thank you so much for this tutorial.
Glad it was helpful!
Hello Mo, I just started Googles Data Analytics course today!! however i have been watching your videos for the last 2 weeks as i was looking for someone in the Data analytics space that hopefully would demonstrate portfolio projects. How lucky was i to find your channel!
Great to hear you like the channel! I wish you all the best with your data journey! And life in general 😁
Excellent instructor!
Glad you think so!
It seems Purple is your Favourite Colour 😜
Haha I do like purple yes 😃
Really wonderful and interactive viz. Just replicated it from your video, learned a lot by repeating all the steps, even after taking courses for tableau
Wonderful!
Purple is my fav color too!! Thank you Mo… so informative as usual ❤
Thanks a lot for watching 😃
Thank you! This was really well done and clear to follow for beginners : D : D
Glad it was helpful! Thanks so much for watching!
Hi Mo, if you could translate into sql what the tableau does with every command you do and every change on the screen, it will be possible to understand more deeply how the software works and you will show a very high level of the way the tableau works? If possible, also explain the relationship of the columns and the content in the columns and why the data changes as it does after the changes you make.
Let's take for example when you pull a certain field and put it in column or rows and then there are changes in the display if you can explain why the software displays what it displays or what action the software does in order to display what was displayed as a result of the action you did in the tableau environment.
Thank you, I hope I was understood
Hey I appreciate the content man. I only discovered data analytics in my last year of my bachelors in business marketing, so I only have a minor's worth of experience... I actually did lots of assignments and projects in tableau and sql, but they were very guided. I've been trying to apply to DA jobs but have come to terms with the fact that my resume is not up to par. I've spent all of 2023 so far getting my hopes up for jobs and interviews only to get rejected every time. So since then I've been taking certificates and such but its very surface level and I feel like my skills have been going to waste. So I'm finally trying to make a portfolio because I feel like I need repetition and hands on instead of following a course.
I've been sitting for hours trying to come up with my own project but I find it very difficult. I tend to find it very hard to mentally connect the steps. For example I'm not sure of what the "flow" is from SQL to Excel to Tableau or when its best to use which one and for what purposes. I tried to come up with my own large scale project, using SQL to build a database before importing everything into Tableau, but I found it overwhelming. I guess I'm good at doing specific things in SQL and Tableau but I lack a lot of the big picture context and structure, so when I'm just sitting in front of a dataset trying to find a direction to go down I feel kind of lost. It sort of feels like when there's a word on the tip of your tongue but you can't remember it. I feel like I'm so close to seeing what I need to but I just can't.
My question is would you recommend doing smaller projects showing individual showcases like your channel suggests? One project for SQL, one for Excel, one for Tableau, etc.? Or a large scale project that shows combination of skills?
Do you think you could make a project concept showing a scenario where you combine multiple things from start to finish? Like finding a dataset online and going through your process of drawing a project out of that?
Thanks man. Watched your video of a day in the life of a Data Analyst and it looked like my dream life. I just unfortunately am a long ways off from there.
Hi there 👋 I'm glad you like the content! To answer your first question - when you're just starting out with projects, I'd suggest you do smaller ones so you actually get to finish them and do a good job and feel good about it 😁 On your 2nd question, I have a couple end to end analysis / project videos on my channel already, feel free to check them out. The videos will walk you through everything from start to finish. And don't give up and keep working hard, and try and enjoy the process 😄 Remember that it took me many many years to get to where I am right now, it wasn't just handed to me. I studied, learned and worked hard consistently for a long period of time!
hey man, i can totally understand your pain, because I am in the same place, I spend to much time in learning Python, SQL, Probability and stats, and ofcourse tableau, Now i really want to do more projects as much as possible.
Thank you Thank you!!!!
Thanks so much for watching!
Terrific video!
Thank you, I’m glad you liked it!
Hi,Thanks for the tutorial I really enjoyed it 👏 and I added the evolution of the Sqft through time and a filter with zipcode.I have a problem with the bedrooms, I don't know why I keep on getting 212 houses with 0 bedroom 🥲 our graphs are similar but I have a lag.
Thanks for this wonderful piece, more of Tableau projects please 💪✅.
I’m glad you liked it, thanks a lot for watching!
Hey Big Mo, thank you very much for this video. I was waiting for your Tableau video. NYC
Thanks a lot for watching 😃
Thanks man.
I'm glad you liked it, thanks for watching!
THANKS A LOOOOOOTTT!!!!!
I'm glad you liked it 😁
Amazing work MO
I'm glad you liked it, thanks a lot for watching 😁
Dear Mo, thank you so much for this tutorial it makes perfect sense!! I'm able to follow through & replicate your dashboard and use map as an additional filter for the 4 worksheets (heatmap, distribution of housing prices/bedrooms/bathrooms). For my own practice, I would like to pick another dataset that can do similar things like this one, do you have any recommendations?? Thank you again for devoting your time and energy on this, amazing Mo!!
Kaggle is a great place to find datasets. I'm glad you liked the video, thanks a lot for watching 😄
Now you are my fav Mo!! Keep motivate us. Lots of love
Thanks so much for the kind words and for watching 😃
Thank you for such an informative lesson for beginners. I have a question, is there a way we could add the Map as filters and make it more interactive? Any help would be appreciated.
Again, such an informative video...could you please make a video on real life projects or work of data analyst..that will give us an overview on how many topics we need to cover in every module to become a good data analyst ..
Thanks again for this video..much love and support 🙏❤
Thanks a lot for watching! I made a video on how to build your portfolio recently, make sure to check that out 😄
Hi, thanks for sharing your great work. In the sheet "calendar", What's the deal with the 'year' in the data? We already have 'Yr built,' right? In the square table, what do you want to tell with relationship between year and price?
Hey, great vid. Whats the software called that showcases your mouse and blurs the background? Great for showcasing, thanks.
Hello,
Thank you for valuable tutorial.
May I know how can I ask the user to input the date when the hardware is changed. But that date is not used to filter the display graph. It is just to record for hardware information and later how can I retrieve that user input date information? Is it possible to store in one of the database's tables? The database was the one that I previously connected for the visualization purpose.
That was awesome!!!
Thanks Mo!!!!
Waiting for more.
A quick question is this a beginner or an intermediate level project?
Definitely intermediate because of the calendar widget 😃
Hi Mo Chen, I enjoy your videos and I'm really amaze with your story too, it's inspiring 💪🏼 ok here's my question, you have a workbook with cases with tableau, for example, and I want to know if it's ok to replicate one of your analysis in order to practice and have something on my portfolio, please advice me? Thanks a lot for your content!
Thank you for the video
The data set posted in the video description is not complete. Please can you check it out
hi! great video!! I was working on a dashboard where I have month on month graph. Is there a way to put a filter for dates? so say, I select dates from 1 to 10, and the month on month graph will show graph for first 10 dates only for every month.
Hi Sir, thanks for such a great video. Could you please share the dataset for this tutorial? I want to follow with dataset. Thanks again
@mo-chen
How is date for the line chart done the way you have shown.
I am not getting the drop down box?
Please help
Hey Mo, can you make a video on how Data Analytics is used in Finance domain? Would be very helpful :)
Great idea, I put a note for myself!
Hello Mo, Thank you so much so this step by step video tutorial. It was really helpful and I am surprised on how easy it is. But of c, with a little more practice (for me). Um, quick question,how do i publish or share my dashboard to the server? I tried that amd it says i should sign in to Tableau server through tableau cloud? I don't remember seeing a link for that when i activated it on my desktop. How do i get the link to my Tableau server
Underrated Guy
Thanks 😃
my inspiration@@mo-chen
Great and amazing video 👏 Would you please also do a power bi project?
I'm glad you liked it! I don't think I'll be creating Power BI projects anytime soon as my preference is Tableau which is why I chose this BI tool on this channel 😃
After the tableau project is done, is it possible I can put in Powerpoint without losing all the dynamic visualization? What if I want to put in youtube with password to send to somebody to watch when I accomplish my future tableau learning.
Very thorough tutorial ! Thank you !
This is usually done after data cleaning in, say jupyter notebook, correct ?
Yes, data visualization would be the last step. And yes, you could clean your data in a Jupyter notebook using Python. Thanks a lot for watching 😁
Suggestions for other data sets to make a similar dashboard with?
We'll done mo👍🏼 doing really great job ❤️can you show the python one also
Thank you! There will certainly be more Python stuff coming as well 😃
You must have loved the purple iPhone
Haha I do actually have a 'Deep Purple' iPhone
Hi Mo. I have a data set which shows the data in 5 year intervals so when I try and display the data in a line chart it shows huge peaks and troughs where the data is missing for the 5 year intervals. Do you know how I can show the trend over time accurately? This is in tableau also.
You could show average values and opt for longer intervals like quarters for example. Thanks a lot for watching!
Hi Mo, appreciate the content! May I know if you will be keen to do tutorials on numpy and pandas in the near future?
I'm glad you like content! I will for sure have more Python videos coming and I will try my best to focus more on pandas and numpy. Thanks for watching 😃
Can anyone please tell me about the key highlights and the things that are covered in this project in some brief amount of words to post this on LinkedIn
how do i grab finalize dashboard? pls help
Hi Mo, I love your content and thank you for this amazing guided project. If someone actually creates this project, Is it okay for the person to send it to you? Just for a quick review.
If you create the exact same thing, then please just compare it to the dashboard I created in the video. If you come up with something different, feel free to send me a link to it using the contact page at datawithmo.com/ 😁
Can someone explain at 25min, how did he drag and dropped the dashboard
Dear Mo, where did you source the data from?
I have a question about the Bedrooms and Bathrooms Histogram, the number of bedrooms (bathrooms) should be interger, right? it's like 1room, 2 rooms, 3 rooms. How to Bins the data to show that interger
You can easily create your own custom bin sizes by right clicking on your measure and clicking create bin 😃
Thank you for making this video! Really enjoyed watching it. Is there any chance you can share where you got this data (like Kaggle link)?
I'm glad you liked it! The link is in the description box 😁
this is a fantastic tutorial but several options were not available to me, is it because I am using the free tableau version?
I'm using the free version of Tableau as well here. Maybe you're not using the latest version? We have a discord community where you can ask questions like this one and connect with others discord.gg/gYVBVrMh 😃
Hey Mo, how did you drag your finalized dashboard at the end ?
Hi there 👋 I’m not sure what you mean by dragging the dashboard. Could you please rephrase your question?
Nice information vid but also you are crazy handsome !
Thank you 😃
I've never seen a filter of this sort, I can't wait to make use of it! How do you get inspiration for dashboard styles like this?
Thanks, I'm glad you liked the video 😁 I get a lot of inspiration from looking at others' dashboards and visualizations.
How did you collect this data? I'm looking to create a dashboard like this for the Orlando and Miami areas
kaggle
I cannot find the link to the dataset can anyone help @mo Chen
It's in the video description
when I am changing the month, my graphical representations are not changing. Please help anyone.
Hello Sir.can you please create a detailed video on advanced Excel .
Hi there 👋 I recently made an advanced Excel Portfolio Project video here ua-cam.com/video/m13o5aqeCbM/v-deo.html&ab_channel=DataWithMo. Hope this helps 😃
Hi Mo- my filters are not working. I can’t get the step at 25:27 right.
It’s hard to tell why the filter isn’t working without seeing your actual workbook. Please try the entire project again from scratch. If you follow the steps exactly, everything should work.
Hi mo! Can you do it again but on power bi?
Hello 👋 I’m not entirely sure when I’ll get to make this video as I primarily focus on Tableau on this channel
Hello sir, i want to ask you about this PC : HP elitebook i5 8th 830 g5 , 16g RAM 256 SSD, if it is good to buy or not ?
I'm a beginner web development learner, i wanna learn this domain and everything related with, also graphic design and videos editing
It's good enough to start with for sure. It won't be a powerhouse but it'll certainly do what you need.
how connect data source tableau from API webservices?
usually, i has export database to excel and connect tableau
Superb. Thanks alot.
but not able to download dataset please provide a working link from where I can download
I'm glad you liked it! You can download the dataset using the link in the description 😃
how to download this data file?
Hello, brother
I'm from India pursuing bsc mathematics hons and currently in 3rd year of college and I want to become a data analyst therefore I have been enrolled in a full stack data science bootcamp from ineuron which is online course.
Right now, I have learnt python, statistics, EDA and features engineering so can I start applying for jobs or start taking freelancing project or need to learn complete machine learning first.
Please provide your guidance if possible 🙏
Great to have you here on the channel! Please check out my website that has a bunch of learning materials at datawithmo.com/. Thansk a lot for watching 😃
Do you think data analyst jobs will be done in 5 years because AI?
No, but AI will definitely reshape the role of the data analyst. Thanks a lot for watching 😃
please how can i get power bi for my pc
Try this link powerbi.microsoft.com/en-us/desktop/ 😃