The volume of potential data in any industry is tremendous but a great deal of effort is taken to convert this huge voluminous data to a usable format. Generally, visualization tools with geospatial capabilities or analytical languages such as python are considered for handling analytics related to geographical data.

To handle geospatial data in a simplified way, Alteryx has introduced a separate component – Spatial Analytics. It provides a unique way of doing analytic operations using geographical data with a single workflow. This blog will give an insight into spatial objects in Alteryx and simple demo of how those objects perform.

Spatial Analysis is the most intriguing and remarkable aspect of GIS. These tools will help you with critically important decisions that are beyond the scope of simple visual analysis. Alteryx uses the spatial objects as highlighted below to incorporate spatial analytics.

There are three types of data in this scenario.

  • Traditional data: Transaction data, customer data, Inventory data, Marketing data, Store data, etc.,
  • Spatial Data: Trade area data, GIS mapping data, Location aware mobile service data, Asset Location data, Drive time data, etc.,
  • Enrichment data: Demographic, Firmographic, Industry-Specific and Segmentation.

Our demo includes 4 tools:

  • Input Tool
  • Create a Point/Street Geo-Code Tool
  • Trade Area Tool
  • Spatial Matching Tool

Input

Using the Input tool, you can easily infuse the data from a variety of file formats. We use the Input tool to connect to two types of data sources 1. Customer database to retrieve Customer GEO location 2. Store database to retrieve Store location.

Consider a simple customer and Store dataset with Longitude and Latitude fields.
advanced-spatial-analytics-quick-look

advanced-spatial-analytics-quick-look

Street Geo-Coding /Create Point

The street Geocode tool will spatially enable your data by taking standard address information or latitude, longitude information and creates spatial points.

The Create Point Will plot the location using the Longitude, Latitude and creates the spatial Points.
advanced-spatial-analytics-quick-look

advanced-spatial-analytics-quick-look

Note: we can use the Street Geocoder tool to get the street level view of your map. To use that tool, we need to opt for the license of the Geocoder package and it must be installed along with the Alteryx designer. Please refer to the link given.

https://community.alteryx.com/t5/Location-Data-Knowledge-Base/Data-Products-101-Local-Installation/ta-p/355403

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Help-with-Street-Geocoder/td-p/34625

Trade Area Geocoding

The trade area tool is used to plot a path within a targeted area surrounding each location point. To create the drive time polygon, the Trade area tool will start at each location and traverse with the road map network until a point that specified. Eg: 10 miles

Non-Overlapping Drive Time Tool is used to create drive-time trade areas, that do not overlap for a point.
advanced-spatial-analytics-quick-look

Like customer data, we have the store data which has been plotted using create point Tool. Centroid value generated from the Create Point Tool has been given as an Input to the Trade area Tool, where we must specify the Radius/DriveTime. Here We have taken the Radius(5.0miles). The trade area tool will cover the area within the given radius.
advanced-spatial-analytics-quick-look

 

We have six store information. All the stores are plotted and covered the radius within the given coverage area.
advanced-spatial-analytics-quick-look

Spatial Match Tool

This tool will help to establish a spatial relationship between two sets of spatial objects. It will give the customers lists who falls inside/outside of the specified drive time. It used to combine the spatial points from the customer dataset with Trade area location polygons.
advanced-spatial-analytics-quick-look

Spatial Match tool is used to find the customer who falls in the given store’s radius for which it requires two inputs.

Target – The customer centroid value must be the input value for the Target.

Universe – Input value of the universe field will be the Spatial Object. The spatial Object output from the trade area will be given as input to the universe.
advanced-spatial-analytics-quick-look

Note: The intersection condition can be modified. Here we have chosen the condition as Target within the Universe.

We will get the two outputs in the spatial Match tool. One is the customer/records which satisfy the intersection condition, and another will be unmatched records.
advanced-spatial-analytics-quick-look

Green Dots indicates the Store Location and the Red Indicates the Customer.

Alteryx includes a certain set of tools to make advanced spatial analytics accessible to business users. Additional tools which include Distance Tool, Find Nearest Tool, Heat Map Tool.

 

Read more about similar Self Service BI topics here and learn more about Visual BI Solutions Microsoft Power BI offerings here. 

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com