Core Competency Data in Data Library

INTRODUCTION

The Data Library enables users to quickly look at differences across regions, occupations, and industries. Core Competency Data in the Data Library adds granularity to regional Industry employment and compensation data, showing the knowledge, skills, and abilities (KSAs) associated with a given occupation or Industry’s employment.

OVERVIEW

The 2018-2022 Core Competency Data applied to all IMPLAN Data Set Years for all counties and states in the U.S. are available in Data Library.

Find more information in the Occupation and Core Competency Data article.

The 2023 Data Year, which utilizes the 528 Industry Set, is not currently available in Data Library. The 528 Industry Set is specifically for the U.S. data in the 2023 Data Year at this time. All previous Data Years currently available in Data Library (2001-2022) will require the use of the 546 Industries Set until the release of the updated IMPLAN 528 Industry Set time series data (coming in 2025).

DASHBOARD 

This Dashboard includes 6 tiles, one for each Competency Type. All tiles are table charts showing Competency Points and Competency Share of Total by Competency Code, Description, and Extended Description for the filtered Occupation(s) at the filtered Occupation Aggregation Level with the filtered Region(s):

  • Summary Table - Ability
  • Summary Table - Knowledge 
  • Summary Table - Skill
  • Summary Table - Education Required
  • Summary Table - Work Experience Required
  • Summary Table - On-the-Job Training Required

Competency Dashboard.png

When viewing a Dashboard, select the filters to change the data points displayed. Filter options include:

  • Data Year: most recent by default
  • State: by default, North Carolina. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.
  • County: no county filter is set by default
  • Aggregation: aggregation level of Industries by default is the unaggregated 546 scheme
  • Industry: no industry filter is set by default
  • Occupation Data Year: most recent by default
  • Occupation Level: by default, 3-minor
  • Occupation: no default set, options available will depend on Occupation Level filter

The Dashboard Actions in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Tile actions (a series of three vertical dots that appears in the upper right of a tile when hovering over it with a cursor) for the option to download the data within that tile. Select Explore from here within the Tile actions to access more data query options. Exploring from the Dashboard allows users to dig into the data starting from the settings within the Dashboard tile. 

EXPLORE

Explore the Core Competency Data by selecting Core Competency Data from the Explore drop-down menu, or by selecting Explore from here from a Core Competency Data Dashboard Tile or Look. 

By default in Explore, filters are set for State: North Carolina and Data Year: most recent. Because of the amount of data in this section, these default filters have been set to improve data query performance. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years. The default Aggregation Scheme Param is 546 Unaggregated. Industry Dimensions will be available in the 546 Industry scheme with this setting. 

FILTER-ONLY FIELDS

AGGREGATION SCHEME PARAM

The aggregation filter provides the option to view data by Industry at one of the following levels of granularity:

  • 546 Unaggregated: most granular. Data is available for each IMPLAN Industry according to the most recent 546 Industry Scheme. 
  • IMPLAN 2 Digit NAICS 546: Data is aggregated for Industries corresponding to each 2 Digit NAICS.
  • IMPLAN 3 Digit NAICS 546: Data is aggregated for Industries corresponding to each 3 Digit NAICS.

Download the 2022 aggregated NAICS to IMPLAN 546 Industries bridge for details. 

DIMENSIONS

Select a Dimension to include as a column with all Dimension possibilities.

Select a Dimension.png 

Click Filter on a Dimension to specify which Dimension possibilities appear in the data query. 

Filter a Dimension.png

Click Pivot on a Dimension to transpose the Dimension rows into columns. 

Pivot a Dimension.png

Dimensions Details
Competency Code All O*NET™ Element IDs are possible Competency Codes Dimensions. 
Competency Description

All O*NET™ Element Names are possible Competency Description Dimensions. 


This Dimension describes the unique Elements within the Core Competency Types.   

Competency Extended Description

All O*NET™ Elements are possible Dimensions. 

This Dimensions describes the Competency Type and Description in sentence form. 

Core Competency Type All six Core Competency Types are possible Dimensions.
County

All U.S. counties are possible Dimensions. 

When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.

Data Year All IMPLAN Data Years are possible Dimensions.
Five Digit Fips

A Five Digit Federal Information Processing Standards (FIPS) is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit FIPS codes are possible Dimensions.

This Dimension is used to map the data in the County View Map Chart found on the Dashboard. This file contains FIPS codes for all counties and states.

Industry All 546 IMPLAN Industries (Code and Description) are possible Dimensions. 
Industry Code All 546 IMPLAN Industry Codes (numbers) are possible Dimensions. 
Industry Description  All 546 IMPLAN Industry Descriptions (names) are possible Dimensions. 
Occupation All Occupations (Code and Description) are possible Dimensions. The Occupations included in this Dimension will depend on the Occupation Aggregation Level. 
Occupation Aggregation Level

The following Occupation Aggregation Level options allow users to display Occupations by either 1, 2, 3, 4, or 5 digit Occupation Codes:

1 - Total (all Occupations, only one Occupation Category)
2 - Major 
3 - Minor 
4 - Broad 
5 - Detail (most granular level of occupations)

Occupation Code All Occupation Codes are possible Dimensions. The Occupation Codes included in this Dimension will depend on the Occupation Aggregation Level. 
Occupation Description All Occupation Descriptions are possible Dimensions. The Occupation Descriptions included in this Dimension will depend on the Occupation Aggregation Level. 
Region 

All 50 states plus the District of Columbia are possible Dimensions. 

Pivoting or selecting Region will display filtered states when filtering on state and will display filtered counties when filtering on county. 

State All 50 states plus the District of Columbia are possible Dimensions. 

MEASURES

Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query. 

Measures Details
Competency Points Competency Points indicate the level of importance of a given competency. 
Competency Share of Total Ratio of competency points to the total competency points.  
Employee Count Number of Employees estimated at the competency level. 
Employee Count Share of Total Ratio of number of employees at a competency level to the total number of employees.
Location Quotient Measures the relative concentration of a competency or occupation within a given Region to the concentration of the competency or occupation within the United States. 

RELATED ARTICLES 

IMPLAN Data Library

Explores - Looks - Dashboards

Occupation and Core Competency Data

 

Written August 30, 2023

Updated December 31, 2024