17/07/2024 | Press release | Distributed by Public on 17/07/2024 14:48
By Michael Jeanfreau, Senior Economist
Bridging state expertise with federal reach: The power of partnership in labor market data
In today's data-driven world, understanding local economic conditions is crucial. However, a significant challenge in workforce data analysis is the occasional lack of detail to address specific questions. Broad trends and patterns can be observed across large regions or groups, but zooming in on smaller areas or particular demographic segments remains difficult. For instance, while general employment trends in a state may be apparent, discerning the nuances of what happens in a small town or among a specific group of workers can be challenging. This gap in detail hampers the ability to tailor solutions or policies that meet the unique needs of these smaller or specific groups.
The Longitudinal Employer-Household Dynamics (LEHD) program, a partnership between state labor market information agencies and the U.S. Census Bureau addresses this issue by joining federal and state datasets into a comprehensive database. This information enables job seekers to pinpoint which industries are hiring and where, assisting them in targeting their job searches and training efforts more effectively. Small business owners can analyze trends in their specific sectors to make informed decisions about when to expand or invest in new areas.
Additionally, educators can use this data to adjust curricula to better align with market demands, ensuring students gain relevant skills that increase their employability. This detailed data serves as a useful tool for economic and career planning across the state.
The program underscores the power of partnership in understanding local labor markets. For residents of Utah, the LEHD program provides easy access to detailed and practical employment data.
How the QWI Explorer benefits Utahns
One of the most accessible tools available from these partnerships is the Quarterly Workforce Indicators (QWI) Explorer. This interactive tool allows users access to detailed quarterly statistics about employment gains, losses, and earnings by industry, age, and gender for more than 95% of U.S. jobs, including those in Utah.
Practical uses for the average user in Utah
For the average Utahn, this information can be a goldmine. Here are a few practical ways individuals might utilize the dataset:
Getting started with the QWI Explorer for Utah: Step-by-step guide
The QWI Explorer has many options available to select specific segments of data. The following section will be a tutorial of how to use the QWI Explorer to look at areas of interest in Utah. For this demonstration, selections will be made to examine job creation in Cache County in young manufacturing firms founded in the last three years. To get started, navigate to the QWI Explorer by clicking this link, navigating to the website via any web search engine, or the U.S. Census Bureau webpage. Additionally, links are available to the QWI Explorer and other related resources on the Department of Workforce Services' website for economic data under the Related Labor Market Websites webpage.
When the QWI Explorer first opens, it shows a default graphical representation-a chart depicting employment trends over time. This graph gives an immediate visual summary of the selected data. As selections are made and filters applied, the graph will change. Follow the instructions through the selection screen to get the desired data (see screenshots below for visual reference).
Indicator:Directly below the geographic selection, there is an 'Indicator' drop-down menu. To look at job creation, select "FrmJbGn - Firm Job Gains: Counts (Job Creation)."
Filters/aggregations:The filter and aggregation area is where the majority of "zooming in" happens. Clicking on each of the filter links brings a pop-up that allows a check-box of multiple areas of interest and various levels of specificity.
Starting with Geography, set Geography Type to Counties and select Cache, UT.
Under NAICS Sectors, select "31-33 Manufacturing."
In Firm Ownership, select "All Private Ownership." Here, selections can also be made about firm age or size. For this exercise, select "0-1 Years" and "2-3 Years" under Firm Age. Do not make any selections for Firm Size.
While worker characteristics can be filtered, leave the filter as "None" for this exercise. This leaves a wide range of characteristics that can be viewed.
After these selections are made, QWI Explorer will appear as this.
X-axis selection:The timeline, or X-axis, of the chart can be adjusted to change what data is on the X-axis or to show different spans of time if a longer time period is preferable. For this exercise, extend the time selection to 2015 to get a picture before and after 2020.
Under the X-axis drop-down menu, click on "20 Quarters Selected." This will bring up a selection screen.
Select available quarters back to 2015 by either selecting each quarter individually or simply clicking the checkmark next to a year to select the entire year.
Group by option:Next to the X-axis options, the 'Group' feature allows users to categorize data by demographics like age or gender, or by different industry sectors. This segmentation can highlight specific trends within the workforce. Change the group to education in the drop-down.
After making the above selections the QWI Explorer will look like this: