1 / 32

A whirlwind tour of EDS

A whirlwind tour of EDS. Almis Database Seminar August 15-17, 2005. What is OES?. Federal-state cooperative program Semi-annual mail survey Produces employment and wage estimates for over 700 occupations Produces estimates by geographic area and for over 450 industry classifications.

geoff
Download Presentation

A whirlwind tour of EDS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A whirlwind tour of EDS Almis Database Seminar August 15-17, 2005

  2. What is OES? • Federal-state cooperative program • Semi-annual mail survey • Produces employment and wage estimates for over 700 occupations • Produces estimates by geographic area and for over 450 industry classifications A whirlwind tour of EDS

  3. Who uses the data? • Employers • Workers • Workforce boards • Economic developers • Legislators A whirlwind tour of EDS

  4. The sample • Full and part-time wage and salary workers in non-farm industries • Includes probability and certainty units • Stratified, weighted sample based on FIPS, MSA, industry, and size • Up to 200,000 establishments per panel A whirlwind tour of EDS

  5. The survey • Industry-specific forms • Collects raw employment by occupation and class of wage • Collected by state workforce agencies and nationally • Survey Processing And Management system A whirlwind tour of EDS

  6. The calculation • Up to six panels combine to produce a single set of estimates • Uses imputation for non-response • Employment cost index updates old data • Weighted employment is benchmarked against the 202 • Employment, P10/25/50/75/90, mean, entry experienced wage, generally annual and hourly A whirlwind tour of EDS

  7. Files provided to states • Finished estimates for the following geographies and industries • National, Statewide, MSA, and BOS • Cross-industry, division, NAICS-3, NAICS-4, and partial NAICS-5 • "Establishment" and "detail" microdata files • Imputation donor lists • ALMIS files A whirlwind tour of EDS

  8. What is EDS? • Produces estimates for areas other than MSA/BOS • Custom occupation and industry rollups • Ad-hoc requests • Tools for data review and post-estimation screening • Can update finished estimates using ECI factors • Exports for Almis, MM, and a Q&D web presence A whirlwind tour of EDS

  9. System basics • Currently two versions, 3.3 and 4.1 • 3.3 based on Visual Foxpro desktop database • 4.1 uses MySQL • Load data • Define areas and estimates • Calculate results • Review and suppress questionable cells • Export the results A whirlwind tour of EDS

  10. Loading data • Selecting data to load • Applicable pub files • Applicable microdata • Imputation donors • Pub files and microdata can be loaded in any order • Donors must be loaded after establishment data A whirlwind tour of EDS

  11. EDS 4.1 signon panel A whirlwind tour of EDS

  12. The EDS pub import A whirlwind tour of EDS

  13. Main panel – Import tab A whirlwind tour of EDS

  14. Main panel – Estimates tab A whirlwind tour of EDS

  15. Area properties – Details A whirlwind tour of EDS

  16. Area properties – Map A whirlwind tour of EDS

  17. Estimate properties – classes A whirlwind tour of EDS

  18. Estimate properties - options A whirlwind tour of EDS

  19. Estimate properties – results A whirlwind tour of EDS

  20. Estimate properties – history A whirlwind tour of EDS

  21. Cell properties – results A whirlwind tour of EDS

  22. Cell properties – schedules A whirlwind tour of EDS

  23. What is a poison schedule? • A questionable schedule that seems to negatively affect results • Effect is based on contribution of all questionable schedules as a percentage of final result • Small contribution, little effect • Larger contributions “kill” the result • Work like waivers, applied to both current and future cells involving the schedule A whirlwind tour of EDS

  24. Cell properties – related occs A whirlwind tour of EDS

  25. What is a related occupation? • Based on O*Net nearest neighbor matrix • Six possible (adjustable) salary relations • Pays much less • Pays somewhat less • Pays about the same • Pays somewhat more • Pays much more • N/A • Related cell must be publishable to be compared A whirlwind tour of EDS

  26. Cell properties – area and year comparison A whirlwind tour of EDS

  27. Cell properties – history A whirlwind tour of EDS

  28. Underlying microdata A whirlwind tour of EDS

  29. Cell properties – related occs A whirlwind tour of EDS

  30. Suppressions • Employment and wages may be set independently • Publish settings • Always publish • Never publish • Publish based on screening • Locked cells are ineligible for rescreening • Advanced options allow screening to be applied to ranges of cells A whirlwind tour of EDS

  31. Almis export A whirlwind tour of EDS

  32. Resources: • EDS web site: http://www.oes-eds.com • EDS Yahoo! Group message archive http://groups.yahoo.com/group/EDSNewsLetter • tom.price@ncmail.net 919.733.2936 A whirlwind tour of EDS

More Related