Open PRAIRIE: Open Public Research Access Institutional Repository and Information Exchange

This session includes a brief introduction to the types of Labor Market Information available through the Labor Market Information Center. The majority of this workshop will guide you through the most commonly used data sets for workforce and economic analyses found in the Virtual Labor Market Data System.

As a Data Dissemination Specialist, US Commerce Department, Bureau of Census, David is one of 26 in a Bureau of 15,000, engaging citizens and connecting them with Census business, economic, trade and demographic data. He teaches workshops and presentations to data users on how to use Census data tools to mine government data. This high quality data supports business plans, grant opportunities and critical discussion making.

This session will use the spreadsheet that contains the 2015 Small Area Health Insurance Estimates for all counties and states of the United States to demonstrate several functions and tools in EXCEL for data tabulation, analysis, and presentation. The functions and tools include advanced sorting, filtering, and pivot table. The session will also include a demonstration of using graphic tools in EXCEL to present the data. Data visualization is a simple tool for sharing a dataset's story with an audience, no matter what their background. Trends and population percentages are just two items that can be creatively displayed in EXCEL. We'll learn how to create the visualizations that can help take presentations to the next level.

This session will cover the basics of the Census Bureau’s DataFerrett tool. We will go through steps to select variables, recode variables, create custom value ranges, and build up a table in different ways. Participants will learn how to manipulate microdata files such as ACS PUMS to create our own data and report results using customized tables.