Alteryx Designer: The Definitive Guide

Chapter 16. Address Analysis

In this chapter, we are going to explore an area of analysis in which Alteryx Designer is particularly strong: address analysis. I am going to walk you through address analysis, which involves looking at physical addresses from both an accuracy point of view and a location perspective. As you go through this chapter, start thinking about all the other types of analysis you could do using addresses. Many times, when we are looking to blend data from various sources, we’re always looking for a unique identifier and an address is often used as that, but you must make sure that it’s accurate. Just because you might not have a specific tool created for it doesn’t mean it can’t be done. Think about areas of focus in your work today and consider how Alteryx Designer might help you. Ready? Let’s get into it!

Introduction to Address Analysis

In the context of Alteryx Designer, address analysis is the examination of physical location addresses that are used to clean and prepare address data for further use in either geospatial or customer use cases. The end goal of doing this analysis is to have a clean data set that contains valid addresses that could be used.

Let’s be clear on what constitutes good address data or bad/dirty address data. With bad/dirty address data, you see things like incomplete addresses, ambiguity like missing apartment or unit numbers, inaccurate street spellings, and missing zip codes or postal codes. This data is not valuable. You can’t ...