19:34 for someone that cant see a seattle geographic, take a look at a bottom right of the map, tableau will tell you that there's "values that have unknown geographic location " you can click it and choose edit locations, and chose united states as a country, hope this help
man im gonna tell you sotry , and its mine and i swear its 100% true 3 months ago i decided to learn data analyst , i want to become freelancer so i choose data analyst as my skill , and i watched a lot of videos in youtube it was usefull but not that much i always has felling that something missing so i want to buy courses in udemy but as im still student and the currency in my country its not dollars so its hard for me to buy a course but the day i watched your excel tutorials it was a gift from god i knew with those beautiful tutorials you made im gonna be a data analyst thank you so much man you are a hero for me last thing my english is not good cause its my third language but due to your videos i progress in it so thank you so much man
This is awesome, thank you. Just a note - if you are not in the USA you might need to Edit Locations in the map settings to USA. In the Menu Bar click on Map -> then select Edit Locations -> and change the Country/Region to USA.
Alex, you are an absolute life saver. I watch all 5 videos and you’ve just helped ease my anxiety with my Data Visualisation coursework! I owe you dinner whenever you’re in London. Thank you so much
Alex! Big thanks. After taking interest in data analytics earlier this year, I finally started applying and have my first interview next week. Just know that your work is helping a ton of people.
@@boky7731 I took the google data analytics course to start. For me, SQL is the number one objective to learn. I used power BI for visualizations. Have the ability to show your queries online. Show that you can explore data. The position I applied for didn't ask for python experience, but I'm working on learning that anyways to further my career opportunities. Honestly, go to kaggle and download some datasets you find interesting and just start playing with them. Find trends and show through them visualization. Make sure your visuals can be read by literally anyone. My interview questions were mainly how I used data to make informed decisions, and my experience in certain languages. I should know if I landed the job next week, but this was a huge confidence boost that I needed. It let me know the work I presented is good, even though I had doubts. Hope this helps a little.
@@djnaadowanyakumulator3526 Unfortunately not. It was my first interview in nearly 10 years, so to say it was a strong one would be a lie lol. I was placed on an eligibility list for future positions there, so that's assuring. Going forward, I'm just going to work on another project, work on interview skills, and continue learning python.
I finished your SQL Tutorial last week and have been practicing, like I am surprised at myself, running queries on my own with downloaded datasets. I have never seen SQL before, I have always done everything with Excel. It's so beginner friendly. Tableau Let's do this.
No words to thankful the great way to explaind every single topic in your bootcamp. You help to save a lot money/time learning in a fun way. You rock, Alex! 👏🏻
I have a good level of english but I still can't understand an entire movie or song but in your course it looks like you take care to speak clear and slowly which helps those who can't speak english as a fluent language. Thanks for your videos until here!
Thanks for the Project inspo Alex! Got to messing around with it myself and it's quite rewarding! Tip: for those that are also beginners like myself, you can set each of the "cards" in the dashboard as a filter so you can clean up the dashboard and remove the visual filters, and now clicking on the zipcodes on either the map or the zipcode breakdowns, the WHOLE dashboard updates itself, really neat fun feature!
Issue: Map not showing data Resolution: If you find that the map does not pop up as in the guide check the bottom right of the map to see if any values are unknown. You may just have to change the country the data is being checked against to get the values to appear.
I have watched a lot of data videos on youtube, and all have been pretty overwhelming for a newbie except yours. I so appreciate you taking a very human approach and showing mistakes throughout your process.
What a great tutorial on Tableau. I had taken a course elsewhere and felt really confused. I came across your video and just in a day I was able to go through the Five videos. My goodness you make it really easy!!!! Thank you Alex, you are a saviour in Data Analysis. I will be watching all your videos. Sure will be a professional by the time I am done. Thanks for the recommendations on the Udemy and Coursera Courses.
Currently working through Python, but I'm excited to get started on your SQL series AND YOU'RE ALSO DOING TABLEAU!!!! AAHHHH! Hopefully by the time I get through all of that, you'll have an intermediate series of Tableau as well, I can't wait! Keep up the amazing work Alex! Wish I could buy you a drink!!
Thank you so much Alex for all the wonderful content, I started watching your videos last year March 2023. All the content is short, crisp and easily understood. I completed Excel, SQL, Power BI and Tableau videos from the Data Analyst Bootcamp Playlist. Many more things to learn from you until I get a job in Data Domain. God bless you!
Hello, Alex! Dawn here! I am a Merit America Data Analyst Cohort Learner and I love your videos. Thank you for all that you do. Here's to another Tableau Project that I stuck with and have on my Tableau Dashboard. Thanks, again.
Alex.....you are a very good teacher. I've just been given a project that seems a perfect fit for Tableau. My orgainzation already has this platform but I've not utilized it. I feel like I now have a better than basic understanding just from watching your beginer series of videos. GREAT WORK!!!! Keep them comming!
Hi Alex, this was a great video. I learned SO MUCH! I'm having a blast working through your bootcamp series and building my portfolio (at the same time!). Absolutely brilliant! I can't tell you how much I appreciate all the time and effort you've put into this bootcamp series. Moreover, all the content you've included to actually get a job as a data analyst using these skills is such a blessing (e.g., LinkedIn, building a portfolio, mistakes to avoid, interviewing, etc.)! You are such a wonderful human. As always, THANK YOU!
Don't get me wrong but it really makes me feel confident that Analyst like you can make mistakes sometimes. -Thanks for the course "Alex The Analyst!!"
Thank you Alex! I am currently enrolled in the Google Analytic Cert program and your explanation far exceeds the instruction given in the Google program. Their program is boring chit chat and not enough hands on and explanation. I have completed your videos for Tableau and I have a few left in SQL. I appreciate your diligence, keep up the good work!
00:03 Learn to build a beginner-friendly dashboard 01:47 Working with the Airbnb dataset from Seattle 05:40 Understanding and analyzing data is crucial for data analysts. 07:46 Building out the Microsoft Excel listing, calendar, and reviews tabs 12:04 Joining and filtering data in Tableau 14:13 The key things to consider for starting an Airbnb business are bedrooms, location, and price. 18:10 The text discusses the process of using zip codes for Airbnb analysis. 19:55 Visualizing zip code information and average prices 23:33 The visualization of the calendar needs improvement. 25:30 The data shows a significant drop in travel during the beginning of January and February. 29:21 The main analysis is regarding the number of bedrooms and their impact on price. 31:10 Visualization of average price is useful information. 35:01 There are varying numbers of one, two, three, and four-bedroom listings. 36:44 Create a dashboard with five visualizations 40:30 Summary of the entire thing and how to share it. 42:16 Create unique dashboards and visualizations to enhance your portfolio
Hi Alex, could you make a video explaining real-life projects that you perform at work? I'd like to have a rough idea what projects are carried out in the healthcare industry. Cheers!
Alex I have been diligently taking your course and I am so grateful. I know that through this I will gain so many opportunities and I am so excited for what's ahead
This is so awesome! I’m visiting Seattle next month and I was curious on why AirBnB prices are so much more than hotels now. This will be a perfect project to play around with and see why!
Thanks for showing us step by step including your mistakes, I just finished making these visualizations and uploaded it to tableau. I'm really grateful you took the time to create HQ videos and tutorials for us free of cost. I'm adding this to my portfolio to apply to grad school this year :) 😄 Liked and subscribed ASAP
Alex thank you again for making this video. I did complete it today and have a new data viz in tableau public. You make super easy to understand and follow along so I really appreciate it. I'm on my way to having a full portfolio to show.
This is me in the 14:01 waiting for 20 minutes to pass to be able to start with sheet 1 lol. Thank you Alex! I have learnt so much from this playlist! you have a talent to share your knowledge!... I came to edit this comment.... I am glad I continued watching while I was waiting so I could find out I could cancel and remove the reviews sheet.. haha
Thank you Alex. I have completed your Tableau series and this has definitely helped me to start learning Tableau. Any suggestions on what should I do next?
Very helpful walkthrough of Tableau. Thank you! Also enjoyed the realness ("Oh this is a travesty!", "This is the worst visualization I have ever seen.") Haha, keeps it lighthearted!
I just want to say thank you for putting out this great content to teach people. my favorite youtuber / data analyst. thank you for your time and effort.
Im keeping up with this Bootcamp! its amazing, thank you so much! as a detail, its amazing how the data is incresing so fast. For example im doing this project based in Madrid June 2023 and i got 113million rows. Damn!
Great tutorial! You are a great teacher! I love how you solve errors and explain them as simple as it is....I will continue with your bootcamp and other courses you have on your channel. Congrats Alex!
Oh the AirBnB data is so relevant even a year later, It is actually perfect for my portfolio. I would suggest doing this project for your country or region, see if you can get some extra insights.
Thank you! That was really helpful. I think I'm ready now to do my very own project, as I feel I shouldn't use this in my portfolio, as it's just a copy. So let's go and make my own project now!
I did the same project but for Vienna, the tricky part was working without zipcodes, so I needed to connect each neighborhood zipcode to each neighborhood from the table. Thank you so much for this tutorial! :)
Hey, I am trying this on the present dataset of Seattle but facing the same issue. I have observed some neighbourhoods have two zip codes. Did you face similar issue?
@@tanyabahl9894 "Not only can a street be in different zip codes; but buildings can and do have multiple zip codes by floor, suite, company, or any division that produces significant mail for sorting, bundling, and delivery. Zip codes are not for defining geographic locations but logistics and delivery efficiency." Sometimes they do, it is not mainly about location. In my project, in vienna, it is pretty organized that way, but it is not neccesary. I would leave both zipcodes for the same neighbourhood.
Thank you Alex 🙂I publish mine on my Profile and I put a link as inspiration to connect to your profile. I just started today and watched all your videos. It is really easy when I know SQL first and then start with Tableau. Many thanks again! You are a great teacher.
The reason the initial joins failed is because you only joined the review table on id = id and didn't also join the review dates, so every review per location was added to every date, rather than a 1:1 relationship. The join was bad.
sad but true, going forward, would be better to do the joining practice in SQL first before going to tableau. Hard to handle and confirmed the correctness of each joining if we have bulk data with many columns in tableau
In the latest data set, Listing excel sheet does not contain zipcode field. Zipcode field is very crucial in this analysis. Please suggest any workaround to this.
Thanks for the tutorials, Alex! They are helpful for getting me up to speed fast. One tip though: every axis should ALWAYS have units! For example, is the average price in dollars? Euros? Millions of dollars? Etc.
big thanks to @alex i was trying to make this project with the latest datasets but unfortunately new datasets dont have the zip codes. any tip on getting the maps without the zipcode data?
Thank you Alex. I just completed this project and I tried saving it but it shows an error message saying I should extract the data. How do I extract my file from Tableau Public?, I am not seeing the option to extract in my Data Source
Thanks for the amazing videos, Alex. Much appreciated. Quick question though: I tried joining just the Listing and Calendar as shown in the video but I’m getting an error message that “Tableau Public only works with less than 1 million rows of data”. It’s not 15 million for me. I even tried the Date filter of just the 2016 data, that too is more than 1 million rows of data. How should I go about this?
I left the 0 bedrooms in my data because I believe it is referring to a studio apartment or loft. A place where a couple would likely rent solo. I moved to Northwest Washington a couple years ago and there were quite a few studio apartments I looked at. The average price for a studio was actually slightly higher than single bedroom apartments.
27:00 Hello got question about this interpretation - I think it doesnt show the quantity of renting because the price is different in different airbnb, for example one night for 1000 show, that more people traveled this day than 10 people for 20 $ in this visualization. Was the correct way to set Count(price) ? It would show the rows(number of rentings) ?
Thank you Alex for such a helpful video. I really enjoyed the whole project and your amazing explanation as well. I just have one question on your analysis, I don't know if I missed it or if it's actually wrong, tho: Why is it you decided to use SUM of the price for the Data Viz of Price for the year? I mean, when doing it on my own I thought it makes more sense if you take that price and use it as AVG, because that way you can show the avg increase or decrease of the price of the property listed all through the year. Please, if you or any of the other fellow viewers can share any answer to this question, it'd be appreciated.
Hi Alex, thank you for the great tutorial, I have a question on sheet 4, would it be more meaningful to have sum price of bedrooms instead of average, since the sum would indicate that the 2-bedrooms are often booked more than others, while averaging the price would always be 5-bedrooms > 4 bedrooms > 3..etc??
Hi Alex, don't you think that the first and second viz just show the exact same info, so maybe we could just use one of them instead of two to avoid repetition. Anyways, much appreciation to you and your amazing content !
Hello sir, I have just taken admission in B.Sc Data Analytics and I am fresher, so what things I should do so I become better than others and have good skills and a bright future....
Dear Alex, please have more failiures and mistakes please. Because this is how u comply with challenges and it is way more educational to see how u solve them when u face issues. Thanks!
Any chance we can see a part 2 or a more complex project to understand what advanced Tableau entails? Like trends(WoW, YoY) via calculated fields & parameters and LOD's? Would this dashboard be worth including in a portfolio, or should one really aim for more complex topics?
I think this is a good dashboard for beginners. As you get more advanced you should replace it with the better dashboards. I do plan on making more complex tableau (and other) projects in the future.
Another brilliant project video - thank you! In the revenue for year chart, how do I start the y axis at 1000k to eliminate all the blank space under the line from 0-1000k? I know how to do this in an excel chart by setting a minimum value in the bounds group but I couldn't figure out how to do it in tableau. Just figured that wasted space could be used for something more impactful in a dashboard.
Thanks Alex for that hard work.. But is it recommended to do dashboards like that overall.. I mean it is something messy and confusing to non-technical people!
19:34 for someone that cant see a seattle geographic, take a look at a bottom right of the map, tableau will tell you that there's "values that have unknown geographic location " you can click it and choose edit locations, and chose united states as a country, hope this help
Amazing, Helped Al ot thank you so much 🥰
Thanks for the help
Thank you, very helpful. Much Appreciated
Thanks a lot. I was having this issue and its solved now :)
YES! Thank you so much man, I wish I had scrolled down to the comments earlier...
man im gonna tell you sotry , and its mine and i swear its 100% true
3 months ago i decided to learn data analyst , i want to become freelancer so i choose data analyst as my skill , and i watched a lot of videos in youtube it was usefull but not that much i always has felling that something missing so i want to buy courses in udemy but as im still student and the currency in my country its not dollars so its hard for me to buy a course but the day i watched your excel tutorials it was a gift from god i knew with those beautiful tutorials you made im gonna be a data analyst
thank you so much man you are a hero for me
last thing my english is not good cause its my third language but due to your videos i progress in it
so thank you so much man
This is awesome, thank you. Just a note - if you are not in the USA you might need to Edit Locations in the map settings to USA.
In the Menu Bar click on Map -> then select Edit Locations -> and change the Country/Region to USA.
thank you so much, this was extremely helpful
Absolute life saver! I spend like an hour trying to figure this out! Thanks!
Super Helpful.. Thank you very much
Thank you
Alex, you are an absolute life saver. I watch all 5 videos and you’ve just helped ease my anxiety with my Data Visualisation coursework! I owe you dinner whenever you’re in London. Thank you so much
Alex!
Big thanks. After taking interest in data analytics earlier this year, I finally started applying and have my first interview next week.
Just know that your work is helping a ton of people.
Good luck!!
How did you learn it? Can you share it please? What did you learn? I started my journey not so long ago so I would appreciate any help.
@@boky7731 I took the google data analytics course to start. For me, SQL is the number one objective to learn. I used power BI for visualizations. Have the ability to show your queries online. Show that you can explore data. The position I applied for didn't ask for python experience, but I'm working on learning that anyways to further my career opportunities.
Honestly, go to kaggle and download some datasets you find interesting and just start playing with them. Find trends and show through them visualization. Make sure your visuals can be read by literally anyone. My interview questions were mainly how I used data to make informed decisions, and my experience in certain languages. I should know if I landed the job next week, but this was a huge confidence boost that I needed. It let me know the work I presented is good, even though I had doubts.
Hope this helps a little.
@@Jay-Fis hey did you get the job? :D
@@djnaadowanyakumulator3526 Unfortunately not. It was my first interview in nearly 10 years, so to say it was a strong one would be a lie lol. I was placed on an eligibility list for future positions there, so that's assuring. Going forward, I'm just going to work on another project, work on interview skills, and continue learning python.
Its now 2 years old, and just learnt Tableau for free. Love Alex from India.
I finished your SQL Tutorial last week and have been practicing, like I am surprised at myself, running queries on my own with downloaded datasets. I have never seen SQL before, I have always done everything with Excel. It's so beginner friendly. Tableau Let's do this.
the whole day I was refreshing tab again and again so I don't miss anything
Thanks, Alex Sir
No words to thankful the great way to explaind every single topic in your bootcamp. You help to save a lot money/time learning in a fun way. You rock, Alex! 👏🏻
I have a good level of english but I still can't understand an entire movie or song but in your course it looks like you take care to speak clear and slowly which helps those who can't speak english as a fluent language. Thanks for your videos until here!
Thanks for the Project inspo Alex! Got to messing around with it myself and it's quite rewarding!
Tip: for those that are also beginners like myself, you can set each of the "cards" in the dashboard as a filter so you can clean
up the dashboard and remove the visual filters, and now clicking on the zipcodes on either the map or the zipcode breakdowns, the WHOLE dashboard
updates itself, really neat fun feature!
Issue: Map not showing data
Resolution: If you find that the map does not pop up as in the guide check the bottom right of the map to see if any values are unknown. You may just have to change the country the data is being checked against to get the values to appear.
Thanks!
You're a legend! Thank you!
Thanks
Thanks mate!!!!!!
Thanks, I was a bit confused why the map is not working, but you solve it.
I have watched a lot of data videos on youtube, and all have been pretty overwhelming for a newbie except yours. I so appreciate you taking a very human approach and showing mistakes throughout your process.
So glad to hear it Megan! :D
What a great tutorial on Tableau. I had taken a course elsewhere and felt really confused. I came across your video and just in a day I was able to go through the Five videos. My goodness you make it really easy!!!! Thank you Alex, you are a saviour in Data Analysis. I will be watching all your videos. Sure will be a professional by the time I am done. Thanks for the recommendations on the Udemy and Coursera Courses.
Currently working through Python, but I'm excited to get started on your SQL series AND YOU'RE ALSO DOING TABLEAU!!!! AAHHHH! Hopefully by the time I get through all of that, you'll have an intermediate series of Tableau as well, I can't wait! Keep up the amazing work Alex! Wish I could buy you a drink!!
Thank you so much Alex for all the wonderful content, I started watching your videos last year March 2023. All the content is short, crisp and easily understood. I completed Excel, SQL, Power BI and Tableau videos from the Data Analyst Bootcamp Playlist. Many more things to learn from you until I get a job in Data Domain. God bless you!
Hello, Alex! Dawn here! I am a Merit America Data Analyst Cohort Learner and I love your videos. Thank you for all that you do. Here's to another Tableau Project that I stuck with and have on my Tableau Dashboard. Thanks, again.
Alex.....you are a very good teacher. I've just been given a project that seems a perfect fit for Tableau. My orgainzation already has this platform but I've not utilized it. I feel like I now have a better than basic understanding just from watching your beginer series of videos. GREAT WORK!!!! Keep them comming!
Hi Alex, this was a great video. I learned SO MUCH! I'm having a blast working through your bootcamp series and building my portfolio (at the same time!). Absolutely brilliant! I can't tell you how much I appreciate all the time and effort you've put into this bootcamp series. Moreover, all the content you've included to actually get a job as a data analyst using these skills is such a blessing (e.g., LinkedIn, building a portfolio, mistakes to avoid, interviewing, etc.)! You are such a wonderful human. As always, THANK YOU!
Don't get me wrong but it really makes me feel confident that Analyst like you can make mistakes sometimes.
-Thanks for the course "Alex The Analyst!!"
Thank you Alex! I am currently enrolled in the Google Analytic Cert program and your explanation far exceeds the instruction given in the Google program. Their program is boring chit chat and not enough hands on and explanation. I have completed your videos for Tableau and I have a few left in SQL. I appreciate your diligence, keep up the good work!
00:03 Learn to build a beginner-friendly dashboard
01:47 Working with the Airbnb dataset from Seattle
05:40 Understanding and analyzing data is crucial for data analysts.
07:46 Building out the Microsoft Excel listing, calendar, and reviews tabs
12:04 Joining and filtering data in Tableau
14:13 The key things to consider for starting an Airbnb business are bedrooms, location, and price.
18:10 The text discusses the process of using zip codes for Airbnb analysis.
19:55 Visualizing zip code information and average prices
23:33 The visualization of the calendar needs improvement.
25:30 The data shows a significant drop in travel during the beginning of January and February.
29:21 The main analysis is regarding the number of bedrooms and their impact on price.
31:10 Visualization of average price is useful information.
35:01 There are varying numbers of one, two, three, and four-bedroom listings.
36:44 Create a dashboard with five visualizations
40:30 Summary of the entire thing and how to share it.
42:16 Create unique dashboards and visualizations to enhance your portfolio
Hi Alex, could you make a video explaining real-life projects that you perform at work? I'd like to have a rough idea what projects are carried out in the healthcare industry. Cheers!
Nice idea mate!
Nice suggestion. I hope he sees it
@@donyg21 I posted my suggestion two months ago and he hasn't made the video yet, so honestly I don't think he will (unfortunately)
@@davidfunes9346
I hope so
Alex I have been diligently taking your course and I am so grateful. I know that through this I will gain so many opportunities and I am so excited for what's ahead
How’d you get the files for this project from his GitHub.. Can’t seem to find em
Thank you Alex, Words cannot explain how helpful you have been to developing my data analysis skills. I am grateful.
Happy to help!
@@AlexTheAnalystsame here boss, i love your heart and selflessness to make things easy for free ❤
Hi Alex, it was a great series. You make it simple and easy. please do intermediate series as well thank you
This is so awesome! I’m visiting Seattle next month and I was curious on why AirBnB prices are so much more than hotels now. This will be a perfect project to play around with and see why!
Thanks Alex, I enjoy your tutorials, you keep it simple and easy to follow.
Thanks for showing us step by step including your mistakes, I just finished making these visualizations and uploaded it to tableau. I'm really grateful you took the time to create HQ videos and tutorials for us free of cost. I'm adding this to my portfolio to apply to grad school this year :) 😄 Liked and subscribed ASAP
Thank you so much, Alex. Huge shout-out from India.🙌🙌🙌
Alex thank you again for making this video. I did complete it today and have a new data viz in tableau public. You make super easy to understand and follow along so I really appreciate it. I'm on my way to having a full portfolio to show.
Dunno why my cannot save to Tableau Public?
I really wanna thank you on this huge effort. you changed my life
Very simple, concise, and helpful! Thanks Alex for this series, it was a pleasure learning tableau through your videos
This is me in the 14:01 waiting for 20 minutes to pass to be able to start with sheet 1 lol. Thank you Alex! I have learnt so much from this playlist! you have a talent to share your knowledge!... I came to edit this comment.... I am glad I continued watching while I was waiting so I could find out I could cancel and remove the reviews sheet.. haha
Thank you Alex. I have completed your Tableau series and this has definitely helped me to start learning Tableau. Any suggestions on what should I do next?
Find a dataset you like and try to build a dashboard from scratch :)
Very helpful walkthrough of Tableau. Thank you! Also enjoyed the realness ("Oh this is a travesty!", "This is the worst visualization I have ever seen.") Haha, keeps it lighthearted!
Thanks, Alex for helping me to create my first ever project on tableau
Really thank you alex for the work you are doing. You are the part of my upcoming growth🙏🏻🤝🏻
Found your Channel today I started tableau and completed it. Best channel wish tbh👏👏🫡. You deserve a million like👍🏼
I'm really grateful Alex for all of your insightful videos so far! Tableau Portfolio Project here I come.😜
I just want to say thank you for putting out this great content to teach people.
my favorite youtuber / data analyst.
thank you for your time and effort.
I completed all your Tableau tutorials, and they are amazing! Thank you!
Im keeping up with this Bootcamp! its amazing, thank you so much!
as a detail, its amazing how the data is incresing so fast. For example im doing this project based in Madrid June 2023 and i got 113million rows. Damn!
Great tutorial! You are a great teacher! I love how you solve errors and explain them as simple as it is....I will continue with your bootcamp and other courses you have on your channel. Congrats Alex!
Your teaching style is awesome! I appreciate your thoroughness , thank you!
Oh the AirBnB data is so relevant even a year later, It is actually perfect for my portfolio.
I would suggest doing this project for your country or region, see if you can get some extra insights.
I learned and created mine in 2 days. Thank you so much, Alex!
Thanx Alex for creating this wonderful playlist, it was very helpful to me in learning tableau.
Thank you! That was really helpful. I think I'm ready now to do my very own project, as I feel I shouldn't use this in my portfolio, as it's just a copy. So let's go and make my own project now!
Thank as always, didn't realize how quickly I'd devoured information learning about this tool.
I did the same project but for Vienna, the tricky part was working without zipcodes, so I needed to connect each neighborhood zipcode to each neighborhood from the table. Thank you so much for this tutorial! :)
Hey, I am trying this on the present dataset of Seattle but facing the same issue. I have observed some neighbourhoods have two zip codes. Did you face similar issue?
@@tanyabahl9894 "Not only can a street be in different zip codes; but buildings can and do have multiple zip codes by floor, suite, company, or any division that produces significant mail for sorting, bundling, and delivery. Zip codes are not for defining geographic locations but logistics and delivery efficiency."
Sometimes they do, it is not mainly about location. In my project, in vienna, it is pretty organized that way, but it is not neccesary. I would leave both zipcodes for the same neighbourhood.
Great starting point for Tableau dashboards! Now I feel more confident trying out scary looking dashboards from other UA-cam videos! XDD
Hi Alex!
This tutorial is very helpful and I can follow along to the end. As a beginner, I learned so much through your video. Many thanks!
Absolutely loved this. Great project and easy to follow from start to finish. Also, your commentary is hilarious at times. Thank you Alex.
Thank you, Alex! Your videos are easy to follow and very informative. Be blessed!
Thank you Alex 🙂I publish mine on my Profile and I put a link as inspiration to connect to your profile. I just started today and watched all your videos. It is really easy when I know SQL first and then start with Tableau. Many thanks again! You are a great teacher.
The reason the initial joins failed is because you only joined the review table on id = id and didn't also join the review dates, so every review per location was added to every date, rather than a 1:1 relationship. The join was bad.
sad but true, going forward, would be better to do the joining practice in SQL first before going to tableau. Hard to handle and confirmed the correctness of each joining if we have bulk data with many columns in tableau
you make a great instructor. i really enjoy the teaching method you are using. Simple and baby steps. Thank you.
In the latest data set, Listing excel sheet does not contain zipcode field. Zipcode field is very crucial in this analysis. Please suggest any workaround to this.
Love your content, just made this project and customized a little bit! For sure, I''ll be following you
This was very fun and worth learning thanks Alex!
Thanks for the tutorials, Alex! They are helpful for getting me up to speed fast. One tip though: every axis should ALWAYS have units! For example, is the average price in dollars? Euros? Millions of dollars? Etc.
Thank you Alex for making it simple. This is well explained.
Thank You Alex. Learnt more from your Channel. I am grateful that you focus on hangs on project
Hi, I am part way through, just finished the map. Great tutorial as always.
big thanks to @alex
i was trying to make this project with the latest datasets but unfortunately new datasets dont have the zip codes. any tip on getting the maps without the zipcode data?
Keep up the good work Alex! You've deserve a FREE AirBNB for this HAHA
Awesome project! Super useful and fun learning! Thanks for that!
Learn a lot from your videos. Thanks alot Alex
thank you for this project. learned a lot of tableau.
Thank you Alex. I just completed this project and I tried saving it but it shows an error message saying I should extract the data. How do I extract my file from Tableau Public?, I am not seeing the option to extract in my Data Source
Thanks for the amazing videos, Alex. Much appreciated. Quick question though: I tried joining just the Listing and Calendar as shown in the video but I’m getting an error message that “Tableau Public only works with less than 1 million rows of data”. It’s not 15 million for me. I even tried the Date filter of just the 2016 data, that too is more than 1 million rows of data. How should I go about this?
12:41 just click the 'X' on the dialog box which appeared it will automatically let you in with 23M rows of data, you need not reduce the data size.
thank you alex learned alot and created my tableau dashboard
that is more than helpful, you didn't know how much your explanation is grate .. many thanks
I left the 0 bedrooms in my data because I believe it is referring to a studio apartment or loft. A place where a couple would likely rent solo. I moved to Northwest Washington a couple years ago and there were quite a few studio apartments I looked at. The average price for a studio was actually slightly higher than single bedroom apartments.
Thank you Alex! Requesting for more full project examples. :)
27:00 Hello got question about this interpretation - I think it doesnt show the quantity of renting because the price is different in different airbnb, for example one night for 1000 show, that more people traveled this day than 10 people for 20 $ in this visualization. Was the correct way to set Count(price) ? It would show the rows(number of rentings) ?
Thank you Alex for such a helpful video. I really enjoyed the whole project and your amazing explanation as well.
I just have one question on your analysis, I don't know if I missed it or if it's actually wrong, tho: Why is it you decided to use SUM of the price for the Data Viz of Price for the year? I mean, when doing it on my own I thought it makes more sense if you take that price and use it as AVG, because that way you can show the avg increase or decrease of the price of the property listed all through the year.
Please, if you or any of the other fellow viewers can share any answer to this question, it'd be appreciated.
good work man really thanks
hope you continue
Hi Alex, thank you for the great tutorial, I have a question on sheet 4, would it be more meaningful to have sum price of bedrooms instead of average, since the sum would indicate that the 2-bedrooms are often booked more than others, while averaging the price would always be 5-bedrooms > 4 bedrooms > 3..etc??
I followed this tutorial and did a replica of this. can I still add it to my portfolio?
Thank you so Alex. I'm learning a lot from you!
Thanks for the practice, yet another great video that was clear and easy to follow along. I hope you will be able to post more projects soon!
Thank you! I've learned so much from you!
thanks alex for introducing me to dashboards :) perfect learning material!
24:11 "This is the worst visualization I have ever seen" lmao
Thank you! This was very informative. Great introductory to Tableau!
@ALEX - You are terrific. Great series!
Thank you so much for all of your tutorials
Alex, A1 video! What training would you recommend to get certified in Tableau? If this is affordable to start with, even better! Take care.
Thank you SO MUCH FOR THIS!!! YOU ARE HELPING ME OUT SO MUCH, THANK YOU BRO!!!!!!!!!!!!!!!!!!!!!
Hi Alex, don't you think that the first and second viz just show the exact same info, so maybe we could just use one of them instead of two to avoid repetition.
Anyways, much appreciation to you and your amazing content !
Great, easy to follow tutorial!
I noticed you didn't do any data cleaning on the downloaded data, may I ask if you had worked on it earlier before the video?
Hello sir,
I have just taken admission in B.Sc Data Analytics and I am fresher, so what things I should do so I become better than others and have good skills and a bright future....
I think he has a video on it where he explains the skills required for Data Analytics in detail
Dear Alex, please have more failiures and mistakes please. Because this is how u comply with challenges and it is way more educational to see how u solve them when u face issues. Thanks!
Any chance we can see a part 2 or a more complex project to understand what advanced Tableau entails? Like trends(WoW, YoY) via calculated fields & parameters and LOD's?
Would this dashboard be worth including in a portfolio, or should one really aim for more complex topics?
I think this is a good dashboard for beginners. As you get more advanced you should replace it with the better dashboards. I do plan on making more complex tableau (and other) projects in the future.
Another brilliant project video - thank you!
In the revenue for year chart, how do I start the y axis at 1000k to eliminate all the blank space under the line from 0-1000k? I know how to do this in an excel chart by setting a minimum value in the bounds group but I couldn't figure out how to do it in tableau. Just figured that wasted space could be used for something more impactful in a dashboard.
Thanks Alex for that hard work.. But is it recommended to do dashboards like that overall.. I mean it is something messy and confusing to non-technical people!