Engine Works

Working in finance, I’m somewhat bummed that I don’t often get to explore the possibilities within location-based data. That’s why I was thrilled when a project fell into my lap to visually analyze taxes paid across German villages.

In this article, we’re going to explore how we can leverage Alteryx to run analytics on fishing reports in Southern California. You’ll learn how to use web scraping to pull in data from 976 Tuna, macros to automate the cleansing process, spatial analytics to better understand where the fish are biting, reporting tools to visualize our analysis, and the Alteryx Server to automate this on a weekly basis.

How do you deal with spatial data that is geocoded to one address/location?

Having in-depth demographic information is often seen as the holy grail in the eyes of data analysts and their business stakeholders, and there is a good reason why: the context that can be added to your analytics, as a result, is hugely advantageous.

I have recently been tinkering with spatial requirements from clients and have found myself inside of a rabbit's hole. The result was the creation of a new macro, Find Closest. 

Getting started with spatial analytics in Alteryx.

I love building Alteryx workflows. I love working for Alteryx. I cannot begin to describe how much I loved doing this project for Luvin Arms. Their use case was so simple, yet without software – so overwhelming.

Last weekend was the climax of nearly two months work as part of my Alteryx for Good project. This work has encompassed huge amounts of data preparation (particularly using open data that was recently released by the UK’s Department of the Environment, Food and Rural Affairs – DEFRA), spatial analytics and advanced analytics. All this hard work culmlinated in a 12-hour focussed data dive to show the charities involved the ‘art of the possible’ in terms of using such amazing data sources in combination with analytics.

This post shows users how to add their own spatial layers to Alteryx Maps. 

Alteryx has many different use cases ranging from big data diving to process automation to demographic reporting, but one feature that has always stood out for our customers is the ability to geocode an address within an Alteryx data stream by utilizing our native geocoder.