Governor’s Conference 2011 Driving decisions with LMI Roundtable

1. U.S. Department of Labor—Employment & Training Administration| Missouri Economic Research and Information Center| Missouri Department of Economic Development Governor’s Conference 2011Driving decisions with LMIRoundtable This project has been funded, either wholly or in part, with Federal funds from the Department of Labor, Employment & Training Administration under Task Order Number DOLJ061A20373; the mention of trade names, commercial products, or organizations does not imply endorsement of same by the U.S. Government.

2. LMI for Outlook Decision Makers Tour of synthesized LMI portals for: • Historic and Current Conditions • Labor Force • Workforce • Cluster-Based Development • Skills Gap • What strategic planning data would you like explored/discussed today? Or

3. Missouri Economic Research & Information Center (MERIC) Meredith Hill Economic Research Analyst www.missourieconomy.org

4. Indicate your team. Your turn, please. • Workforce Investment Board • DWD Business Representatives • DED Business or Industry Representative • Rapid Response Coordinator • NGCC Staff • Elected Officials • Municipal or Regional Staff • Community Development Organization • Other 0 0 0 0 0 0 0 0 0

5. What question would you likeanswered or discussed today?

6. 0 0 0 Where can I find such data? Case Study After reading about Graduate St. Louis, and the Workforce Consortium’s efforts to increase the educational attainment of the 25-64 year old resident population, I am interested in my region’s education profile. • What percent of the Cape Girardeau MSA is 25-64 years old? • What is the educational attainment of the population? • What is the employment Status of the population? Office of Social and Economic Data Analysis Local Employment Dynamics Quarterly Census of Employment & Wages

7. American Community Survey - OSEDA

8. American Community Survey

9. OSEDA Summary Tables Demographic Housing • Age • Age & Sex • Race • Hispanic or Latino (Any Race) • Housing Occupancy & Tenure • Units in Structure • Year Structure Built • Year Householder Moved into Unit • Vehicles Available • House Heating Fuel • Selected Characteristics (Amenities) • Occupants per Room • Home Values • Selected Monthly Owner Costs • Gross Rent

10. OSEDA Summary Tables Economic Social • Household Income & Benefits • Family Income & Benefits • Other Income Measures • Poverty Status • Employment Status • Children w/ Working Parents • Commuting to Work • Workers by Occupation/Industry • Class of Worker • Persons/Household by Type • Relationships/Marital Status/Fertility • Grandparents as Caregivers • School Enrollment • Educational Attainment • Veteran Status • Disabled by Age • Residence 1 Year Ago • Place of Birth and Citizenship Status/Year of Entry • World Region of Birth of Foreign Born/Language Spoken at Home

11. OSEDA Results Format • - Chart Generation • - Original Census Table Numbers Provided

12. OSEDA – ACS Results Format • Click on a single geography to see multiple years of ACS data • Results are reported in a grey scale. The darker the color the more reliable the result (+/- margin of error)

13. OSEDA – ACS Data Reliability • CAUTION: “In Military” is barely visible because it has a +/- 179.25% possible margin of error.

14. OSEDA Chart Options

15. Website Links Office of Social and Economic Data Analysis: mcdc1.missouri.edu/acsprofiles/acsprofilemenu.html Economic Indicators eLearning Webinar: Module 1: Lesson 1– LMI Fundamentals http://www.missourieconomy.org/e_learning/index.stm

16. 0 0 0 Where can I find such data? Case Study During case study conversations conducted by MERIC, in support of the State of St. Louis Workforce 2011 report, employers reported an aging workforce. I want to report this qualitative data in a quantitative way using labor market information. • I need to collect total employment by age cohort for the St. Louis MO-IL MSA. American Community Survey Local Employment Dynamics Quarterly Census of Employment & Wages

17. QWI – Detailed by State

18. LED – Quarterly Workforce Indicators & OnTheMap

19. QWI by Age, Education or Race

20. QWI – Detailed by Geography Step 1 Step 2. Note (MO Part) Step 3

21. QWI – Workforce Trends 1. Double Check Age, Ed, Race 2. Make Elections Table will change with each election

22. QWI – Detailed by Demographics

23. QWI – Detailed by Demographics 1. Hold CONTROL to elect multiple years. 2. Download Excel

