Skip to main content

Use Business Analyst data

Available with the Business Analyst license.

For many data-related workflows, the data browser is the primary way you interact with available data. The data browser is an in-app interface that categorizes and displays all the data variables available in the selected data source. You can access the data browser within the following tools and workflows:

Browse and select variables

Once you have opened the data browser using one of the workflows or tools above, you can browse available variables in the following way:

  1. Click a category.

    Variables in the data browser are grouped into categories. Not all categories are available in every country and region.

  2. Click a subcategory.

    The variables in the subcategory are listed. To view information about a variable, hover over Info . You can select a variable group from the Variables list or click the Expand arrow next to a group to view the variables inside.

  3. Optionally, view and filter variables using the hierarchical navigation by doing any of the following:

    • Click Categories, All Variables, Custom Data, Variable Lists, or Favorites.

    • Expand and use the Filter options, which vary depending on data source. Filters may include variable year, dataset, and source.

  4. Depending on the workflow you are using, click a variable or check the check box next to a variable to select it. Optionally, click Favorite to mark any variable as a favorite for quick access through the Favorites list, accessible in the left pane of the data browser.

    Note:

    Variables saved as favorites are only listed in the data browser, and are not listed as items in the Catalog pane under My Favorites.

  5. When you are finished choosing variables, click OK.

Search variables

You can search for variables within categories and subcategories or by using keywords. You can do any of the following to search for variables:

  • Search the entire data browser from the main page, or browse to a category to search within it. In the Search Variables field, type your search terms or a variable ID and press Enter. If enabled, the data browser performs a semantic search, returning variables related to the search terms you entered.

  • Optionally, search only for variables that match your search terms by clicking Settings and unchecking the Find related variables check box .

Note:

For information on enabling semantic search for local and online data, see Semantic search.

Create and save variable lists

Once you have selected variables, you can save the list for future use. Lists you create and save are stored in Variable Lists, accessible in the left pane of the data browser. Variable lists are also displayed as items in the Business Analyst folder in the Catalog pane or view. Variable lists are saved in the current project as a .variablelist file.

Note:

The variable lists in the data browser only use variables from the currently selected Business Analyst data source. The variable lists available depend on which data source is selected.

To save a variable list, do the following:

  1. Select variables in the data browser.

  2. Click Selected Variables to view the list of variables you selected.

  3. On the Selected Variables list, do any of the following:

    • Click Save List to name and store the list for future use.

    • Click Remove All to empty the list.

    • Hover over a variable in the list to mark it as Favorite or view Info .

    • Reorder the list by dragging variables, or clicking Move up and Move down . You can move a single variable or select and move multiple variables by pressing Ctrl + Shift while clicking.

    Note:

    Reordering variables in the Selected Variables list allows you to set the order of fields in resulting attribute tables. For example, variables in the Selected Variables list are ordered top to bottom; these variables will display in the same order, left to right, in the attribute table.

  4. In the Save Variable List window, type a name for the variable list and click OK.

  5. To edit a saved variable list, right-click it in the Catalog pane or view and select Edit.

Alternatively, some workflows and tools allow you to save the list of variables you have selected in the workflow pane. Below the selected variables, click Save List. To add a variable list to projects, see Add variable lists and calculated variables to projects.

Create calculated variables

You can create variables that focus on a specific type, range, or combination of data, selecting variables from different categories and using mathematical functions to combine them. Once created, calculated variables are saved in the Custom Data > Calculated Variables list in the data browser.

Calculated variables that you create are saved as items (with a .bacalc file extension) in the current project, meaning they are project-specific. You can add previously created calculated variables to a project using the Add Calculated Variable button Add Calculated Variable in the Business Analysis gallery.

Note:

The following limitations apply to the creation of calculated variables:

  • Calculated variable creation is not available when connected to an online data source.

  • The variables available in the data browser for calculated variable creation only include standard Esri variables from the currently selected Business Analyst data source.

  • Variables from statistical data collections are unavailable for building calculated variables.

To create a calculated variable, do the following:

  1. Access the calculated variable building interface in one of the following ways:

    • On the Analysis tab, click Business Analysis to open the gallery, and click New Calculated Variable New Calculated Variable.

    • If you have already created Business Analyst items in your project, use the Catalog pane and select New Calculated Variable New Calculated Variable.

    The Data Browser – Calculated Variables window appears.

  2. Describe the variable you are creating by completing the following parameters:

    Parameter

    Description

    Field Name

    The internal variable name. This name must be unique within the dataset and, in most cases, should not include spaces or special characters.

    Alias

    A user-friendly display name specified for a variable. Aliases can contain spaces and special characters for readability.

    Definition

    A description of the variable that appears when hovering over the Info Info indicator in the data browser.

    Category

    The category to which the variable is assigned in the data browser. All calculated variables are listed in the Default category, unless you create your own category name.

    Output Type

    The format of the variable value.

    Precision

    The number of decimal places to the right of the decimal point in a variable's value.

  3. Build the variable by doing the following:

    1. Browse or search for variables.

    2. Select a single variable and click Add selected variable, or select multiple variables and add them to the expression pane by selecting any of the following:

      • Add as sum —Sum the variable values.

      • Add as average —Average the variable values.

      • Add as separate variables —Put the variables in the expression as individual variables.

    3. Define the calculation using a Python expression.

    4. Click Verify Verify to check the expression.

    5. Click Save and provide a file name for the variable.

  4. To access the variable for editing, open the Catalog pane and expand the Business Analyst > Calculated Variables folder, right-click the variable and select Edit.

  5. To add a variable you or someone else already created, you can do the following:

    • Click the Add Calculated Variable button Add Calculated Variable in the Business Analysis drop-down menu.

    • Open the Catalog pane, right-click the Business Analyst > Calculated Variables folder, and select Add Calculated Variable Add Calculated Variable.

