Using LEHD data to advance economic development in the Pittsburgh - - PowerPoint PPT Presentation

Using LEHD data to advance economic development in the Pittsburgh region

Melanie Harrington, President and CEO Elissa Waldmuller, Research Analyst Vibrant Pittsburgh

Who we are

 Vibrant Pittsburgh works to grow a talented and diverse

workforce for the region, by attracting, retaining, elevating and educating people of all backgrounds.

 Vibrant Pittsburgh is focused on working collaboratively

with private and public sector leadership to strengthen the region’s economic future by growing and retaining a diverse workforce and fostering a more inclusive and welcoming community.

Background

 2015 Report by the Pittsburgh Workforce Diversity Indicators Initiative

 Vibrant Pittsburgh,  Pittsburgh T

• day

 Three Rivers Workforce Investment Board  Allegheny Conference on Community Development  University of Pittsburgh Center on Race and Social Problems  University of Pittsburgh University Center for Social and Urban Research

 First round analysis focused on job sector employment, worker income, and workforce participation  Local data was benchmarked against 14 peer regions  Data was drawn from the 2013 LEHD program’s Quarterly Workforce Indicators

Purpose

 Behind the Times: The Limited Role of Minorities in the Greater Pittsburgh

Workforce is based on an analysis of workforce-related data collected by the Pittsburgh Regional Workforce Diversity Indicators Initiative.

 To track and report regional

workforce comparative data that are designed to bring greater resources and more constructive solutions to the goal of growing and diversifying the Pittsburgh region’s workforce and population.

Minority Workers’ Share of Pittsburgh Region Jobs

Percentage of Jobs in the Pittsburgh Labor Market Held by Minority Workers

11.1% 88.9% Pittsburgh 0% 50% 100%

Percentage of White Non-Hispanic Workers Percentage of Minority Workers

Overall Share of Jobs in the Pittsburgh Labor Market Held by Minority Workers by Racial and Ethnic Subgroups

0.8%

1.6% 1.7% 7.1% 88.9% 0% 50% 100%

Pittsburgh

White Non-Hispanic African American/Black Hispanic/Latino Asian

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Percentage of Overall Share of Jobs Held by Racial/Ethnic Minority Workers by Peer Region in 2013

11.1% 16.3% 16.6% 19.3% 20.5% 21.2% 21.5% 22.3% 24.4% 25.2% 26.5% 28.2% 32.2% 36.1% 36.8% 44.3% 0% 10% 20% 30% 40% 50% Pittsburgh Cincinnati Minneapolis Indianapolis Kansas City Cleveland Milwaukee

• St. Louis

Detroit Benchmark Average Denver Philadelphia Charlotte Richmond Baltimore Atlanta

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Workforce participation by minority subgroups – peer regions

By MSA, 2013

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data 7% 6% 12% 12% 12% 15% 11% 17% 16% 16% 5% 17% 22% 27% 26% 32% 2% 4% 2% 4% 5% 4% 7% 2% 3% 5% 16% 5% 6% 4% 5% 7% 2% 5% 2% 2% 2% 2% 3% 2% 3% 3% 3% 5% 3% 3% 5% 5% 1% 2% 1% 1% 2% 1% 1% 1% 1% 1% 2% 1% 1% 1% 1% 1% 0% 10% 20% 30% 40% 50%

Pittsburgh Minneapolis Cincinnati Indianapolis Kansas City Cleveland Milwaukee

• St. Louis

Detroit Benchmark Average Denver Philadelphia Charlotte Richmond Baltimore Atlanta African American/Black Hispanic/Latino Asian Other

Percentage of Jobs Held by Minority Workers by Industry in the Pittsburgh Labor Market in 2013

5.0% 5.5% 5.8% 6.3% 7.4% 7.7% 8.7% 9.1% 9.5% 9.8% 10.0% 10.2% 10.3% 10.6% 10.9% 11.1% 11.6% 11.6% 14.3% 16.4% 19.6%

0% 5% 10% 15% 20% 25%

Construction Mining, Quarrying, Oil and Gas Extraction Wholesale Trade Agriculture, Forestry, Fishing and Hunting Manufacturing Utilities Other Services Professional, Scientific, and Technical Services Arts, Entertainment, and Recreation Real Estate and Rental and Leasing Retail Trade Educational Services Management of Companies and Enterprises Public Administration Transportation and Warehousing All NAICS Finance and Insurance Information Health Care and Social Assistance Accommodation and Food Services Administrative and Support

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Average Monthly Wages for Racial/Ethnic Minority Workers by Industry in the Pittsburgh Labor Market for 2013

$1,442 $2,047 $2,218 $2,326 $2,552 $2,761 $3,500 $3,636 $3,983 $4,007 $4,213 $4,357 $4,560 $4,893 $5,292 $5,450 $5,977 $6,107 $6,357 $7,254 $8,346

$0 $2,000 $4,000 $6,000 $8,000

Accommodation and Food Services Retail Trade Arts, Entertainment, and Recreation Other Services Agriculture, Forestry, Fishing and Hunting Administrative and Support and Waste… Transportation and Warehousing Real Estate and Rental and Leasing Public Administration All NAICS Construction Educational Services Health Care and Social Assistance Manufacturing Finance and Insurance Wholesale Trade Professional, Scientific, and Technical Services Information Management of Companies and Enterprises Utilities Mining, Quarrying, Oil and Gas Extraction

Racial/Ethnic Minority Workers White Non-Hispanic Workers

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Average Monthly Wages for Racial/Ethnic Minority Workers by Peer Region in 2013

$3,162 $3,275 $3,318 $3,442 $3,475 $3,523 $3,523 $3,597 $3,631 $3,675 $3,683 $3,726 $3,726 $3,814 $3,948 $4,038

