Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #124: Air Transport Network Analysis

RichoBsJ
11 - Bolide

Hi! Here my solution :)

 

 

Spoiler
Spain Airports
challenge_124.PNG

 

 

RolandSchubert
16 - Nebula
16 - Nebula

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
Kenda
16 - Nebula
16 - Nebula
Spoiler
Just did the first 100 from the Join

Capture.PNG
kelly_gilbert
13 - Pulsar

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

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

ZenonH
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
TimothyManning
8 - Asteroid
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.
RWvanLeeuwen
11 - Bolide

my workflow:

Spoiler
124.png
MattBenj
9 - Comet

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

OllieClarke
15 - Aurora
15 - Aurora

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