community
cancel
Showing results for 
Search instead for 
Did you mean: 

Location Data Knowledge Base

Data methodologies, and Release schedules.
 You are using an unsupported browser for translation. Please switch to another browser.

If you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool.
View full article
Question I have a list of zip codes, can I use Alteryx to determine the city they're in? Answer The answer is yes! But with a few caveats. Zip Codes can be notoriously difficult to pair with cities they belong in because they exist in two forms; points and polygons. Point Zip Codes are generally associated with buisnesses or universities, while polygons generally encompass residential areas. Alteryx data does have Zip Codes with Points data; however, it is not immediately accessible and will require some configuration on the part of the user to get access to that level of data (See Related Links for an article on this process).   Zip Codes are also frequently adjusted, deprecated, and consolidated by the USPS, so depending on the age/vintage of the zip codes in your data as compared to that in the Alteryx Spatial Database, there may be some slight variation there as well. All said, users should still expect a reasonably high match rate.    To start, make sure you either have the Alteryx Data Package installed (available with a license), or you have the 2010 US Census data installed (available for free at http://downloads.alteryx.com/data.html).   With the the data installed, the first thing you will bring down is an Allocate Input Tool. Here you will choose the relevant dataset (Experian data or US Census) from the drop down, then check the box for Zip Codes under Pick Geography. If you have followed the advice from the related link, you can also choose Zip Codes w/ Points to include the expanded dataset.   From here you will use the Join Tool to join your data to the Allocate Input data based on your Zip Code field and the Key field of the Allocate Input data. [NOTE: the Zip Code and Key fields will both need to be either String fields or numeric fields. Either is fine as long as it is consistent]   The resulting data that comes from the J output anchor of the Join tool will contain all of your Zip Codes that matched those in the dataset. The field "Name" that comes from the Allocate Input is formatted as the 5 digit Zip Code, followed by the City name. From here a simple Text to Columns tool configured to create 2 columns and parse on the space, will create a field specifically for the City and an extra Zip code field that can be deselected and discarded as the data moves down your workflow.    See an example of the process in the attached v10.5 workflow below.
View full article
You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…   CASS is here to help!
View full article
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
View full article
 Unfortunately at this time, non-U.S. and Canadian geocoding is performed via API calls, and as such, requires an Internet connection.
