Tag Archives: data analytics lab

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive table

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.

Data Analytics Labs: Resources & Methods to Create & Apply Insight

.. it has always been that an important first step in Data Analytics was developing or acquiring the key data to be analyzed.  Having the right subject matter data for the right geography and time frame are essential prerequisites.  The Internet and pervasive expanding needs and solutions for data integration has made Data Analytics easier and more accessible — and often more technically challenging.  The Data Analytics Lab, reviewed here, offers a foundational and support framework to address the continually evolving Data Analytics needs. See more about the Data Analytics Lab in the related Web section.

Data Analytics involves more than the ability to perform statistical analyses on data, though this is an important element. Data Analytics encompasses a spectrum of data and the ability to develop, access, integrate and effectively use those data. The platform of data on which we operate is constantly in change. New and different types of data emerge. Older data become obsolete. Required subject matter are often not available at the required geographic granularity. Often the biggest challenge is in linking data for analysis.

Role of Geographic Information Systems (GIS)
GIS software is one on many Data Analytics tools. It is an important tool for many reasons. One main reason is the enabling ability to flexibly visually examine subject matter for different types of geography simultaneously. The following view shows patterns of economic prosperity in the Atlanta region (metro shown with bold boundary). The thematic pattern is median household income by block group. Higher income areas are shown in blue/green and lower income areas are shown in orange/red. Counties are shown with black boundaries.

The next view is a zoom-in to the pointer location in the map shown above. This view has a higher transparency setting enabling a see-though effect to view highways and related ground infrastructure. Block groups appear with black boundaries. The pointer is at the county boundary, a slightly bolder boundary.

Data Analytics Labs (DAL) help participants develop a capacity to create map views like those shown above and perform geospatial analyses. This is more than learning how to operate GIS software; more than how to acquire shapefiles and build a GIS project. It is about selecting and acquiring the right subject matter data and then integrating those data with geometry (shapefiles, etc.) and assembling the composite files for analysis. DAL learning enables participants to develop informative and relevant maps view — and the right types of different geographies (including vintages) to use.

Data Analytics Labs are set up within universities, government agencies and not-for-profit organizations to address these needs. Contact us to discuss how a Lab can be developed within your organization.

A Data Analytics Lab provides tools/resources for hands-on data analytics applications. In a university setting, the Lab can be open to MBA, MPA, MHA and other graduate students plus multi-disciplinary faculty/researchers. Also in the university setting, some parts of a Lab can fit into existing classes and mesh with other existing programs. There is no physical lab; it is a virtual lab. The resources and vision are initially focused on Census-type geographic-demographic-economic data, expanded to selected Federal statistical data, and how these and primary data are knitted together for analysis and decision-making.

There are no fees to participants. Tools and data are made available by ProximityOne — http://proximityone.com.

Data Analytics Lab Resources & Components
1. Software
    • CV XE GIS software
      – GIS shapefiles and applications compatible with ESRI ArcGIS software
    • API data access/integration software
    • Modeler software
      – cause & effect modeling; estimation & forecasting; impact analysis
    • Related software
2. Data Resources
    • state & national scope ready to use GIS projects
    • augmented TIGER/DMD geography
    • U.S. national scope 5-year demographic-economic estimates & projections
      –  small area demographic-economic estimates/projections to 2020
    • U.S. national scope county/up 2060 demographic projections
      – population projections to 2060 (single year of age x gender x race/origin)
    • ProximityOne Data Services (PDS)
      – multi-sourced Federal , Census and other data resources
3. U.S. by state/metro/county macro models (uses software and data above)
    • enable users to explore alternative model specifications/assumptions
    • produce alternative outcomes; perform impact analyses
4. Data Analytics Lab Sessions
    • variations on weekly Web-based sessions
5. Certificate in Data Analytics Modules
    • structured usage of Data Analytics Certificate program sessions/resources
6. Intern Participation: Data Analytics Tools Development and Applications
    • model specification & use; software development & use; data resource development & use

Forthcoming sections will review examples of Data Analytics Labs, how and where they are operating and experiences of participants.

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.