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!
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!!
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.
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!
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!
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.
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!
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
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!
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!!"
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 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
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!
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.
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!
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?
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
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!
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!
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.
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 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.
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!
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.
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 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
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.
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?
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.
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.
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 !
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
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??
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....
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
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/mqdefault.jpg)
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.
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! 👏🏻
Its now 2 years old, and just learnt Tableau for free. Love Alex from India.
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!
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!!
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.
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!
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
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
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!
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 ❤
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!
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!!"
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.
Hi Alex, it was a great series. You make it simple and easy. please do intermediate series as well thank you
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
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!
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?
Thanks Alex, I enjoy your tutorials, you keep it simple and easy to follow.
Very simple, concise, and helpful! Thanks Alex for this series, it was a pleasure learning tableau through your videos
Thanks, Alex for helping me to create my first ever project on tableau
I really wanna thank you on this huge effort. you changed my life
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!
Really thank you alex for the work you are doing. You are the part of my upcoming growth🙏🏻🤝🏻
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 :)
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
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!
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!
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.
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.
Found your Channel today I started tableau and completed it. Best channel wish tbh👏👏🫡. You deserve a million like👍🏼
Great starting point for Tableau dashboards! Now I feel more confident trying out scary looking dashboards from other RUclips videos! XDD
I'm really grateful Alex for all of your insightful videos so far! Tableau Portfolio Project here I come.😜
I completed all your Tableau tutorials, and they are amazing! Thank you!
Thanx Alex for creating this wonderful playlist, it was very helpful to me in learning tableau.
Thank as always, didn't realize how quickly I'd devoured information learning about this tool.
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!
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.
I learned and created mine in 2 days. Thank you so much, Alex!
Your teaching style is awesome! I appreciate your thoroughness , thank you!
you make a great instructor. i really enjoy the teaching method you are using. Simple and baby steps. Thank you.
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.
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!
Absolutely loved this. Great project and easy to follow from start to finish. Also, your commentary is hilarious at times. Thank you Alex.
Love your content, just made this project and customized a little bit! For sure, I''ll be following you
Thank you, Alex! Your videos are easy to follow and very informative. Be blessed!
Keep up the good work Alex! You've deserve a FREE AirBNB for this HAHA
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. 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.
Thank you Alex for making it simple. This is well explained.
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
Learn a lot from your videos. Thanks alot Alex
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.
This was very fun and worth learning thanks Alex!
Awesome project! Super useful and fun learning! Thanks for that!
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 for this project. learned a lot of tableau.
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.
that is more than helpful, you didn't know how much your explanation is grate .. many thanks
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! Requesting for more full project examples. :)
thanks alex for introducing me to dashboards :) perfect learning material!
Thank you so Alex. I'm learning a lot from you!
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 learned alot and created my tableau dashboard
Thank you! This was very informative. Great introductory to Tableau!
Thanks for the videos. Simple and straightforward!
Thanks for your efforts Alex. Very nicely explained. Raj
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.
Thank you! I've learned so much from you!
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?
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.
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.
For the map, to color the zip code areas by their average price rankings, simply add color to AVG(Price).
Thank you SO MUCH FOR THIS!!! YOU ARE HELPING ME OUT SO MUCH, THANK YOU BRO!!!!!!!!!!!!!!!!!!!!!
Thank you so much for this Alex. really insightful and helpful.
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 !
good work man really thanks
hope you continue
Thank you so much for all of your tutorials
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
This is great. Just wanted to point out that studio apartments have 0 bedrooms. Some small families may want that. 🙂
24:11 "This is the worst visualization I have ever seen" lmao
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??
@ALEX - You are terrific. Great series!
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
Great, easy to follow tutorial!
Alex, A1 video! What training would you recommend to get certified in Tableau? If this is affordable to start with, even better! Take care.
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?