Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #124: Air Transport Network Analysis

Highlighted
Alteryx Certified Partner
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

 

Airport connections within the UKAirport connections within the UK

Spoiler
Challenge 124 - Capture.PNGChallenge 124 - Capture1.PNGChallenge 124 - Capture2.PNG
Highlighted
16 - Nebula
16 - Nebula

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
Highlighted
17 - Castor
17 - Castor

Canada!  Not many airports for such a big country

Network.png

 

Spoiler
Solution 124.png

Dan

Highlighted
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

 

 

Highlighted
11 - Bolide

Cheers!

Spoiler
Here is the workflow that I came up with and the final result.
My workflowMy workflowMy end solutionMy end solution
Highlighted
8 - 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?

Highlighted
Alteryx Certified Partner

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

Highlighted
8 - Asteroid

5 airports.PNG

Alteryx Certified Partner

Here's my solution, using Iceland to speed up the rendering time.

 

I found the sample workflow for the Network Analysis tool very helpful in understanding how my inputs needed to be configured.

 

Help > Sample Workflows > Predictive tool samples > Predictive Analysis > 25 Network Analysis Tool

 

Spoiler
Screenshot 2018-12-30 at 01.18.26.png
Highlighted
Alteryx Certified Partner

My solution :)

Spoiler
challenge_124.PNG