COMPETENCY BY OCCUPATION 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, use 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 Level: by default 1-total
- Occupation: no default set, options available will depend on Occupation Level filter
The gear in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Table Menu (a series of three vertical dots that appears in the upper right of a tile when hovering over it with your cursor) for the option to download the data within that tile. Choose “Explore from here” within the Table Menu to access more data query options. Exploring from the Dashboard allows you to dig into the data starting from the settings within the Dashboard tile.
EXPLORING CORE COMPETENCY DATA
Explore the Core Competency Data by choosing Core Competency Data from the Explore dropdown menu, or by choosing “Explore from here” from a Core Competency Data Dashboard Tile or Look.
By default in Explore > Core Competency Data, 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.
EXPLORE: 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 aggregated NAICS to IMPLAN 546 Industries bridge for details.
EXPLORE: DIMENSIONS
Select a Dimension to include as a column with all Dimension possibilities. Filter a Dimension to specify which Dimension possibilities appear in the data query. Pivot 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/geographies/reference-files/2017/demo/popest/2017-fips.html 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 you 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 Description 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. |
EXPLORE: 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
Occupation & Core Competency Data "From the Data Team"
Written November 16, 2020
Comments
0 comments
Article is closed for comments.