Today's challenge was to connect to the AviationAPI and use alteryx to perform some spatial analysis, we had to use the reporting tools that are in alteryx and then publish our work to the server.
I started off by looking back at the blog that I had written about how to connect to APIs and this helped me a lot as it is not something I have been practicing regularly. I wanted to first connect to the data and then see what sort of fields I would have to then base my analysis off of that.
Once I had realised that I had airport locations I wanted to look into which areas of the US are underserved by the amount of airports in that area. To do this I looked at an airport and then looked at its closest 5 airports averaging the distance between them. I then only kept the 5 airports with the largest average distance. This is because i was seeing which airports are most isolated and thought that looking at the 5 closest airports was would give a more accurate representation of isolation than just looking at the single closest. I then decided to supplement my analysis by looking at population data and trying to see if the top 5 most isolated airports in the US where in highly populated areas.
I spent the day struggling with APIs, as it wasn't pulling through all the data so my analysis was based off of 158 US Airports, A quick google will show that there are over 5,000 airports in the US so my analysis isn't an accurate representation of the US, however I decided to continue with my analysis despite the lack of data to show the proof of concept that I had thought up.
I think the day could have gone better, but I am happy that I was able to produce something to present and that there was a clear angle of analysis. I think that the analysis could have been more detailed, but I think I did okay given the circumstances.
I am also writing this blog 30 minutes before presenting and therefore will use the remaining 30 minutes to practice my presentation.