Don't miss Inspire 2024, taking place May 13 - 16, 2024 at the Venetian, Las Vegas. Register Now.

Use Case

Site Selection Optimization


Site selection has always been a high-risk process for retailers, often characterized by decisions made across multiple siloed data sources. Now retailers can sharply reduce risk in their site selection process by overcoming silos, integrating spatial and non-spatial data, and applying on-demand analytics.

Top-Line Growth

Place new locations in areas where your product is in highest demand

Bottom-Line Returns

Optimize product mix and reduce out-of-stock conditions

Risk Reduction

Fully understand factors that affect location performance


Business Problem

Most retailers select sites using a combination of competitor insight, market data, location planning, and strategic fit. It’s a data-driven decision because investment in a retail location involves the upside of increased market share with the downside of real estate risk in a given area. Even though most retailers have abundant data available, that data often resides in spreadsheets or silos around the organization, or in limited mapping and reporting tools. Pulling together a risk profile of a particular location is a labor-intensive process fraught with error.

Analytics Solution

Spatial analysis enables companies to blend geographic and descriptive data together from a variety of sources and use that data in geographic models and visualizations. In a form of geographic business intelligence, companies build models from geospatial data on locations, relationships, and attributes. Spatial analysis goes beyond the traditional Geographic Information Systems (GIS) framework of displaying descriptive information on a map, now reaching into data science and machine learning. The combination of cloud computing, geospatial data, on-demand analytics, and rich reporting pushes BI-based insights down to the level of individual stores, departments, and product categories. For retail site selection that means that property managers can incorporate point-of-sale data into their selection and forecasting models. They can include previously impractical data on urban storefronts, shopping centers, endcaps or pads, parking, view corridors, and zoning.

With Alteryx, you can:

  • Download the Spatial Analytics Starter Kit to combine customer value data, customer location, and new store location data to analyze customer behavior and increase top-line revenue.
  • Create store trade areas based on customer distance to stores to put products in the hands of more customers.
  • Blend spatial data to calculate ad area distribution, increase sales, and reach more customers.

1 – Data Connection

Pick relevant geographic variables from datasets using Allocate Input Tool

2 – Prep & Blend

Use Running Total Tool to enrich imported data

3 – Data Visualization

View optimized routes or connect directly to supply chain software


Additional Resources

Starter Kit for Spatial Analytics
Learn More
Starter Kit for Intelligence Suite
Learn More
Starter Kit for Tableau
Learn More
Starter Kit for Snowflake

Learn More

Recommended Resources

Analyst Report
Nucleus Research – Alteryx Highlights AI and ROI at Inspire 2023
At Alteryx Inspire 2023, Alteryx announced various new and extended capabilities to improve its value proposition for certain users or use-cases. This includes expanded cloud platform experiences, cloud-based Location Intelligence for spatial analytics, integrated generative AI capabilities with Alteryx AiDIN, and the Alteryx Maveryx user community.
  • Analytics Maturity
  • Company
  • Analytics Leader
Read Now
Customer Story
Taste the Feeling Coca-Cola Alteryx
Over 1.9 billion Coca-Cola beverages are enjoyed daily around the globe.
  • Cloud Products
  • Data Prep and Analytics
  • Designer
Learn More
Customer Story
Amway Adapts to Product Hierarchy Changes in Minutes
Amway migrated its data to Google Cloud BigQuery and centered its product hierarchy around Google Cloud Dataprep.
  • Cloud Customer Spotlight
  • Cloud Products
  • IT Professional
Learn More