Hey Andy you are doing great job.Even i was searching for best use cases in tableau and you are doing same.Thanks for this and please keep uploading such videos.
@jizhang2407
5 жыл бұрын
thanks for sharing, Andy. I never knew there are the makepoint and makeline functions... until today
@vizwiz
5 жыл бұрын
Ji Zhang they are a new feature in 2019.2
@rajeshtukdeo
4 жыл бұрын
Thanks Andy for this wonderful video !!
@sunithaambala3396
5 жыл бұрын
Thank you Andy .. I keep learning from your videos
@aashishkshah
5 жыл бұрын
I keep learning from you .. Thanks Andy and team!
@chandrabhanu4478
5 жыл бұрын
Got to learn something new today... Thanks Andy
@sergioloyola4261
3 жыл бұрын
You are a life saver! - Thank you!!!
@romanvasiura6705
Жыл бұрын
Andy, hello! Could you give a link for the dataset(s)? I would like to repeat each step from your video... but without dataset I can't do it...
@vizwiz
Жыл бұрын
Download the workbook.
@MrMaiqbal
4 жыл бұрын
Hi Andy, great work and demonstration. Just a quick question, can you add all stops on a route (Bus routes in London) and somehow highlight them while selecting/filtering a route? like some dots/circles on a single route line with their names in tooltip while hovering over those dots/circles? thanks
@vizwiz
4 жыл бұрын
Yes
@harishmahamure7574
4 жыл бұрын
Amazing, just a quick question. The lat long details need to be at how much depth? Like zip code or we can dive more?
@vizwiz
4 жыл бұрын
That’s totally up to you.
@25070410
7 ай бұрын
Thanks for this video. I have question, how to show top 10 busiest air routes from the dataset that you have.
@vizwiz
6 ай бұрын
This data set doesn’t have passenger information.
@josephshuffield6113
2 жыл бұрын
HI Andy--I've used your airport example to create a map that shows facilities within a state as destination, and counties from where people are referred to those facilities as origin. I've used color for destination so all referrals to each destination from across the state are the same color--but I would really love to be able to select the facility and have the names of counties (origin of referral) show up at the end of each line. Is there a way to do that?
@vizwiz
2 жыл бұрын
Does it work if you put that field on the tooltip shelf?
@josephshuffield6113
2 жыл бұрын
@@vizwiz Actually I found a way using a layer, and initially I wasn't pulling that info from the right source, but now it's working--thank you for a great tutorial!
@zii8181
2 жыл бұрын
How about for zip code that starts with zero, distance formula won't show the difference. Any thoughts??
@vizwiz
2 жыл бұрын
The data needs the be lat/lon but zip code
@javierfernandez5468
3 жыл бұрын
Why do I get straight lines when showing the map of streets (in your case the bus-routes). I don't get the routes by roads. It's just straight lines. How can I change it?
@vizwiz
3 жыл бұрын
Because you’re telling tableau to draw between two points. Tableau won’t follow roads. The map in the background is merely for reference.
@adnansaqib9468
3 жыл бұрын
Great Work! I have one question. How can we get check-In & out of every station and can we find the distance between each station.
@vizwiz
3 жыл бұрын
You would need to find the data. As for distance, there’s a DISTANCE function you can use.
@Editors-ronaldo
3 жыл бұрын
Great Video.. I just have a small question.. in case of airport route, it is obvious that there is a curved straight line between origin and destination point, but how come, in case of London Bus Stop example, it is creating a proper route between two points ? which is zig-zag in certain cases.??
@vizwiz
3 жыл бұрын
Tableau considers the curvature of the earth when deciding whether to curve the line. If you are zoomed in quite far, like the London bus example, the curvature will have no impact. Tableau is still drawing a curve, but you can't see it.
@bunty2577
3 жыл бұрын
Hi Andy, thanks for this tutorial. I have Origin Zip and Dest Zip however don't have origin lan/lat and dest lan/late like you. How do I get that?
@vizwiz
3 жыл бұрын
Find it on Google.
@Data.Monster
5 жыл бұрын
Awesome Andy, great tutorial !!!
@datapeek
2 жыл бұрын
It was really helpful. Thanks
@vizwiz
2 жыл бұрын
You're welcome!
@sj8648
3 жыл бұрын
Thank you Andy!!!
@acmerritt
5 жыл бұрын
I do a lot of work with airlines and so I appreciate the tip, as always. (one of my mantras, WWAD - What Would Andy Do?). Back in 2016, I worked out the custom geocoding sufficiently to create Airports as a Geographic Role and I use that to map various things but I've never been able to map the routes. Can I use MAKELINE to connect the Departure and Arrival airports when they are already defined by their geographic role (latitude / longitude)?
@vizwiz
5 жыл бұрын
acmerritt you can use these functions if you have lat/lon fields in the data set. You can’t use tableau’s automatically generated lat/lon.
@acmerritt
5 жыл бұрын
@@vizwiz Thank you so much for answering Andy. (I live in a small beachside town in Australia, a long way from any capital city user groups that I could ask). The lat/lon fields are not in the dataset per se, but they are in a file (of my making) that sits in the folder for the custom geocoding. Would you suggest I bring that excel file into the relevant workbook, 'undefine' the airport fields from geographic role to just string and go from there? It feels like I'm going backwards to undo it but can do that if you think it the way to go. Or should I be asking this on a forum - I don't want to impose.
@Mister.Psychology
5 жыл бұрын
Every single video about this uses the same kind of dataset. There is so much info in such a dataset. I may just have cities and nothing else.
@funguy29
3 жыл бұрын
super solid sir. thanks
@namratanagvekar6857
Жыл бұрын
Why I m not able to create makepoint functions? Any idea.. i have origin and destination lat longs
@vizwiz
Жыл бұрын
Are you in a really old version of Tableau?
@namratanagvekar6857
Жыл бұрын
@@vizwiz no i have 2022 and 2021 in both it's not shwoing
@rohitshyam9833
2 жыл бұрын
You are a saviour. Can i use same technique for shipping data.
@vizwiz
2 жыл бұрын
As long as your data is structured the same way.
@magagsi
5 жыл бұрын
Super duper!!! Thank you Andy!
@ShubhamKumar-xb6ee
3 жыл бұрын
Can u please provide me the link to download the Airline Routes dataset.
@vizwiz
3 жыл бұрын
You can download the workbook and unzip it to get the data. Otherwise, a simple google search will find it.
@adamkapuscinski3187
4 жыл бұрын
I am probably overlooking something, but why does the makeline function follow the streets when you specified start and end points? Wouldn't it just draw a straight line?
@vizwiz
4 жыл бұрын
They are straight lines. For the airports, it will follow the curve of the earth since it’s zoomed out far enough.
@adamkapuscinski3187
4 жыл бұрын
@@vizwiz ok, so if you overlaid the street network it wouldn't coalesce, but rather go straight from one bus stop to the next?
@vizwiz
4 жыл бұрын
Correct
@adamkapuscinski3187
4 жыл бұрын
@@vizwiz interesting. Aside from displaying the map in the background have you tried bringing in the vector file for street networks? Like from Tiger files?
@vizwiz
4 жыл бұрын
Adam Kapuscinski no. That’s overkill for what I was doing.
@hishamd
2 жыл бұрын
Hi Andy! Very helpful video. Do you know of an easy way to load longitude and latitude for multiple dimensions (e.g. Destination airport and Origin airport) within Tableau? Tableau auto generates longitude and latitude for just one dimension. For the life of me, I couldn't figure out a way to auto generate longitude and latitude for multiple dimensions.
@vizwiz
2 жыл бұрын
Use the makepoint function if you already have the lat/lon.
@vizlab_kr
5 жыл бұрын
Great resource! Thanks!
@ChandraShekhar-ds8cp
4 жыл бұрын
Nice Video. I have another dataset which consists of List of Airports. So, can you tell us how to extract latitude and longitude as another column, from List of Airports.
@vizwiz
4 жыл бұрын
The location information has to be in the data source. Tableau can't give you the lat lon from a list of airports.
@srinivasaai
2 жыл бұрын
Great video ✈️, how to plot flight path connecting series of lat long on map.
@vizwiz
2 жыл бұрын
You can’t do it with makeline. You would need each point in an individual row and then you should be able to put the field that orders the points along the route onto the path shelf. Or you might need to use the pages shelf
@harikrishnaradadiya421
5 жыл бұрын
Awesome explanation, but I can not find the work book. can you please guide me in downloading the data. Thanks, H@ri
@vizwiz
5 жыл бұрын
Harikrishna Radadiya there is a link in the description.
@harikrishnaradadiya421
5 жыл бұрын
@@vizwiz Thanks for getting back to me quickly. The link in description take me to the blog where I am able to download Tableau file but not the core data. I want data because I am highly interested in doing the analysis on my own. Thanks, H@ri
@vizwiz
5 жыл бұрын
After you download the workbook, unzip it and you’ll see the twb and the data.
@drparthagopal5023
3 жыл бұрын
Superb..
@mickyandguitar
4 жыл бұрын
Amazing :)
@champakalibhattacharjee9679
3 жыл бұрын
how to convert coordinates to latitude and longitudes..
@vizwiz
3 жыл бұрын
I don’t understand your question.
@champakalibhattacharjee9679
3 жыл бұрын
@@vizwiz Geometric Coordinates i mean
@vizwiz
3 жыл бұрын
Isn’t it already in lat/lon?
@champakalibhattacharjee9679
3 жыл бұрын
@@vizwiz No ..
@champakalibhattacharjee9679
3 жыл бұрын
@@vizwiz No
@Neutrino-xw6jl
5 жыл бұрын
Amazing
@Ozzyfrog78
4 жыл бұрын
You do in 13mn what takes me 2h! So fast and my English is pretty ordinary so I have to watch this video in 0.5 playback - but then it sounds like drunken slur!
@vizwiz
4 жыл бұрын
hahaha!
@Sbudarh_P
2 жыл бұрын
Wow this is wonderful there more I dig your videos @andykriebel I always learn amazing stuff.🤝🏽
@vizwiz
2 жыл бұрын
That’s great to hear thank you. Spread the word. 😊
Пікірлер: 76