$0 $2,000 $4,000 $6,000

Kansas City Milwaukee Minneapolis Richmond

• St. Louis

Denver Indianapolis Benchmark Average Atlanta Charlotte Cleveland Philadelphia Baltimore Cincinnati Pittsburgh Detroit

Racial/Ethnic Minority Workers White Non-Hispanic Workers

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Average Monthly Wages of African American/Black Minority Workers by Peer Region in 2013

$2,395 $2,480 $2,635 $2,666 $2,699 $2,773 $2,780 $2,817 $2,829 $2,834 $2,943 $2,997 $3,077 $3,094 $3,102 $3,147 $0 $2,000 $4,000 $6,000

• St. Louis

Milwaukee Kansas City Pittsburgh Cleveland Cincinnati Richmond Minneapolis Benchmark Average Indianapolis Charlotte Philadelphia Atlanta Detroit Denver Baltimore

African American/Black Minority Workers White Non-Hispanic Workers

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

Average Monthly Wages for Racial/Ethnic Minority Workers by Peer Region in 2013

Average Monthly Wages of Hispanic/Latino Minority Workers by Peer Region in 2013

$2,796 $2,917 $2,978 $3,007 $3,041 $3,042 $3,090 $3,098 $3,206 $3,237 $3,249 $3,341 $3,394 $3,599 $3,637 $3,661 $0 $2,000 $4,000 $6,000

Milwaukee Kansas City Indianapolis Cleveland Richmond Charlotte Denver Minneapolis Benchmark… Atlanta Philadelphia

• St. Louis

Baltimore Cincinnati Detroit Pittsburgh

Hispanic/Latino Minority Workers White Non-Hispanic Workers

Average Monthly Wages for Asian Minority Workers by Peer Region in 2013

$4,217 $4,321 $4,359 $4,836 $4,891 $4,915 $4,947 $5,032 $5,153 $5,203 $5,296 $5,323 $5,790 $5,837 $6,060 $6,271 $0 $2,000 $4,000 $6,000 $8,000 Minneapolis Denver Kansas City Atlanta Richmond Milwaukee Baltimore Philadelphia Benchmark…

• St. Louis

Indianapolis Charlotte Cincinnati Cleveland Detroit Pittsburgh Asian Minority Workers White Non-Hispanic Workers

DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data

How the data was gathered

Using publicly available LEHD data from http://lehd.ces.census.gov

Click on “LED Extraction Tool”

The following metropolitan statistical areas (MSAs) were used: Pittsburgh, PA Atlanta, GA Baltimore, MD Charlotte, NC Cincinnati, OH Cleveland, OH Denver, CO Detroit, MI Indianapolis, IN Kansas City, KS Milwaukee, WI Minneapolis, MN Philadelphia, PA Richmond, VA

• St. Louis, MO

1st 2nd 3rd

Steps:

• 1. Select a state – Pennsylvania
• 2. Select Micro/Metropolitan Areas
• 3. Check Pittsburgh, PA

Step 1 – Geography

Step 2 – Firm Characteristics

Keep the default selections for:

• Industry Detail Level
• Firm Ownership

Click “Check All” under Industries

Step 3 – Worker Characteristics

In the drop down menu for “Select Worker Characteristics by” - select “Race and Ethnicity”

• Check all boxes under “Race”
• Check all boxes under “Ethnicity”

Step 4 – Indicators (1 of 3)

Step 4 – Indicators (2 of 3)

Step 4 – Indicators (3 of 3)

Step 5 - Quarters

For this report the latest 2013 value was represented b y 1QTR 2013 + 3 previous QTR avg.

Step 6 – Summary and Export

* Be sure to check “Include Labels”

• Steps 1-6 were repeated for each MSA and

specified year

• 15 MSAs in total
• 1998, 2002, 2007, 2010, 2012, & 2013
• The combined results created a workbook

with over 127,000 lines of data

Cleaning Up the Data

• Get rid of excess columns of information that

are not beneficial

• Example: Education and Sex columns
• Allows for better readability and organization

Cleaning up the data

Columns retained: Geography, Industry, Race, Ethnicity, Year, Quarter, Employment, New Hires, Separations, Turnovers, Average Monthly Earnings, New Hire Average Monthly Earnings,

Cleaning up the data

 Adding a new variable – “Calculated

Year”



Combines the quarters into the correct year (ex: QTR 2 2012 + QTR 3 2012 + QTR 4 2012 +QTR 1 2013 = 2013)



Useful when creating pivot tables

Cleaning up the data

 Renaming labels  Adding filters

 Data Tab  Highlight top row

 Filter Button

Old Label New Label geography_label Region industry_label Industry race_label Race ethnicity_label Ethnicity Emp Total Employment HirA New Hires Sep Separations TurnOvrS Turnovers EarnS

• Avg. Monthly Earnings

EarnHirNS

• Avg. Monthly New Hire Earnings

Creating Pivot Charts

 Click on Insert tab  Click on PivotTable – Select Pivot

Chart

Creating Pivot Charts

Creating Graphs

Define new variables as: T

• tal Minority Workers = G2/I2

African American/Black Alone Minority = C2/I2 Asian Alone Minority = D2/I2 Hispanic Minority = F2/I2 Other Minority = E2/I2

New variables represent the percentage of jobs in all NAICS sectors held by racial and ethnic minority workers.

Creating Graphs

Create a pivot table

• Click on Insert tab
• Click on PivotTable – Select Pivot Chart

Creating Graphs

Using the pivot chart feature to create a graph makes it easier to order the data and format as desired.

Why does this matter?

“Diversity and inclusion is an economic imperative for the Pittsburgh region as we cannot continue to grow regional employment into the future if the population maintains its current racial and ethnic composition”