Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Regional Economic Information System: Annual Updates

.. which counties are experiencing the fastest economic growth? by what economic component? what does this look like on a per capita level?

.. access & analyze economic characteristics and patterns by county and state .. annual time series 1969 through 2015 with projections.  Personal income is the income available to persons for consumption expenditures, taxes, interest payments, transfer payments to governments and the rest of the world, or for saving. Use the interactive table to examine characteristics of counties and regions of interest. The table provides access to 31 personal income related summary measures. These data are a selection of a broader set of annual time series data from the Regional Economic Information System (REIS). REIS is a part of the ProximityOne State & Regional Income & Product Accounts (SRIPA) and Situation & Outlook (S&O) featuring current (2016) estimates and demographic-economic projections. Go to table.

Visual Analysis of Per Capita Personal Income Patterns
The following map shows the Houston metro (view profile) with bold brown boundary. Counties are labeled with county name and 2014 per capita personal income.

Click graphic for larger view. View developed with CV XE GIS software.

Per Capita Personal Income Change 2008-2014 by County
.. relative to U.S 2008-2014 change

Click graphic for larger view. View developed with CV XE GIS software.

Interactive Analysis – County or State Profiles
The following graphic illustrate use of the interactive table to view an economic profile for Harris County, TX. Use the table to examine characteristics of any county or state. Click graphic for larger view.

Interactive Analysis
– comparing per capita personal income across counties
The next graphics illustrates use of the interactive table to rank/compare per capita personal income across counties. Rank/compare states. Choose any of the economic profile items. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Business Data Analytics: Methods & Tools

Business Data Analytics can help most any business more effectively reach goals and objectives. Whether a new or established business, serving a county or national market, similar tools and methods apply. See related Web version for more details.

• How can you examine patterns/characteristics of existing customers?
• Where are prospective customers and possible unknown opportunities?
• How do you best define your market area?
  – what geographies have the largest number of prospects?
• What are the sales potential in this market area?
  – what are the best measures to examine sales potential?
• What is your competitive position?
  – how many other establishments offer a similar service in your market area?
• How can your sales data identify geographic areas of opportunity?

Tools and methods described here can help answer these questions and facilitate strategic planning. Here are key steps to using Business Data Analytics in your business. These applications make use of a GIS project and data for a business located in the San Diego area. Click link to view graphics.
• Business locations
• Territories served
• Market characteristics
• Urban population by block; population by tract
• Customer locations
• Prospect locations
• Competitor locations
• Composite of above
• Related topics

Locations [goto top]
Where are the business locations/stores/operations
Blue triangle markers show existing locations. Are these the ideal locations?

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Territories Served [goto top]
What territories do locations serve? Are they developed correctly?
Territories for service/market areas are shown as color-shaded areas.
— flexibly re-define territories

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Market Characteristics [goto top]
What are the market characteristics?
Graphic shows patterns of median household income (MHI) by census tract;
— identifying areas with best opportunity
— examine wide-ranging demographic-economic characteristics
— market area tracts shown with cross-hatch pattern
— MHI intervsls/color correspondence shown in legend at left of map
— ranges can be customized/shifted to suit

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Urban Population by Block; Population by Tract [goto top]
Urban census blocks are shown with an orange fill pattern.
– examine scope of urban areas and how they relate to business development.
Census tract population is shown as a label for all tracts.
– identify population concentrations/attributes for small areas.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Customers [goto top]
Red markers show existing customers.
— linked to customer/product database

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Prospects [goto top]
Orange and green markers show prospects based on different sources/criteria.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Competitors [goto top]
What is the competitive position/where are competitors located?
Red triangle markers show where competitors are located.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Composite View [goto top]
Integrating business operating environment.
Graphic shows zoom-in to Encinatas location with all features shown separately in above views.
Roads/streets have been added; optionally use for routing and locational analysis.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Related Topics for Extended Analysis [goto top]
These extended topics make use of the data and analyses reviewed above. These topics will be covered in subsequent sections.

• Determining performance relative to the market characteristics
• Assessing impact of external and internal factors affecting operations
  – supply chain, labor force, costs, demand …
• Examining financial situation and outlook?
• Determining areas of missed opportunity
  – metros, hot spots within metros (tracts)
• Using collective data in models for predictive analyses
  – how might things change, when where and how?
• How to interpret statistical releases
  – determining which relevant, assessing implications for impact
• How to most effectively make team/collaborative/management decisions

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.