,,,,,,,,,,,,,,,,,,,,,,,,,,,,

How do I import data into SimplyAnalytics USA?

Juan Vasquez -

Requirements

  • The import file must be in CSV format. XLS or DBF formats will not work.
  • The file must have a location ID column in the form of a FIPS code. FIPS codes are geographic identifiers used by the Census Bureau. When you export data from SimplyAnalytics, the FIPS code will always be included – this is a quick way to pull the FIPS codes you need for your import.
  • The import file must contain only one geographic unit. For example, all ZIP Codes or all Counties. There is an available option to add other units of geography.

Getting Started

Select your username (or "Guest") towards the top-right of the interface, then Import Data – this will open the Import Data panel that contains three steps. 

① Select browse to add in your CSV file

② Specify the geographic unit of the import

③ Provide a name for your imported dataset

④ Click on Next to proceed

import1.jpg

Identifying Data Columns & Data Types

The second step in the import process involves specifying data types and formats for your imported data. SimplyAnalytics will automatically parse through the CSV to identify the column names.

If you have a name field in your import to go along with your FIPS code, Uncheck the Name under the Column Name heading within the panel – the FIPS code is the only Location ID acceptable. Leaving the name field checked will cause an error in the import.

Go through each column name in the panel and specify the correct data type and format.

import2.jpg

IMPORTANT:

You must always indicate the FIPS column name as the Location ID data type. Failure to do so will result in a failed import.

Available Data Types:

  • Count
  • Mean
  • Median
  • Percent

Available Data Formats:

  • Integer
  • Currency
  • Two Decimal Places

Final Step

The final step in the import process is to make sure your import specifications are correct.

import6.jpg

If something looks wrong, or you would like to change your import, select Back

If everything appears correct, select Begin Import to complete the process.

Accessing the Data

To access your imported data, select the Current Data & Locations dropdown towards the top left of the interface, and click on My Imported Data.

import4.jpg

This will present a list of imported data sets to choose from.

Click on the folder to view the imported data variables.

import5.jpg

Interacting with the Data

With the sales data for all ZIP Codes in Dallas, TX imported – you are welcome to begin analyzing & co-mingling the data with other datasets in the various reports.

Because data exists only for those geographies stated above, using any other geography will result in N/A. For example, adding a county in California will result in N/A or a blank map.

import3.jpg

Have more questions? Submit a request
Powered by Zendesk