GIS Software Information
Mapping Analytics Software
Resources
Alteryx™
A Visual Workflow Tool for Transforming Data
SRC's Alteryx is a visual workflow tool that combines Extract, Transform and Load (ETL) capabilities with spatial processing. It allows you to rapidly access and transform multiple databases to provide geographic business intelligence in support of sales, marketing and operations challenges.
- Choose from a library of tools to select, combine, process and transform data into business intelligence
- Create and run customized data transformation and cleansing processes on multiple, disparate databases
- Add spatial intelligence to databases
- Clean and standardize address records
- Process 20-30 million records per hour
- Alteryx is available for onsite evaluations
How Alteryx is Used: Case Study
VF Corporation is one of the world's largest apparel companies, with brands that include Lee, Wrangler, North Face, Vans, Reef and Vanity Fair. Their goal is to get the right products, in the right stores, at the right time, in the right quantities.
With the help of Alteryx and SRC's data storage and retrieval engine, Allocate™, VF Corporation is able to better match products to consumer demand and more accurately predict assortments and other attributes at the individual store level. The process of linking and turning their data into knowledge and action has been taken from weeks to just minutes and often seconds.
Now VF Corporation can efficiently track 10,000 retailer locations, more than 100,000 SKUs and 200 lifestyle and demographic variables to help increase profitability and stay ahead of the competition.
Key considerations for VF Corporation in choosing Alteryx were:
- Integrated easily with existing applications
- Ability to import store level POS data in just minutes
- Accurate geocoding technology
- Easy-to-use
Alteryx Tools
Alteryx data processing tools are neatly organized into categories in your toolbox across categories. Each tool has a specific function. You can configure the tools into modules simply by clicking and dragging the tool into the document space. You link tools by clicking output arrows on one tool and dragging it to the input arrows on another tool.
The categories of tools include:
- Input/Output tools. All modules you create will contain inputs (data sources) and outputs (processing results). You can read or write directly to or from Oracle Spatial, SQL Server, Excel, Access, Spatial files or any other data format.
- Basic tools. Filter, Formula, Join, Select, Summarize, Sort and other data manipulation methods give you easy access to basic analytical processes.
- Advanced tools: Sophisticated, specialty data manipulation tools such as Cross Tab, Detour, Find & Replace, Fuzzy Match, Make Group and others allow you to combine, sort and analyze data to provide insight previously unattainable.
- Spatial tools: Spatial data manipulation, processing and object editing, including Create Points, Distance, Find Nearest, Geocode, Make Grid, Trade Area, Drive Time and more. You can also create maps, eliminating the need for an external GIS system.
- Portfolio tools: Offer the ability to use other SRC data engines such as Allocate and Portfolio Composer.
- U.S. Address tools: Standardize mailing lists and assign ZIP+4.
- Macros: sample modules that can be used as tools within other modules.
Alteryx Visual Workflow Module
Point, click and drag to access and transform data from disparate data sources.
View module
Download the Alteryx product brochure
Alteryx Case Studies
Comcast increases functionality, accuracy, and turnaround times on market analysis, reporting and mapping in 70 markets, resulting in increased zone buying from advertisers.
VF Corporation successfully tracks 10,000 retailer locations, more than 100,000 SKUs and 200 lifestyle variables for every store.