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
8 - Asteroid

Hi! Here my solution :)

 

 

Spoiler
Spain Airports
challenge_124.PNG

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution ... in my first approach, I missed the restriction to United States domestic flights and rendering took about 10 minutes.

Spoiler
26-03-_2019_18-58-41.png
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Just did the first 100 from the Join

Capture.PNG
Highlighted
11 - Bolide

Good opportunity to try a new tool! It took a good bit of trial and error to get the inputs right. I picked 100 random airports in the US.

 

Spoiler
challenge_124_network.PNGchallenge_124_workflow.PNG
Highlighted
8 - Asteroid

I am begginer and my map is far from network visualization.

Highlighted
8 - Asteroid

I really love playing with data like this. Using these sorts of tools to be able to give unique insights is really exciting, I wish I had these sorts of tasks at work. 

I attached the analysis of BNA (Nashville) to celebrate Inspire. 

 

Spoiler
BNA Analysis.PNGZH Workflow.PNG
Highlighted
Alteryx Partner
Spoiler
124. Predictive.PNG


Used my (old) home airport Birmingham International, UK, as my test. Googled around to figure out the format I needed, and then was stuck with errors because one of the route I had wasn't in the airport list.
Highlighted
Alteryx Certified Partner

my workflow:

Spoiler
124.png
Highlighted
8 - Asteroid

Instructions are bit open ended. Came up with a network.

Highlighted
Alteryx Certified Partner

I went for the UK's domestic flights, thankfully only 309 of them

Spoiler
Challenge 124.PNG
I couldn't persuade the render tool to output a temp html, so here's a gif of the very excitable network:
challenge 124.gif