At this point, we have a very useful dataset for analysis in Tableau Desktop, but there's a bit of additional transformation we might want to employ. What if we wanted to render the flight paths in this dataset on a map? One approach in Tableau Desktop requires a dataset with two records per path: a record with latitude and longitude for an origin point and a separate record with latitude and longitude for a destination point.
Our dataset currently contains a single record for the path. We have a field named Route that contains values such as DAL-PHX and DFW-JFK. These pairs of values give us the origin airport code and destination airport code. With a bit of supplemental data and a transformation of the ...
