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

Location Data Knowledge Base

Data methodologies, and Release schedules.
The UK and Republic of Ireland (ROI) 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/Q22017_UKROI_Spatial.zip
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/Q22017_BR_Spatial.zip
View full article
The US Spatial Data 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 includes – Release notes, variable list and change log Spatial products include documentation on drive time methodology and Alteryx map layers   Release Documentation download: http://downloads.alteryx.com/ReleaseDocumentation/Q22017_US_Spatial.zip
View full article
The Australia and New Zealand 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/Q22017_AUNZ_Spatial.zip
View full article
The Europe (EU) 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 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    Release Documentation download:  http://downloads.alteryx.com/ReleaseDocumentation/Q22017_EU_Spatial.zip
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
Question:  A data artisan isn't receiving notifications of CASS updates. How can they be added to the CASS list? Or how can someone be removed from the notification list? Since CASS expires every 2 months, being notified is important.   Answer:  Send an email to fulfillment@alteryx.com with the email addresses for inclusion or removal  
View full article
When using the Demographic Analysis tools in the Alteryx Designer there are two types of variables you’ll be able to utilize from the Allocate Engine: built-in and virtual variables. Built-in variables are the most granular demographic measures the engine offers and virtual (custom) variables are calculated from these built-in variables. If you’re interested in taking a look at the underlying formulas that constitute these variables, there are two ways to do so:   Through the Alteryx Data Products GUI   You can find the Alteryx Data Products Allocate Interface in your start menu   From here just locate your variable in the “Variables” tab   Then select “File” and “Variable Information”     The Allocate Metainfo tool In the Allocate Metainfo tool select “Variables”     After running the workflow, the list of variables in your chosen dataset will be output, along with their constituent formulas (if they are virtual variables) You can also create your own custom variables! For your reference, a list of demographic variables that are included in the Alteryx Data Packages can be found here.
View full article
The US and CA Data and Spatial Bundles contains many datasets, including the Melissa Data CASS engine.  While the US and CA Data Bundles are updated every quarter, CASS is updated every 2 months.  Luckily, the install file size for CASS is just over 1gb, so we are able to provide this update as a download.  Once downloaded, a few simple steps will get you on your way to using the most updated version of CASS. On occasion though, users have reported a few issues with being unable to utilize CASS.  Because of this, we have decided to provide full download and install instructions, with a final portion of frequent questions and issues.   To install the latest CASS: Download the latest version of CASS.  This is sent via email from Alteryx Products on a bi-monthly basis and will be in the format of the following: http://downloads.alteryx.com/CASS_US_CAN_20YY_MM.exe YY is the current year and MM is the current month release of CASS.  Double-click on the .exe file.  This starts the 7-Zip Self-Extractor.  Choose a location where you would like to extract the install files. IMPORTANT: This does not actually install the files, it only extracts the install files. Once the install files have been extracted, located and double-click the file DataInstall.exe.  This will be in the directory you just extracted to in the previous step. When the install dialogue pops up, check the box to accept the license agreement and click Next. The next screen allows you to select datasets to install.  Depending on which install you've chosen, you will see the option to install US, Canada, or both versions of CASS.  Check all boxes, then click Next.  This screen displays all current datasets installed on your machine.  Checking any box here will uninstall the dataset.  By default, the previous version of CASS will be checked for uninstall.  Make sure all prior versions of CASS are checked, then click Next. IMPORTANT: You must uninstall all previous versions of CASS during this process.  If you have any expired versions of CASS on your local machine, no other versions of CASS will work properly. Browse to the directory you wish to install CASS to, then click Finish. Once the above steps have been completed, you will be able to use CASS on your local machine. FAQ/Common Errors: Error: CASS (2): CASS is not installed properly or it has expired. Please contact your reseller or Client Services at 1-866-516-2400 1-866-516-2400  FREE to receive an updated CASS database. This is often because a prior version of CASS is still installed.  Re-run DataInstall.exe and make sure all prior versions of CASS are checked in the Uninstall screen. CASS was installed on a network drive and permissions are not allowing you to see it.  Try re-running DataInstall.exe and install CASS on a local drive. Error: CASS (1): The Melissa Data CASS engine appears to not be installed (can't find dll). This is often the result of mismatched registry entries or install folders.  Please contact support@alteryx.com for resolution. In most cases, the solutions for error 1 above will resolve your issue, but if not please don't hesitate to reach out to support@alteryx.com for handling. Thanks, and until next time! Chad Follow me on Twitter! @AlteryxChad 
View full article
This note is to alert users of 2010 Census SF1 Data in the Core and Spatial Data Bundles (including Q4 2015) of the reversed values in a report template. The report SF1 2010 Report - US Census 2010 Overview Comparison reflects reversed values for % Hispanic and % Not Hispanic. The corrected report will be included in Q1 2016.  This report can also be updated in a desktop install now by overwriting the existing report template with the corrected report template.   Action required: Replace the incorrect report template file Close open instances of Alteryx or Allocate Download, unzip and extract US Census 2010 Overview Comparison.rptx from the Community Article to the local Alteryx location. A typical install location is C:\Program Files (x86)\Alteryx\DataProducts\Portfolio\ALTERYX_US_Census_2010_SF1_15D\Reports Overwrite the existing template dated from 2011 with the updated templated dated 4/18/2016 Launch Alteryx or Allocate and generate output for the report SF1 2010 Report - US Census 2010 Overview Comparison  If you have other concerns or need assistance with these instructions, please contact our Customer Support team at support@alteryx.com.   How do you know if the report is corrected? Generate the report SF1 2010 Report - US Census 2010 Overview Comparison for the United States and review the fields % Hispanic and % Not-Hispanic. Depending upon the version of data installed the values may differ slightly but the proportions will be similar to the image below.     If you have other concerns or need assistance with these instructions, please contact our Customer Support team at support@alteryx.com.  
View full article
Question Why do values in the ConsumerView HH & Individual fields contradict the Household Composition Code?  Sometimes other field values in a CV household record don't support the description of the Household Composition value.  For example, there might be two adult females in a household record but the Household Composition is A (HH w/1 adult female).  Or another record has 2 adults with a Composition code of B (HH w/1 adult male).  Answer   The first thing to note is the ConsumerView file delivers 6 of up to 8 persons in a Living Unit.  Not every person is delivered which may impact the Household Composition Code.  Another consideration is the description does not define the exact makeup of the household.  For example, a Household Composition code of "A" (HH w/1 adult female) does not mean this household is exclusively made up of a single adult female.   Household Composition - This field is calculated based on gender and children present in the Living Unit.  On the Household Composition, Experian looks at everyone in the Living Unit provided to them and determines how many adults are present in each Living Unit, gender of those individuals and if children are present in that living unit, coding them according to the codes chart. * A = HH w/1 adult female (no adult male, no child) * B = HH w/1 adult male (no adlt F, no child) * C = HH w/1 adult female and 1 adult male (no child) * D = HH w/1 adult female, 1 adult male and children present * E = HH w/1 adult female and children present (no adult male) * F = HH w/1 adult male and children present (no adult female) * I = HH w/2 or more adult males and children present (This does not mean there is not an adult female present in the household) * J = HH w/2 or more adult females and children present (This does not mean there is not an adult male present in the household) * G = HH w/2 or more adult males (An adult female can also be present in household, no child)) * H = HH w/2 or more adult females (An adult male can also be present in household, no child) * U = Unable to code   Records coded with C and D are typically scenarios where there's a male and female with/without children.  I - H could be one of these situations below: 1.) Scenarios where an elderly parent living with their adult children. 2.) Roommates (both male and female, young and old) 3.) Scenarios where a married couple allows an in-law (the brother or sister of a spouse) to reside with them 4.) Scenarios where a relative (uncle, cousin, etc.) may live with their relatives 5.) College age children (ages 19+) living with parents.   When might the Household Composition value not match the houehold attributes?  In one scenario, 2 Adults in a household with a Code of "A," more than likely there are two female adults in the household. This could be a roommate situation, it could be a mother and older daughter. Only one female may be a PDM in a household. Because of this, the record would receive the Household Composition code of “A” meaning a household with one adult female even though there are two adult females present.    In the "Question" example of  two adult females in a household record but the Household Composition is A (HH w/1 adult female), this household looks as if it is more likely two sisters residing together as the ages are close together. One is listed as the PDM, the other is listed as the other adult. The system assigned the living unit an A denoting the female PDM.   The second "Question" example of 2 adults with a Code of "B" may be a household with a parent living with adult child situation. The adult child is coded as the PDM and the other person is only an initial and coded as the other adult. The system assigned the living unit a B denoting the male PDM.   In situations where fields in specific records are questionable and need further validation, provide those records to data_products@alteryx.com explaining the issue.  Also include the vintage of the ConsumerView Household or Individual file.     Experian's ConsumerView file is built directly from hundreds of public and proprietary sources.  They employ rigorous data testing including applying proprietary models and algorithms to ensure only the most deliverable addresses and accurate data elements are on the ConsumerView database.  Attached to this article is an excellent User Guide for the ConsumerView dataset. This User Guide is also included in the US Data Bundle documentation.
View full article
Question Occasionally someone asks the question, “how many businesses have ACTUAL YEAR STARTED” (or referenced another field) and you have no idea how to respond. You looked in the quarterly Variable List and didn’t see the answer. Now what?  You could run a query in Alteryx but should you? Answer Fortunately, there is a document available with just this information and it’s created for each quarterly update.  This information is found in the Documentation folder of the quarterly US and CA Data Installs media plus installed to a local DNB_US_Qx_201x Documentation folder.  The file is titled DnB US Analytical File Penetration Report Qx 201x.csv.  The example image contains a sample of the fieldnames.       The Quantity is the number of records populated for a Fieldname, the % penetration and whether the field is provided by D&B (DnB) or Alteryx. Depending upon your license, the entire list of fields may not be available for query/return but are still provided for reference.    Feel free to share the information since this document is delivered on the installation media. If you have comments or questions, contact support@alteryx.com.
View full article
This question comes up frequently because some of the US Data and Spatial datasets are HUGE and we want to ensure there's enough hard drive space available.  To help users better anticipate hard drive requirements, file sizes are included on the installation media in the Documentation folder of the update in a Excel worksheet. The .xlsx is titled Alteryx Qx 201x Variable List and includes file sizes for the United States and Canada in a worksheet labeled File sizes.  File sizes reflect the installed file size.   If you have questions or comments about this table, send an email to products@alteryx.com. 
View full article
The Q4 2016 US Data and US Spatial Data installs were mistakenly shipped with an Alteryx Maps macro named TomTomLayerSelection and should not be placed into production under any circumstances.    Users running Alteryx v. 10.1 and earlier versions who have installed the Q4 2016 US Data[1] update may receive the following error upon opening Alteryx:                     Action: To fix the error, or to remove the macro from the Tool Palette, users will need to delete the folder containing TomTomLayerSelection.yxmc by following these steps:   1. Close Alteryx and navigate to the Q4 Alteryx Maps data install folder, typically located here – Program Files (x86)\Alteryx\DataProducts\AlteryxMap\TomTom_US_2016_Q4   2. Delete the Macros folder, shown in the screenshot below:                       3. Relaunch Alteryx. You should no longer see the error message.        [1] US Spatial end users will not see this error when opening Alteryx  
View full article
Check out this visual of a Guzzler update
View full article
Behavior Analysis users installing Q3 2016 US Experian data should read!
View full article
CASS expires soon and I can't update.  Is there a grace period past the expiration date?
View full article
Read this alert if using the CAPE Population Summary report from Q1 2016 or Q2 2016!
View full article
Download and install instructions for the Spatial data installs.
View full article
Labels