24. QWI – Aging Workforce Summary St. Louis MSA (MO & IL Combined)

25. Website Links LED Quarterly Workforce Indicators: http://lehd.did.census.gov/led/datatools/qwi-online.html Economic Indicators eLearning Webinar: Module 3: Lesson 1– LMI and Strategic Planning http://www.missourieconomy.org/e_learning/index.stm

26. 0 0 0 Which is NOT a MO Advanced Mfg industry? Case Study Last month MERIC released the first of seven Target Cluster Analyses. The seven clusters were identified in the 2010 Strategic Initiative for Economic Growth developed by the Department of Economic Development. Cluster employment estimates and projections were used to determine the level of education/skills required by Missouri’s Advanced Manufacturing workers. Petroleum and Coal Products Mfg Architectural and Structural Metals Mfg Computer and Peripheral Equipment Mfg

27. Target Industry Clusters

28. Target Cluster Occupation Analysis • Strategic Initiative for Economic Growth • Missouri • Advanced Manufacturing • 29 Industries (4-digit NAICS) • Food • Transportation Equipment • Fabricated Metal Product • Machinery • Chemical

29. Innovation In American Regions

30. Cluster-Based Economic Development Industry Clusters • Advanced Materials • Agribusiness • Apparel & Textiles • Arts, Entertainment, Recreation • Biomedical/Biotechnical • Business and Financial Services • Chemicals • Defense and Security • Education and Knowledge Creation • Energy • Forest and Wood Products • Glass and Ceramics • Information Technology and Communications • Transportation and Logistics • Manufacturing Supercluster • Mining • Printing and Publishing

31. Target Cluster Occupation Analysis • Staffing patterns are part of the BLS employment projections project. • Proprietary/confidential • For each industry, staffing patterns report: • The types of occupations, and • The number of jobs per occupation. A manufacturing plant might have a registered nurse on staff, but not as many as a hospital would have on staff.

32. National Staffing Patterns

33. Target Cluster Occupation Analysis • 782 Occupations in Missouri • 395 Occupations in Missouri’s Advanced Manufacturing Cluster • Inspectors, Testers, Sorters, Samplers, and Weighers is in all 29 industries, but • Agricultural Engineers is only in 1 industry.

34. Target Cluster Occupation Analysis • Long Term Occupation Projections

35. How often do you use staffing pattern information in your routine work? Industry/Occupation Staffing Patterns • All the time/I’m an expert • Often/I understand their application • Sometimes/I understand the work of colleagues • Infrequently/I am sure they are used in reports I rely on but I don’t know their process • Never/I don’t think they are applicable to my work 0% 0% 0% 0% 0%

36. Cluster Workforce Analysis • What is the distribution of jobs, by occupation, for a cluster? • Is the distribution projected to change?

37. Education Required by Skills Level

38. Cluster Workforce Analysis • What is the current jobs distribution by occupation skill level? • What is the distribution for the projected jobs to be filled (new and replaced)?

39. Cluster Workforce Analysis • How do the skill levels needed for Advanced Manufacturing compare to all projected jobs for Missouri?

40. Website Links Missouri Target Industry Clusters: www.missourieconomy.org/pdfs/MoTargetsAdvancedManufacturing.pdf Innovation in American Regions: www.statsamerica.org/innovation/index.html/ Economic Indicators eLearning Webinar: Module 2: Lesson 1– Creating a Career Pathway http://www.missourieconomy.org/e_learning/index.stm

41. What type of data analysis is most useful to you? (Elect all that apply) Occupation and Job Numbers • Jobs by Occupation • Jobs by Education/Skill • Occupations by Industry/Cluster • Cluster Reports including Establishments, Employment & Wages • Regional Comparisons • Statewide data • All of the above 0% 0% 0% 0% 0% 0% 0%

42. Go Live

43. Thank you for your participation! Meredith Hill Regional Liaisons Tony Brite - Northwest Tom Reichart - Northeast John Kozel - Central Sonal Hate - Ozark/Southwest/Kansas City Vicinity (Mike Muin) - St. Louis (Lindsey Peters) - West Central Economic Research Analyst 573-751-0288 meredith.hill@ded.mo.gov Southeast/South Central Regions