Esri Demographics

Demographics Excelled: Use Esri Demographics with ArcGIS for Excel for Deeper Insights

Business users and geographic information system (GIS) professionals frequently access Esri Demographics through ArcGIS Business Analyst Web App and ArcGIS Living Atlas of the World. But did you know that you can also access Esri demographic data through ArcGIS for Microsoft 365?

Esri’s ArcGIS for Microsoft 365 product suite connects today’s global organizations with one of the most powerful business tools available—Microsoft Excel. With the ArcGIS for Excel add-in, you can gain access to Esri’s demographic data for deeper insights using spreadsheets, Excel functions, and maps within the context of a Microsoft workflow.

Questions You Can Answer with Esri’s Demographic Data and ArcGIS for Excel

Data enrichment, visualization, collaboration, and access to ArcGIS Online or ArcGIS Enterprise are some of the advantages of using the ArcGIS for Excel add-in. Coupled with Esri’s demographic data, you can answer questions like these:

Ideal for Industries That Require a Deeper Understanding of Users, Customers, or Constituents

Demographic data from Esri is intended to eliminate the guesswork to help you make data-driven decisions with confidence. ArcGIS for Excel and Esri’s demographic data are ideal for the following:

How to Use ArcGIS for Excel for Greater Demographic Insights

Eager to see how Esri’s demographic data and ArcGIS for Excel can work for you? See the following for an example using the ArcGIS for Excel ENRICHBYGEOGRAPHY function.

Consider this sample problem:

Here are data variables to analyze:

After you have received ArcGIS for Excel from the Windows Apps – Microsoft Store, open an Excel Worksheet.

Step 1: On the Excel ribbon. Click the ArcGIS tab then click Show Map.

Esri Demographics, ArcGIS Excel
Start using Esri Demographics in ArcGIS Excel by clicking 'ArcGIS' (1)

Step 2: Click FUNCTION BUILDER > GEOENRICHMENT FUNCTIONS > ENRICHBYGEOGRAPHY to pull in demographic data. The demo dataset has three fields: ID, NAME and STATES. In the ID column, SF Zipcodes are listed.

Esri Demographics, ArcGIS Excel
Select 'FUNCTIONBUILDER' then 'GEOENRICHMENT FUNCTIONS' (2)

Step 3: Under Set Parameters select AREA_ID, GEOGRAPHY_LEVEL_ID, and the appropriate data variables (ANALYSIS_VARIABLES). Click UPDATE and apply to all cells. In this example, the selected variables are the following:

Esri Demographics, ArcGIS Excel
Under 'Set Parameters' select your AREA_ID, GEOGRAPHY_LEVEL_ID and the appropriate variables under ANALYSIS_VARIABLES. Click UPDATE. (3)

Step 4: Visualize the ZIP codes and demographic data on a map:

Esri Demographics, ArcGIS for Excel
The 'Layers', 'Layer options' then 'Labels' options can help you visualize and understand your map(4). The layers will appear on map after user clicks 'Add to Map.'

Step 5: Under ‘Location Types‘ select the ‘Geographic Data‘ layer:

Step 6: Join ArcExcel field and ArcGIS layer:

Join the ArcExcel field and the ArcGIS Layer field (6)

Step 7: Apply labels and ‘Style by color‘ styling to clearly distinguish the appropriate data on the map.

Final Step: View your map:

Esri Demographics, ArcGIS Excel
Clear labeling and 'Style by color' styling can help you analyze your map.

Result:
ZIP codes 94110, 94112, and 94080 have the highest number of Generation Z residents.

Click here to watch the demo.

 

ArcGIS for Excel: Connecting You with Demographic Data You Can Trust

Esri Demographics is built by a team of demographers, statisticians, scientists, and data experts who vet and test data from multiple sources and providers. Whether you prefer to analyze demographic data with spreadsheets or on a map, you have options depending on where and how you work. ArcGIS for Excel can seamlessly integrate demographic data, maps, and traditional business data to help you make decisions that positively impact your work.

 

 

Esri Demographics Resources

ArcGIS for Excel Resources

About the authors

Choni Brooke Brinkley is a Product Manager on the Data & Location Services team at Esri. Choni has a BS from Syracuse University, an MBA from the University of Notre Dame, and is dog mom to Willoughby the Boston Terrier.

Connect:

Article Discussion:

Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments

Next Article

Deprecation Notice for ArcGIS GeoAnalytics Server

Read this article