Week 3

Last week at the Data School was packed with loads of exercises and presentations that covered a wide variety of analytical and soft skills.

Peter Kokinakis, COO at MIP Australia, lectured the team on the best practices of communication methods. Steven Goffe, the Services Director at MIP, expanded on that lecture by introducing  us to the basics of AGILE Project Management and the SCRUM method. On the analytical side, MIP’s Nick Duncan and Ayelavan Nimalandren covered APIs, Predictive Learning, Macros, and Spatial Analytics in Alteryx.

On Friday, we revisited all the learning outcomes of the week. Our task was to collect spatial data using the Google Places API, create an iterative Macro that appends this data, export it as a .tde ( Tableau Data Extract) and create a dashboard to present at the end of the day.

In this blog, instead of presenting what I did on Friday, I decided to include something I worked on at the weekend.

Spatial Analytics

On Saturday, I came across a UFO Sightings Data set on Kaggle that contained the history of UFO sightings in the United States. I then decided to blend airport spatial information to this dataset to examine the correlations between people reporting unidentified flying objects and the proximity to the airport of the reported incident. For that purpose I used three alteryx spatial tools.



From the Lat and Long Data I collected I created the Spatial Objects ( Centroids) using the Create Points tool, then used the Find Nearest tool to filter all the ufo incidents within 15 km of an airport, and finally used the Distance tool to calculate the distance between the incidents and the airports.

Tableau Dashboard

The dashboard below shows the story behind the sightings and the correlation with proximity to Airports.


Looking ahead for next week, CLIENT WEEK !