To add a calculated variable to projects, see Add variable lists and calculated variables to projects.

Calculated variable examples

Calculated variables can be numeric or textual. Numeric variables yield a numeric value as the output. The Output Type parameter must be set to Double, Integer, or BigInteger. Below are examples of numeric variables.

  • Field Name: GenZ_Mil_Pop

  • Description: The combined population of Generation Z (1999-2006) and Millennial (1981-1998) generations. Available as a count or as a percentage of the population in an area.

  • Output Type: Double

Script

!Generations.GENZ_CY!+!Generations.MILLENN_CY!

Textual variables yield words or phrases as the output. The Output Type parameter must be set to String. Below are examples of textual variables.

  • Field Name: AgeRisk

  • Description: Identifies age risk levels using age dependencies for seniors (over 65 years) and children (under 18 years) then calculates the percentage of those cohorts in an area. High Risk is when ages under 18 and over 65 years are 60 percent of the area population.

  • Output Type: String

Script

if ((!AgeDependency.SENIOR_CY!+!AgeDependency.CHILD_CY!)/!populationtotals.TOTPOP_CY!) > 0.60:
returnValue ("High Risk")

Add variable lists and calculated variables to projects

The Catalog pane displays all your ArcGIS Pro content, including Business Analyst variable lists and calculated variables. To add a previously created variable list or calculated variable to a specific project or to all new projects, do the following:

  1. In the Business Analyst folder in the Catalog pane, do one of the following:

    • Right-click a variable list in the Variable Lists folder.

    • Right-click a calculated variable in the Calculated Variables folder.

  2. To add the variable list or calculated variable to the current project, do the following:

    1. In the contextual menu, click Add To My Favorites .

    2. At the top of the Catalog pane, click the Favorites tab, and click My Favorites My Favorites.

    3. Right-click the variable list or calculated variable, and click Add To Project .

    The variable list or calculated variable is added only to the current project.

  3. To add the variable list or calculated variable to all new projects you create in ArcGIS Pro, in the contextual menu, click Add To All New Projects .

    The variable list or calculated variable is added to project favorites and to all new projects.

Use custom and shared data

You can access custom data and data shared with you in the left pane of the data browser:

  • If you are connected to a local or custom data source, click Custom Data to browse, search for, and select variables within custom data.

  • If you are connected to an online data source, click Custom Data or Shared Content to browse, search for, and select variables within custom data.

Variable calculations

A variable can be used as a count, percentage, average, index value, or reliability estimate. The data browser displays the available calculation options as buttons next to each variable.

Note:

To access reliability estimates, margins of error, and coefficients of variation in the data browser, you must turn on the Show 'margin of error' toggles button when you set the Business Analyst data source.

Count (#)

If you select Count, the analysis uses the estimated count of the variable in the areas defined on the map.

Percentage (%)

If you select Percentage, the analysis uses the variable as a percentage value rather than a count. The percentage is expressed as a ratio to a base value, such as total households or total population, and multiplied by 100. For example, the percentage value for the variable Households with an Internet Subscription is the number of households with an internet subscription, divided by the total number of households in the area (this is the base value). You can view the percent base variable by hovering over the Info icon .

Average (Avg)

This option is available for variables in the Consumer Spending database. If you select Average, the analysis uses the average amount spent per household annually.

Index

If you select Index, the analysis uses an index value indicating how the amount of the variable in the areas defined on the map compares to another value, such as the nationwide average.

There are three types of indices:

  • Index of value—The variable value for the area divided by the variable value for the entire country, multiplied by 100. For example, the index for Average Household Size is calculated by dividing the Average Household Size value for the specific area by the Average Household Size for the country.

  • Index of percent value—The variable percentage for the area divided by the variable percentage for the entire country, multiplied by 100. For example, the index of Households that Own 2+ Dogs is calculated by dividing the percentage of Households that Own 2+ Dogs in the specific area by the percentage of Households that Own 2+ Dogs at the country level.

  • Index of average value—The variable average for the area divided by the variable average for the entire country, multiplied by 100. For example, the index of Health Care Spending is calculated by dividing the average household Health Care Spending in the specific area by the average household Health Care Spending at the country level.

You can view the index type for a variable by hovering over the Info icon .

Margin of error (MOE)

This option is available only for American Community Survey variables. The margin of error (MOE) is a measure of the variability of an estimate due to sampling error. Margins of error allow you to measure the range of uncertainty for each estimate with 90 percent confidence. The range of uncertainty is called the confidence interval, and it is calculated by the estimate plus or minus the MOE. For example, if the ACS reports an estimate of 100 with an MOE of ±20, you can be 90 percent certain the value for the estimate falls between 80 and 120.

Reliability (REL)

This option is available only for American Community Survey variables. If you select Reliability, the analysis uses the Esri reliability score, which is based on the American Community Survey margin of error (MOE) information for the data in the areas defined on the map. The reliability score indicates Esri's confidence in the estimate, based on the MOE provided. Reliability scores are as follows: high reliability, medium reliability, and low reliability.

Coefficient of variation (CV)

This option is available only for American Community Survey variables. The CV measures the amount of sampling error relative to the size of the estimate, expressed as a percentage. A large amount of sampling error in a small estimate will generally discount the usefulness of the estimate; however, a small amount of sampling error in a large estimate shows that the estimate is reliable.