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-2021 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 Data Details article.
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
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 1-total
- 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 dropdown 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.
Click Filter on a Dimension to specify which Dimension possibilities appear in the data query.
Click Pivot on a Dimension to transpose the Dimension rows into columns.
| 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 2018 and earlier are possible Dimensions. 2019 data coming soon. |
| 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. A list of FIPS codes can be found at the following link: https://www.census.gov/library/reference/code-lists/ansi.html#top This Dimension is used to map the data in the County View Map Chart found on the Dashboard. |
| 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) 5 - Detail (includes 823 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
Written August 30, 2023