Alteryx Abacus – version 1.2

The latest release (version 1.2) of my Alteryx formula add-ins project (now called Alteryx Abacus with thanks to Chris Love) is now available. These are a set of utility functions for use wherever a formula can be used within Alteryx. The functions are developed in C++ and XML using the Alteryx SDK. You can download…

Unaffordable Country In Apache Spark

Back in September last year, the Guardian published a fantastic visualisation looking at house price affordability in the United Kingdom. They took the Prices Paid data from the Land Registry and computed some descriptive statistics about it, such as the median and range. The raw data is easily available from data.gov.uk, and they provide monthly,…

Highlights from the Inspire Europe Conference

Last week, I attended the Alteryx Inspire Europe conference at Kings Place, London. This was the first time they had hosted the event outside of the US, and it was a great success with fantastic speakers and events, as well as selling out to over 400 people. The night before the conference kicked off, about…

Geocoding and Finding Nearest Station with Google Web Services

This posted started as a question on the Alteryx community about finding the nearest underground (subway if you prefer!) station to an address. I don’t have much experience working with addresses and map data, but thought their was probably a way leveraging the APIs Google maps provide. This feels very much like “standing on the…