Flight Network in Tableau

Tableau is notoriously good with tabular data but it gets frustrating to use when it comes to representing flight network, which involves spherical calculations that Tableau does not support.

Now, say you are looking into the flight pattern of an Airline and you want give your audience a one-snapshot of the said Airline. Your center-piece will probably be a nice map of the network meshing and this is where it gets tricky: As Tableau represents flight segments as flat lines (as opposed to Great Circle lines), you end up with a mediocre visualization like the following: 

JFK - LHR Flight - Straight Line


In order to have nice curves, I resorted to pre-processing the data and calculating the intermediary points for each segment with a short Julia code snippet (available here).

I chose Julia to evaluate this new tool whose selling point is to be as fast as C and as high-level as R. If you check out my github, you will notice how familiar this language looks. 

The script creates a point every 500 kilometers (~300 miles) for each flight. The final result looks like an actual flight network!


Case in point with VX (Virgin America):



The trick is to approximate a great circle curve by a series of mini-segments. Note that the output is bigger since the data is now at the said mini-segment level.

Good luck!

PS: The data used is from Openflights. I noticed that there are errors in the dataset (such as Jet Blue flying to Dubai that is probably an codeshare-AA flight) so use with caution.

Comments

Post a Comment

Popular posts from this blog

My new job at Lyft

Image
In October, I joined Lyft as Data Science Manager for Core Mapping. I wish I could have posted this update a while ago but a big event got in the way (yes, we went public) ... While low visibility, Mapping turns out to a big deal for ride-sharing as it has influence on a lot of other services. In a nutshell, Mapping has an impact on pricing, driver dispatch, scheduled rides and customer XP. Also, it is usually the biggest friction point for seamless pickups. Why is Mapping important for ride sharing company ? Mapping has traditionally 4 components: Basemap (representation of the world as a graph), Locations (where are drivers, passengers ?), Routing (optimal paths between locations) and ETA (distance and time between locations). When you open your app, you see the following screen: A lot of information displayed is connected to the work by my team: The surrounding physical world : road segments, (train) stations, POI The pick-up ETA (3min) looks at drivers around t
Read more

5 rules for a productive Science team

Image
Data Science is a new discipline. As such, companies (incl. Tech) are still trying to figure out the optimal configuration for the team. However, there are a few guiding principles that are important to follow so that your Science team does not fall apart. I have complied my own in this blog article and I'm sharing them with you to generate a discussion: 1- Have a single source of truth During my consulting years, I cannot recall how many of my clients had challenges that emerged largely from a single problem: teams looking at different data.  Aligning on metrics and methodology is very important as it forces the team(s) into a "single view of the world". Without agreement, team progress is hampered due to definition conflict, and confusion (when metrics disagree). In practice, this can be achieved through a single "fact table", adequate documentation (with thorough definition and pointers to code) and availability of metrics where they matter
Read more

Focus: Shapley value

Image
Game theory is a fascinating topic codifying and quantifying all sorts of interactions between stakeholders in a game. The most popular setup is the prisoner's dilemma but there is much more to it. Today, we will cover the Shapley value as I recently stumbled across this original yet relatively unknown concept. Problem at stake : Example 1: In a salary negotiation, the employee showcases his skills and what it brings to the company. But how much are these skills worth ? Example 2 : In a Joint Venture, each founding company brings expertise. What’s a fair distribution of the ownership/shares ? Example 3 : 2 (or 3) TelCo companies want to build a fiber network that would benefit both. What’s a fair payment breakdown ? When you think about these problems, most of us would tend to answer them through guesses: “You should ask for X% raise because you deserve it” but there is actually a theory for it Let’s look at the theory behind. Solution : This is kn
Read more