Creating a Model with Coordinate or Area Data for Geospatial Analysis
Before you perform geospatial analysis in stories, you must first import coordinate data or area data, and enrich it in the Modeler. This process creates a new column in the data view with an enriched format of latitude and longitude coordinates or by area using country, region, and subregion data.
You must have an Excel file (.xlsx) or CSV file with a location ID column that contains unique data, as well as either latitude and longitude columns, or country (required if your regions and subregions are in different countries), region, and subregion columns.
These steps describe how to enrich coordinate or area data while creating a model from a file. You can also enrich coordinate or area data while uploading data to an existing model. For more information, see Preparing Data.
- From the () Main Menu, select .
Select Import a file from your computer.
In the Import Model From File dialog, choose whether you
want to import data from a file on your local system, or from a file
If you don't see the option to import data from a file server, see Allowing Data Import and Model Export with a File Server.TipIf you import a file from a file server, you can also schedule imports from that file. For more information, see Updating and Scheduling Models.
If you're importing from a file server, choose a file server connection, or
select Create New Connection.
If you create a new file server connection, specify the path to the folder where the data files are located. For example: C:\folder1\folder2 or \\servername\volume\path or /mnt/abc.
- Choose the file you want to import.
If you are importing from a local Excel workbook containing multiple sheets,
select the Sheet you want to import.
If you are importing from an Excel file on a file server, the first sheet is automatically imported.
- If you're importing a .csv file, select which delimiter is used in the file.
For small data files, the data is imported and displayed in the Data Integration view, which shows the imported data columns that you'll define as dimensions, measures, and attributes.
Larger data files may take some time to upload. You can work on other tasks
while the dataset is being uploaded in the background. When the data is finished
uploading, select it from the Draft Data list to open it
in the Data Integration view.
- Ensure that at least one numeric column has Measure as its dimension type.
(Geo Enrichment) in the toolbar, and then choose
either of the following options:
- By Coordinates if you want to use latitude and longitude data to create the location dimension.
- By Area Name if you want to create the location dimension based on country, region, and subregion data. The country data can be imported as ISO3 and ISO2 codes, or the country names in English.
Specify the following information:
- By Coordinates:
- Dimension Name: Type a name for the dimension that you will create using the geo enrich process.
- Location Description: Select the column that will provide the tooltip text for dimension members displayed in a geo map.
Location ID: Select the dimension you want to associate with the new location dimension. Select a dimension with a unique location ID.NoteYou can create a location for the Dimension ID column of an organization or generic dimension. You cannot create a location dimension associated with Account, Version or Date dimensions.
- Latitude: Select the column that contains the latitude coordinate.
- Longitude: Select the column that contains the longitude coordinate.
- By Area Name
Choose how you want to specify the country data:
- Select Column: if you want to select the column containing the country data.
- Select Country: if you want to select a
specific country from a dropdown list.NoteIf you select a country from the list, after the data is geo-enriched, it will be limited to areas within the selected country.
- By Coordinates:
A new column is created for the location dimension. Any data quality issues are displayed in the Details panel.