View full article
How to troubleshoot when the Allocate Append tool returns zeros. 
View full article
Hi everyone!   The Q4 2018 Business and Location Insights data packages includes analytics-ready data from a variety of vendors as well as data-specific analysis tools to get the most from the packaged data. All data packages will be available via the Downloads & Licenses portal later today. US & Canada Business Insights customers should receive their hard drives later this week, but you are also welcome to download the data from the portal.   Here are a couple important notes for this release. Please see the product specific release notes for more information. Product name change (does not affect product contents): US and Canada "Data", which includes demographics, business lists, etc., are now called "Business Insights" All "Spatial" packages are now called "Location Insights" DigitalGlobe Satellite Maps base URL changed to whitelist.alteryx.com/v1/dgmaps/v1. See this post for more details.   All documentation packages included in the attached .zip file. Please let us know if you have any questions or concerns.   Happy Alteryxing!   Jerad Rades Team Lead, Data Products   Note that this post includes a corrected version of the US Data Variable List that was not included on the hard drive or via the Downloads & Licenses portal. The correction corresponds to TrueTouch variables within the ConsumerView dataset - there were no new variables with the Q4 2018 release.
View full article
Hi all,   Effective with the Q4 2018 data releases, the base URL referenced in the .map files that render DigitalGlobe Satellite imagery is changing from dgmaps.alteryx.com to whitelist.alteryx.com/v1/dgmaps/v1. This change was made to align with our System Requirements. As we already recommend that customers have whitelist.alteryx.com listed as a safe site, we don't expect this to impact our customers.   Customers can still use the Q3 2018 DigitalGlobe data if they run into network issues. Any network-related issues should ultimately be resolved by whitelisting whitelist.alteryx.com.   Regards,   Jerad Rades Team Lead, Data Products
View full article
Data Products 101 Part 1: Installing your Data (Network & Command Line)   This article will walk through the Network data installation process and is intended for Admins. If you are looking for a guide on the standard local installation process, then check out our article on Local Data Installation.   Network Data Install (Advanced)   Considering that the entire US Business Insights bundle is around 180GB, we often have cases where a user will run out of hard drive space during the data install. If you find yourself in this boat and are on a company network, you can resolve your space issues by performing a network install with the Alteryx Data Installer.   This can also potentially save a huge amount of installation time when you have multiple users for the Data Bundle. Instead of performing this lengthy install numerous times – once for each user – you can install once and be done.   The downside to a Network Install is performance. A Local Install will almost always have better performance, as a Network Install is limited to network speeds and read/write times on your network drive.   A Network Install consists of two operations:   1. Preparing the Network Installation – contents of the Alteryx Data Install are copied to and prepared on your network location.   2. Registering the Network Installation – where each of your users navigate to the prepared network location in order to register the data sets to their machine.   To Prepare a Network Installation:   1.  Follow Steps 1 – 4 within the (Local Installation process article)[hyper-link here].   2. You should now be at the Location screen - choose ‘Prepare a Network Install’ and browse to the shared network location where you wish to install. Be sure that all users have the same configuration if you're using a mapped network drive.    At a minimum, each of your users will need read access to this location. If you plan to install CASS to this network location, then your users will also need write access to this location.   Click ‘Finish’ after selecting the network location and let the Alteryx Data Installer run.     3. Once the installation is complete, each of your users will need to register the Prepared Network Install to their computers.   To Register a Network Installation:   1.  Each user will need to navigate to the location where you Prepared the Network Install. Once there, run ‘AlteryxDataInstall.exe’ and follow Steps 1 – 4 as outlined under the Local Data Install guide. On the Location screen, select ‘Register from a Network Location and click ‘Finish’.     2. The installation process should take no more than a couple minutes to copy over a handful of files to the user’s computer (sample data, etc.). Once done registering, the user can immediately start accessing the installed data in Alteryx.     Command Line Install (Advanced)   The Alteryx Data Installer also has command line operations for all of our IT users. Please refer to our Command Line documentation for more details.
View full article
Data Products 101 Part 1: Installing your Data (Standard)   So, you just bought one of the Data Bundles from Alteryx and you’re excited to dive in and start exploring Location and Business Insights for your company – but where do you start? How do you get access to this Data? Well, unlike a SQL database or CSV you might be used to working with, you’re going to start by installing these Data Products. This article will walk through the standard data installation process. If you are an Admin and are interested in a Network or Command Line installation, check out our article on Data Installation for Admins.   Prerequisites   First and foremost, do you have your Data Package yet?   If you purchased either the US or Canada Business Insights bundles, you should have received a hard drive in the mail. If you have your hard drive plugged in and read, then go ahead and skip to Step 1 below.   If you purchased one of our Location Insights spatial bundles, then head to licensing and download portal and download the data. Assuming you have your Spatial license key activated, it’ll be under the Data Packages tab on the left – just click on the bundle you wish to download and then the .7z file you wish to download. Pay attention to the vintage tag as you’ll want the most recent quarter’s data.       Be sure to extract the .7z package after you’ve downloaded it. We recommend creating a new folder that you will extract into – instead of extracting everything onto your desktop.   If you haven’t received your US/CAN Business Insights hard drive yet, or don’t see the Data Packages tab on the Licensing and Downloads portal, you should reach out to our Fulfillment Team for support.   Local Data Installation Steps   The local data install is the standard installation type. First, you’ll want to make sure Alteryx is closed. Next, either plug in your Alteryx Data hard drive or navigate to wherever you extracted the data from the Licensing and Downloads portal and run the ‘AlteryxDataInstall.exe’ to launch the Alteryx Data Installer.   1. Click Next when the Welcome Screen appears.     2. Read and Accept the license agreement then click Next.     3. Select the data sets you would like to install. If you want all of them just click the All button on the right. Otherwise, you can select individual Data Products by selecting the check box next to them. After you’ve made your selection, click Next.     4. Choose any previously installed Data Products that you would like to uninstall by selecting them similarly to the previous screen. You don't have to choose anything here if you want to keep everything, however, keep in mind that these data bundles can be very large and you may not have enough space to keep multiple vintages installed locally. After you’ve made your selection, click Next.     5. Leave ‘Install to a Local Directory’ selected and browse to the file path you would like to install the data to. The default path will be auto-populated but if you'd like to install it somewhere else just update the path. Make sure the hard drive you install the data to has enough space. For instance, the US Business Insights bundle takes up over 180GB and we recommend 500GB of space for Alteryx Designer – so you will want to have at least 700GB available.   Once you’ve selected the install path, hit Finish and let the Alteryx Data Installer run.   Feel free to kick back and relax now – as this will take some time. An install of the entire US Business Insights bundle may take well over 3 hours depending on your hard drive write speed.       6. When you get to the ‘Complete’ screen you’re done. Now you can load up Alteryx and start diving into Business and Location Insights!       If you’re unsure where to get started with actually using these Data Products, then be sure to check out Part 2 of my Data Products 101 series. Stayed tuned for more to come!
View full article
The Q3 2018 Canada Spatial Data includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes, variable list and change log Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?     Sample workflows included with the data installs are now grouped within a top-level “Data Install Samples” category   Please download and extract the attached 'Q32018_CA_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 UK and Republic of Ireland (ROI) Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_UKROI_Spatial.zip' for the complete documentation.  
View full article
The Q3 2018 Europe (EU) Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_EU_Spatial.zip' for the complete documentation.   Countries included in this install are:   Andorra Austria Belgium Croatia Czech Republic Denmark Finland France Germany Gibraltar (British Overseas Territories) Hungary Italy (including Vatican City) Liechtenstein Luxembourg Monaco Netherlands Norway Poland Portugal San Marino Slovakia Slovenia Spain Sweden Switzerland
View full article
The Q3 2018 Brazil Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_BR_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 Australia & New Zealand Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_AUNZ_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 Canada Data package includes analytics-ready data from TomTom, Dun & Bradstreet and Statistics Canada as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes, variable list and change log D&B Analytical file - data description, SIC lookup code, penetration report Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?     1600+ Language Characteristics variables from the Statistics Canada 2016 Census regarding “mother tongue” and “language spoken at home” Business Summary built for Statistics Canada 2016 Dissemination Area inventory Sample workflows included with the data installs are now grouped within a top-level “Data Install Samples” category   Please download and extract the attached 'Q32018_CA_Data.zip' for the complete documentation.
View full article
The Q3 2018 US Spatial package includes analytics-ready data from TomTom and the US Census as well as data-specific analysis tools to get the most from the spatial data. The documentation package attached includes –   Release notes, variable list and change log Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?   Sample workflows included with the data installs are now grouped within a top-level "Data Install Samples" category Annual updates for Places, Other Name Places, CBSAs, and CCDs/MCDs   Please download and extract the attached 'Q32018_US_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 US Data package includes analytics-ready data from TomTom, Experian, Dun & Bradstreet and the US Census as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes, variable list and change log Experian CAPE demographic data methodology document, Mosaic segment descriptions Experian ConsumerView Analytical file – user guide and penetration report Simmons overview D&B Analytical file - data description, SIC lookup code, penetration report Kalibrate Technologies traffic count overview and metadata Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?   Sample workflows included with the data installs are now grouped within a top-level "Data Install Samples" category Annual updates for Places, Other Name Places, CBSAs, and CCDs/MCDs   Please download and extract the attached 'Q32018_US_Data.zip' for the complete documentation.
View full article
Shipping and Gallery schedule for data delivered to licensees of Alteryx Designer with Data, Alteryx Designer with Spatial and CASS.  
View full article
The Brazil (BR) Spatial Data includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Release Documentation download: http://downloads.alteryx.com/ReleaseDocumentation/Q32017_BR_Spatial.zip
View full article
Labels