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

 
E-Book
3 Machine Learning Use Cases That Immediately Benefit Planning and Logistics
Maximum results with minimal time investment — optimize your supply chain with these three machine-learning use cases.
  • Analytics Automation
  • Data Science and Machine Learning
  • Supply Chain
Read Now
 
Customer Story
Kingfisher Transforms People Analytics with Alteryx
Leading home improvement company based in London uses Alteryx to attract and retain talent and improve employee satisfaction.
  • Analytics Automation
  • Analytics Leader
  • HR
Learn More
 
Customer Video
All In with Iain and Ira
A match made in data heaven, Bulien & Kingfisher PLC showcase how Alteryx Auto Insights is helping Kingfisher operationalize their DE&I strategy with analytics.
  • Analytics Leader
  • HR
  • Retail and Consumer Goods
Watch Now