This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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!
Data Products 101
Part 2: Maps
This article focuses on one key area of our Location Insights products – Maps. I'll use the US Location Insight product for this example, but all of our international Location Insight products are functionally the same unless I call it out specifically as a unique part of the US package.
As a quick recap before I begin this article, let's cover two frequently asked questions:
What do the Location Insight packages include?
All Location Insight packages include:
Satellite imagery maps (with optional road overlay)
Detail rich street maps
Drivetime data to generate custom trade areas and point-to-point calculations
API-based Forward and Reverse Geocoding tools
In addition to the above, Canada and the US include:
CASS data for CASS certification and Address Standardization
On premise, forward geocoding tools
Rooftop and parcel centroid address point data
In addition to the above, the US also includes:
2010 US Census data summarized to the Block Group
What countries does Alteryx have Location Insight products for (as of Q4 2018)?
The United States (which includes: American Samoa, Guam, Northern Mariana Islands, Puerto Rico, and the US Virgin Islands)
The United Kingdom and the Republic of Ireland
Australia and New Zealand
Europe (which includes: Andorra, Austria, Belgium, Croatia, Czechia, Denmark, Finland, France, Germany, Gibraltar, Hungary, Italy, Liechtenstein, Luxembourg, Monaco, the Netherlands, Norway, Poland, Portugal, San Marino, Slovakia, Slovenia, Spain, Sweden, Switzerland, the Vatican City, and some coverage of Western Russia)
Let's get started:
Using Alteryx Maps
In Part 1 we covered installing our Data Products – now let’s jump into actually using it.
First, let’s drag a Map Input tool onto our canvas and review what maps we have available to us by clicking the ‘Base Map’ drop down.
As we can see here, we have multiple maps at our disposal. Carto Positron and Dark Matter come pre-loaded with Alteryx and function well as a basic map for your data – but the TomTom and Digital Globe maps you get with the Location Insights packages bring more accuracy and a lot more utility.
Let’s examine a quick comparison below to understand the features of each Base Map.
DigitalGlobe Aerials with Streets
As we can see above, there are some big differences between the 4 main Base Maps.
TomTom US offers a feature rich visual in a familiar and modern styling that makes it easy to immediately distinguish map layers from one another. There’s no mistaking a park with a lake, or an interstate highway with an avenue. Details which could be critical when trying to analyze where your customers live.
DigitalGlobe Aerials offers a pure satellite imagery map that makes it easy to pick out specific buildings or sight property lines between farms when manually creating spatial data.
DigitalGlobe Aerials with Streets offers a hybrid between the TomTom map and the DigitalGlobe Aerials – literally. In fact, DigitalGlobe Aerials with Streets uses the very street data used within the TomTom map. The inclusion of street data can give geographic context which is often lacking in a pure satellite imagery map.
Carto – our free map – offers similar features as the TomTom map that will help give context to your spatial data, but it doesn’t include as many layers as TomTom and it is not as easy to distinguish these layers from one another.
While the Map Input tool is useful for creating spatial data at the beginning of our analytical journey, it doesn’t help provide context to the data we are currently working with. Thankfully, the Browse tool has a built-in map function when working with spatial data.
All you have to do is select the ‘Map’ tab on the top left, then select your desired Base Map in the drop down. Now you can see your data visualized on one of our maps. Let’s pause and take a moment to reflect upon the fact that Maps are the OG in Visualytics.
Now we’ve seen how the Map Input tool can help start our analytical journey, and how maps within the browse tool provide context to the data we are working with - the last mapping tool in our toolkit we need to discuss is the Report Map tool.
Report Map is a powerful tool for visualizing your spatial data. It provides spatial context to the results at the end of your analytical journey. I highly recommend you check out the Tool Mastery article for it as well as the One Tool Sample found in the ‘Help’ menu in Alteryx.
As the Tool Mastery article provides plenty of context on how to configure the tool, I’ll point out that the TomTom base map within the Report Map tool allows users to customize individual geography layers. For example, your analysis is based near airports – the Report Map tool allows you to customize the appearance of the airport polygon layer and even other surrounding layers to show importance. Select the TomTom map in the Reference Base Map configuration to enable base layer customization.
You should now be equipped to use the Map portion of your Location Insights package. If you’re wondering where to start with diving deeper into spatial analytics then be sure to stay tuned for Part 3 of my Data Products 101 series - Drivetime Data.
Let's circle back to an earlier point about the three main maps of the Location Insights packages – the "DigitalGlobe Aerials with Streets" map uses the exact same street network data as the TomTom map. You might be wondering how that works, so let's take a quick dive into how maps work in Alteryx.
There are two ways Alteryx creates maps – fetching map tiles from an API (Carto and DigitalGlobe Aerials use this method) and rendering spatial data with a .map file (TomTom uses this method). In a practical sense, the TomTom map consists of a file inventory of .yxdb's, and the styling, layering, and rendering of the data within those .yxdb's is orchestrated by a .map file. The DigitalGlobe Aerials with Streets map is actually a hybrid of the road network spatial data in select .yxdb’s rendered on top of the satellite imagery tiles from the API.
Why does this matter?
Location Insights customers can take advantage of the base .yxdb’s for use in their spatial analysis. Perhaps you’re interested in lake polygons.
These raw .yxdb’s can be found wherever you installed the Location Insights package. For instance, the files should be found in C:\Data_Install\AlteryxMap\TomTom_US_2018_Q4\Data if I installed the Q4 2018 US data to C:\Data_Install.
To make this even more convenient, our US Location Insights users have a TomTom Layer Extraction app included with their installation. Access it within Alteryx via: Options > Run Analytical Apps > TomTom Layer Extraction App > Run
Configure the app to according to your needs – narrow down to which state geography(s) you want to extract from, then select the specific layer(s) you want data for, and finally select your output and if you want to merge the geographies.
Now you can integrate the spatial data for these layers directly into your workflow!
As mentioned previously, the styling, layering, and rendering of the spatial data within the .yxdb's is orchestrated by a .map file. Users can actually edit those .map files to make styling tweaks or add new elements. This process can be a bit tricky, especially for users without a GIS background. I won't dive into the process, but here is a Community Article that discusses .map file customization if you are interested.
This post pertains to any user that downloaded the US Spatial (Q4 2018) package from the Downloads & Licenses portal between the initial release on Wednesday, February 20th, and ~1:30pm EST on Friday, March 1st. You'll know that you have the outdated download package if you do not see 'TomTom US Q4 2018' on the 'Install' screen under the 'Drivetime Datasets' section.
The initial package did not contain the TomTom US Q4 2018 Drivetime data (Guzzler). Should users require the Q4 2018 US Drivetime data, they'll need to download the updated package and rerun the install. Fortunately only a portion of the install needs to be executed unless a Network Install was used. After downloading and extracting the updated package, you can upgrade the TomTom US Q4 2018 Drivetime data with the following steps (for local installation).
Run AlteryxDataInstall.exe and select 'None', then only select the Drivetime dataset.
Uninstall TomTom US Q3 2018 if desired.
Finish the installation as usual and be sure to restart Designer to refresh the list of available data sets.
For customers that utilize the Network Installation process, the simplest approach would be to prepare a full network install in a new location, then ask users to uninstall the entire data package and re-register from the new location (as the registration process is quick to execute).
We apologize for the inconvenience. Please feel free to post questions below.
Team Lead, Data Products
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.
Team Lead, Data Products
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.
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.
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
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.
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.
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.
Alteryx Data Artisans occasionally identify problems with how street segments are displayed or where addresses may be located. They want to pass along corrections and may reach out to Alteryx to help. Artisans can actually provide feedback directly back to our spatial vendor, TomTom, by logging into this web site: http://www.mapsharetool.com/external-iframe/external.jsp.
You can submit a report after logging in with Facebook, Google or Yahoo. As noted on the linked page, your reports help them keep their maps as accurate as possible.