You are here

using data

Occupation Table Spreadsheet

This spreadsheet should be viewed side-by-side with the sections of Chapter 2 involving building and understanding an occupation table. Tabs are lettered to accord with those instructions, and the comments included in the slides address the challenges in data collection or manipulation that are not uncommon when doing this kind of analysis.

Tool Categories: 

Worksheet for Estimating Turnover Costs

This worksheet from PAROS group provides a method for calculating the hard and soft costs of employee turnover for a particular employer.

 

Sample Industry Roundtable PowerPoint

A real-life example of a PowerPoint presentation given at an Industry Roundtable. Includes data on the region for employers to react to, as well as an introduction to them about the concept of a Regional Skills Alliance (aka sector partnership).

Industry Identification Worksheet

This worksheet provides one way to summarize the information that's known about a potential target industry. It includes both "hard" labor market information, but more importantly, takes into account other crucial factors, such as political capital and the presence of industry champions.

Tool Categories: 

Calculating Location Quotients

(Remember to download the sample spreadsheet so you can follow along.)

First, you will need to get national employment data for the same year as your base employment year. One easy way to do this is to use the location quotient calculator. Choose your state as the comparison area, and put the data from US Total column of the Percentage of Employment table into your spreadsheet.

Tool Categories: 

Industry Data Table Spreadsheet

This spreadsheet should be viewed side-by-side with the sections of Chapter 2 involving building and understanding a data table. Tabs are lettered to accord with those instructions, and the comments included in the slides address the challenges in data collection that are not uncommon when doing this kind of analysis.

Tool Categories: 

Industry Analysis Guides

California's Clusters of Opportunity model is one type of regionally targeted industry strategy. Part 1 of the attached guide includes their step-by-step instructions to regions for using data to target industry clusters.

The Wisconsin Cookbook is not sector-specific, but the techniques it includes apply to sector research. It specifices data sources for the state and includes a section with step-by-step instructions to create a Regional Economic Analysis.

Tool Categories: 

Sample Labor Market Analysis

In this document, LED data was used to summarize the relationship between where jobs and workers are located in the Detroit metro area.

Tool Categories: 
Subscribe to RSS - using data