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.
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
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!
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! 👏🏻
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.
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.
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.
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!
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.
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!
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!
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
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!
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!
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!
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
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!
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!
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.
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!
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?
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
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?
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.
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!
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?
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.
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.
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
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 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
Great video! I wanted to pull data that was newer and I ran into an issue - the zip code column is missing. My data set was for Chicago, IL in 2023. I was hoping and praying that I could convert lat and long to zip but no dice. There is a geocode conversion macro you can build but I'm working on a mac and the specific excel format isn't supported. Anyone have any suggestions? The zipcode data is a really big part of this project LOL
I was unable to save the dashboard on tableau public, I was asked to do "Data Extract" before I could save, which I dont understand, please kindly help out
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.
This video is amazing!! I was trying to use updated data, but is so big for put this data in a Excel and then work on Tableu. Any advice on how I could use large amounts of data?
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) ?
at 33:42 should wee take "host id" instead of "id". because distinct count of host id will give us exact no of hosts right? can somebody help me out in this pls?
Hi I'm facing a issue when I tried to save or publish my project. It's gives me data extract error, I've also tried to extract data but still nothing helped. Please someone help me as I'm unable to show my dashboard or finished project due to this
I’ve been facing smae issue for days now kept trying and trying and finally found my way around Solution: trying going to the Tableau public site to sign up and verify from your mail, then come back to run the process, it’ll work’” > After creating and verifying the account on the site, if the “Save to Tableau public As” keeps delaying, just try the “save to tableau public” Hope this helps
Hi alex! in sheet 2 when i tried to click map in "show me" i'm not getting the same result as you , because after i cleck map i can't see anything highlighted on the map could you help me and point out the problem? thankyou
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.
At 14:34 is anyone else having trouble with the year 2016 not loading? Mine is taking forever to load. I don't know if it has something to do with my Excel download or what. How do we fix it? @Alex The Analyst
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??
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.
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.
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
Its now 2 years old, and just learnt Tableau for free. Love Alex from India.
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.
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
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!
the whole day I was refreshing tab again and again so I don't miss anything
Thanks, Alex Sir
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! 👏🏻
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.
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.
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.
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!
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
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!
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!
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
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!
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.
Thank you so much, Alex. Huge shout-out from India.🙌🙌🙌
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 ❤
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!
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
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
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!
I really wanna thank you on this huge effort. you changed my life
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?
Very simple, concise, and helpful! Thanks Alex for this series, it was a pleasure learning tableau through your videos
Great starting point for Tableau dashboards! Now I feel more confident trying out scary looking dashboards from other TH-cam videos! XDD
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!
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.
Your teaching style is awesome! I appreciate your thoroughness , thank you!
I learned and created mine in 2 days. Thank you so much, Alex!
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 :)
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
Thanks, Alex for helping me to create my first ever project on tableau
Thank as always, didn't realize how quickly I'd devoured information learning about this tool.
I completed all your Tableau tutorials, and they are amazing! Thank you!
This was very fun and worth learning thanks Alex!
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?
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.
Absolutely loved this. Great project and easy to follow from start to finish. Also, your commentary is hilarious at times. Thank you Alex.
I'm really grateful Alex for all of your insightful videos so far! Tableau Portfolio Project here I come.😜
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!
Found your Channel today I started tableau and completed it. Best channel wish tbh👏👏🫡. You deserve a million like👍🏼
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!
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! Your videos are easy to follow and very informative. Be blessed!
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
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.
you make a great instructor. i really enjoy the teaching method you are using. Simple and baby steps. Thank you.
Keep up the good work Alex! You've deserve a FREE AirBNB for this HAHA
Learn a lot from your videos. Thanks alot Alex
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
Thank you Alex for making it simple. This is well explained.
thank you for this project. learned a lot of tableau.
Thank You Alex. Learnt more from your Channel. I am grateful that you focus on hangs on project
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!
Awesome project! Super useful and fun learning! Thanks for that!
30:30 why we used dimesnsions for bedroom column, any could help me out??
Thanx Alex for creating this wonderful playlist, it was very helpful to me in learning tableau.
24:11 "This is the worst visualization I have ever seen" lmao
thank you alex learned alot and created my tableau dashboard
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 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
You are the goat. Big thanks i learn step by stp.
Great video! I wanted to pull data that was newer and I ran into an issue - the zip code column is missing. My data set was for Chicago, IL in 2023. I was hoping and praying that I could convert lat and long to zip but no dice. There is a geocode conversion macro you can build but I'm working on a mac and the specific excel format isn't supported. Anyone have any suggestions? The zipcode data is a really big part of this project LOL
Same! Can’t find Zipcode field in Seattle, WA 2023 data either… Have you figured out how to do this?
same have the same issue
@@JayDenton-n1n
@@JayDenton-n1nsame issue here, how did you find your way around it?
Really thank you alex for the work you are doing. You are the part of my upcoming growth🙏🏻🤝🏻
Hi, I am part way through, just finished the map. Great tutorial as always.
good work man really thanks
hope you continue
I was unable to save the dashboard on tableau public, I was asked to do "Data Extract" before I could save, which I dont understand, please kindly help out
Me too. Encountered the same problem
@@LL-jj3ut if you're still stuck. Here's me from today. I'm stuck to. I officially hate tableau
Thank you so Alex. I'm learning a lot from you!
that is more than helpful, you didn't know how much your explanation is grate .. many thanks
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.
Thanks!
Thank you! This was very informative. Great introductory to Tableau!
Thank you Alex! Requesting for more full project examples. :)
This video is amazing!! I was trying to use updated data, but is so big for put this data in a Excel and then work on Tableu. Any advice on how I could use large amounts of data?
@ALEX - You are terrific. Great series!
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) ?
at 33:42 should wee take "host id" instead of "id". because distinct count of host id will give us exact no of hosts right?
can somebody help me out in this pls?
Hi I'm facing a issue when I tried to save or publish my project. It's gives me data extract error, I've also tried to extract data but still nothing helped. Please someone help me as I'm unable to show my dashboard or finished project due to this
I’ve been facing smae issue for days now kept trying and trying and finally found my way around
Solution: trying going to the Tableau public site to sign up and verify from your mail, then come back to run the process, it’ll work’”
> After creating and verifying the account on the site, if the “Save to Tableau public As” keeps delaying, just try the “save to tableau public”
Hope this helps
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 Alex
God bless you, Amen.
Thank you so much for all of your tutorials
Hi alex! in sheet 2 when i tried to click map in "show me" i'm not getting the same result as you , because after i cleck map i can't see anything highlighted on the map
could you help me and point out the problem? thankyou
Do this extra step: Just drag "Country" from the left side into the Marks area, then change its type from automatic into Map.
@@mohamed0h0hamed Thank you sir
Thank you SO MUCH FOR THIS!!! YOU ARE HELPING ME OUT SO MUCH, THANK YOU BRO!!!!!!!!!!!!!!!!!!!!!
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.
At 14:34 is anyone else having trouble with the year 2016 not loading? Mine is taking forever to load. I don't know if it has something to do with my Excel download or what. How do we fix it? @Alex The Analyst
Hey did you solve the issue? bec I am encountering the same issue. It has been 100 minutes but it has not loaded yet
@@ZehraBatool-yj1vb i never did, sadly. So I just decided to give up on tableau :(. No one helped me figure out how to get past it
Hi am having same issue please can someone help us out
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??
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.
Thank you! I've learned so much from you!
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.