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.
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.??
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.
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
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 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!
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 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.
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.
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.
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
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 interesting. Aside from displaying the map in the background have you tried bringing in the vector file for street networks? Like from Tiger files?
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 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
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!
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.
thanks for sharing, Andy. I never knew there are the makepoint and makeline functions... until today
Ji Zhang they are a new feature in 2019.2
Thanks for this video. I have question, how to show top 10 busiest air routes from the dataset that you have.
This data set doesn’t have passenger information.
You are a life saver! - Thank you!!!
Amazing, just a quick question. The lat long details need to be at how much depth? Like zip code or we can dive more?
That’s totally up to you.
Thank you Andy .. I keep learning from your videos
Thanks Andy for this wonderful video !!
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.??
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.
I keep learning from you .. Thanks Andy and team!
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
Yes
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.
You would need to find the data. As for distance, there’s a DISTANCE function you can use.
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...
Download the workbook.
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?
Does it work if you put that field on the tooltip shelf?
@@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!
Got to learn something new today... Thanks Andy
You are a saviour. Can i use same technique for shipping data.
As long as your data is structured the same way.
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)?
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.
@@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.
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?
Find it on Google.
Thank you Andy!!!
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.
Use the makepoint function if you already have the lat/lon.
Super duper!!! Thank you Andy!
super solid sir. thanks
Awesome Andy, great tutorial !!!
It was really helpful. Thanks
You're welcome!
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.
The location information has to be in the data source. Tableau can't give you the lat lon from a list of airports.
Great video ✈️, how to plot flight path connecting series of lat long on map.
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
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?
They are straight lines. For the airports, it will follow the curve of the earth since it’s zoomed out far enough.
@@vizwiz ok, so if you overlaid the street network it wouldn't coalesce, but rather go straight from one bus stop to the next?
Correct
@@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?
Adam Kapuscinski no. That’s overkill for what I was doing.
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?
Because you’re telling tableau to draw between two points. Tableau won’t follow roads. The map in the background is merely for reference.
How about for zip code that starts with zero, distance formula won't show the difference. Any thoughts??
The data needs the be lat/lon but zip code
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.
Great resource! Thanks!
Can u please provide me the link to download the Airline Routes dataset.
You can download the workbook and unzip it to get the data. Otherwise, a simple google search will find it.
Why I m not able to create makepoint functions? Any idea.. i have origin and destination lat longs
Are you in a really old version of Tableau?
@@vizwiz no i have 2022 and 2021 in both it's not shwoing
Awesome explanation, but I can not find the work book. can you please guide me in downloading the data.
Thanks,
H@ri
Harikrishna Radadiya there is a link in the description.
@@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
After you download the workbook, unzip it and you’ll see the twb and the data.
Superb..
how to convert coordinates to latitude and longitudes..
I don’t understand your question.
@@vizwiz Geometric Coordinates i mean
Isn’t it already in lat/lon?
@@vizwiz No ..
@@vizwiz No
Amazing :)
Amazing
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!
hahaha!
Wow this is wonderful there more I dig your videos @andykriebel I always learn amazing stuff.🤝🏽
That’s great to hear thank you. Spread the word. 😊