community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #124: Air Transport Network Analysis

Alteryx Certified Partner

For a bit of variation I chose only airports in the UK sized by betweenness with . You can see how dependent the Orkney and Shetland Island Islands on Kirkwall Airport

 

Challenge 124 - GIF.gifAirport connections within the UK

Spoiler
Challenge 124 - Capture.PNGChallenge 124 - Capture1.PNGChallenge 124 - Capture2.PNG
Aurora
Aurora

Like @ggruccio - a whole pile of trial and error - and finally came out with 275 airports.

Took me way too long to realise that there was no need to filter the "Node" input since that would just come out with degree of 0 if there were no connections!    You can see these on the chart as the circle of disconnected items around the edge!

 

2018-08-26_18-31-42.jpg

 

Great challenge @JoeM and team - thank you for giving us one that forces learning of a new tool!

 

 

 

Spoiler

Summary:
- First filter for Domestic and get rid of bad airport IDs by converting to integer (yes, I know this is lazy)
- do the first network analysis and filter for items with degree < 500 (leaves 5 airports)
- filter the routes to and from these 5
- re-run the network analysis on these airports  275 airports connected


2018-08-26_18-27-06.jpg
Quasar

Canada!  Not many airports for such a big country

Network.png

 

Spoiler
Solution 124.png

Dan

Alteryx Certified Partner

I really enjoyed this challenge! Just for fun, I added an extra bonus section that outputs a Tableau data source with a network analysis of my 3 local airports.

Tableau Public Link

Alteryx Network Analysis.png

 

 

Asteroid

Cheers!

Spoiler
Here is the workflow that I came up with and the final result.
Challenge_124_1.pngMy workflowChallenge_124_2.pngMy end solution
Asteroid

Here is my solution... for some reason... the render never works on my laptop...  

 

After having done my solution and figure out the inputs fields... I tried somebody else's solution and it does not render... any specific things to look into?

Alteryx Certified Partner

My first exposure to the Network Analysis tool.. UK airports only