Overview
Profiles Table and Profiles Map help users explore publicly available professional profile data and analyze the supply side of the labor market across regions, schools, occupations, industries, companies, skills, and other workforce characteristics.
A profile represents an individual worker's publicly available professional information collected from various public online sources. Lightcast processes and enriches this data to standardize information such as company names, occupations, skills, and geography, and performs additional filtering to improve compatibility across Lightcast data sets.
Profiles Table and Profiles Map provide flexible tools for analyzing profile data through filtering, customizable metrics, exports, and geographic visualizations. These reports are available for US, UK, and Canada across Analyst wherever Profile Analytics is offered.
Note: Profile data is self-reported. To learn more about how profile data is collected and its limitations, see [Self-Reported Nature of Profile Data]. |
Helps to Understand
These reports can help answer questions such as:
How many worker profiles match the selected criteria?
Which job titles are represented within the selected population?
Which industries employ the selected workforce?
Which occupations are associated with these profiles?
Which companies employ the selected workforce?
Which schools did these workers attend?
What workforce characteristics, such as tenure and experience, are represented?
What demographic trends, such as gender representation, can be observed?
How does profile supply compare with job posting demand?
How are profiles distributed across geographic regions?
How to Generate the Report
To generate a Profiles Table or Profiles Map report, begin by selecting the filters that define the workforce you want to analyze such as occupation, region, company, industry, or skills.
After you've selected your criteria, run the report to explore workforce profile insights for the selected population.
Once the report is generated, the filters remain available in the left-hand panel, allowing you to further refine your results.
Note: Searching across all profiles may result in slower performance. For the best experience, apply one or more filters. |
Selecting Report Filters
Use the following filters to define the workforce you want to analyze before generating the report.
Select a Region:
The region selection process differs slightly between Profiles Table and Profiles Map.
Profile Table | Profile Map |
Select a region using either Government Region or City.
| Select either All Available or Limit by Region.
|
Selecting Government Region opens the Advanced Region Selection window. | Selecting Limit by Region opens the Advanced Region Selection window. |
Note: The Advanced Region Selection window provides additional options for defining geographic areas. |
Select a School
Select one or more schools to include in the report.
Available options include:
Specific Schools – Search for and select individual institutions.
Schools in a Region – Include schools located within selected geographic areas.
Note: Selecting Schools in a Region opens the Advanced Region Selection window. |
Select a Profile Graduation Year
Choose one of the following options:
Any: Include all available graduation years.
Select Range: Limit results to a specific graduation year range.
When using Select Range, select the start and end years from the dropdown menus.
Select Data to Display
Before generating the report, choose the data categories you would like to include.
Available options include:
Online Profiles
Gender % Breakout
Longevity
Posting Comparisons
Custom Data Selection
Enabling a category automatically adds the associated metrics and columns to the report.
Category | Metrics Added |
Profiles | Online Profiles, and % of Online Profiles |
Gender % Breakout | Male %, Female % |
Longevity | Median Tenure, Median Years of Experience, Median Years in Current Role, and Median Moves in Current Company |
Posting Comparisons | Unique Postings, No: of Companies Posting, and Annual Median Advertised Salary |
Select Custom Data Selection to choose individual metrics rather than entire categories.
Optional Advanced Options
Configure additional filters using Advanced Options.
Select Run.
Advanced Region Selection
The Advanced Region Selection window allows you to define geographic areas more precisely when generating a Profiles Table or Profiles Map report.
Depending on your reporting needs, regions can be selected using drive-time analysis, distance-based searches, manual browsing, or saved groups.
Drive Time
Use the Drive Time tab to identify regions within a specified driving distance of a location.
Enter a city, address, business, or point of interest.
Specify a drive time.
Define how regions should be included in the results:
Contains region's centroid – Includes regions whose geographic center falls within the drive-time area.
Contains entire region – Includes only regions that fall completely within the drive-time area.
Contains part of region – Includes regions that intersect the drive-time area, even if only partially.
Select the geographic unit to use:
Counties
MSAs (Metropolitan Statistical Areas)
Select Select to apply the region(s).
Radius From Address
Use the Radius From Address tab to identify regions within a specified distance of a location.
Enter a city, address, business, or point of interest.
Specify a search radius.
Select the geographic units to include in the analysis.
Select Select to apply the region(s).
Like Drive Time, Radius From Address supports the same region inclusion options:
You can also apply these options when selecting either:
Counties
MSAs (Metropolitan Statistical Areas)
Browse
Use the Browse tab to manually select geographic regions.
The Browse tab allows you to filter and select regions by geographic level.
Select a geographic type:
Nation
State
MSA (Metropolitan Statistical Area)
County
Select a state or choose All States.
Use the search bar to locate specific regions.
Select individual regions from the results list or choose Select All.
Select Select to apply the chosen regions to the report.
The Browse option is useful when you know the specific geographic areas you want to analyze and prefer to manually select them rather than using drive-time or distance-based criteria.
Groups
Use the Groups tab to select from previously created region groups.
The Groups tab includes the following categories:
My Groups – Groups you have created.
Template Groups – Predefined groups provided within Analyst.
Org Groups – Groups created and shared within your organization.
All Groups – Displays all available groups.
Use the search bar to locate specific groups. You can select one or more groups to include in your report.
Examples of available groups may include geographic classifications or predefined regional groupings such as Rural-Urban Continuum Codes or regional divisions. |
How to Use Profiles Table
Profiles Table provides a detailed, tabular view of profile data, allowing you to compare workforce characteristics across job titles, industries, companies, occupations, and skills.
Profiles Table enables you to explore profile data in detail through customizable metrics, filtering, sorting, exports, and report navigation.
Use Profiles Table to:
Compare profile populations across different categories
Analyze workforce characteristics such as experience and tenure
Explore demographic and education-related metrics
Compare profile supply with job posting demand
Export aggregated profile data for further analysis
Analyze Data by Category
Use the tabs at the top of the report to view profile data grouped by different categories.
Job Title
View profile data grouped by job title. This view can help identify:
The most common job titles within the selected profile population
Compare workforce characteristics across roles.
Industry
View profile data grouped by industry using NAICS classifications.
Use this view to understand:
Which industries employ the selected workforce population
Compare profile metrics across industries.
Industry classifications can be viewed at the 2-digit through 6-digit levels using the digit selector.
Occupation
View profile data grouped by occupation using SOC classifications.
Use this view to:
Analyze workforce distribution across occupations
Compare profile metrics at different levels of occupational detail.
Occupation classifications can be viewed at the 2-digit through 5-digit levels using the digit selector.
Company
The Company tab displays profile data grouped by company, allowing you to analyze the organizations represented within the selected population and compare workforce metrics across companies.
Columns include:
Company
The columns you selected when generating the report
Skills
View profile data grouped by skills and qualifications.
The Skills tab displays profile data grouped by skills and qualifications, allowing you to analyze the skills represented within the selected population and compare workforce metrics across skills.
Columns include:
Skills & Qualifications
The columns you selected when generating the report
Select Additional Metrics
Use the Add/Remove Columns function to customize the data and metrics displayed in the table.
Additional columns can be added to provide deeper insights into profile populations, including:
Workforce demographics
Experience and tenure metrics
Education data
Comparisons between profile supply and job posting demand
Note: Selected metrics are added as new columns in the table and can be used for filtering and sorting. |
The available metrics are organized into categories such as:
Profile Metrics
These metrics help measure the size and distribution of the selected profile population.
Available metrics include:
Online Profiles
% of Total Profiles
Number of Companies Employing
Number of Schools
Profile Concentration
Gender Metrics
These metrics provide insight into gender representation.
Available metrics include:
Male %
Male
Female %
Female
Longevity Metrics
These metrics help analyze workforce experience and career progression.
Available metrics include:
Median Tenure - median number of years workers have been with their current employer.
Median Years of Experience - median number of years workers have spent in their occupation.
Median Years in Current Role - median number of years workers have been in their current role or job title
Median Moves in Current Company - The median number of times workers have changed roles or positions within their current employer
Posting Comparison Metrics
These metrics allow you to compare profile data with job posting demand.
Available metrics include:
Unique Postings
Number of Companies Posting
Posting Concentration
Filter Results
Use the filtering tools to narrow report results and focus on specific subsets of profile data.
The Filter option allows you to build one or more filter conditions based on the columns currently displayed in the table.
For each filter condition, select:
A column (when adding or removing columns you will be able to add/not add those columns to Filter)
A filter operator (contains, does not contain, and starts with)
A value
Select + Add Filter to add additional filter conditions. Multiple filters can be combined to further refine the results.
Filter conditions can be combined using logical operators AND and OR |
Add to Filter
Use Add to Filter to add selected row(s) directly to the report filters.
Exclude from Results
Use Exclude from Results to remove selected rows from the current report results.
Jump to Other Reports
Use Jump To to open selected results in related reports.
Available options include:
Profile Analytics
Profile Map
Profile List
For example, after identifying a job title in Profiles Table, you can open that selection in Profile List to view matching profiles.
Save and Export Reports
Save Reports
Select Save Report to preserve the current report configuration, including filters, selections, and displayed data.
Saved reports can be accessed from the Saved Reports section of the Home page.
Additional options include:
Share with your team
Add to a folder
Set up an email alert
Export Profiles Table
Profiles Table can be exported as:
Excel
CSV (Tableau, Domo, and other reporting tools)
How to Use Profiles Map
Profiles Map provides a geographic visualization of profile data, allowing you to explore how worker populations are distributed across regions.
Unlike Profiles Table, which presents data in a tabular format, Profiles Map helps you identify geographic patterns and concentrations of talent within your selected population.
Use Profiles Map can help you:
Compare profile populations across locations
Identify regions with high concentrations of talent
Explore workforce distribution geographically
Analyze regional trends within your selected criteria
Navigate to related reports for deeper analysis
The map is accompanied by a table containing geographic and profile metrics for the selected population.
Note: These metrics can be customized using the Add/Remove Columns option. |
Profiles Map includes many of the same analysis tools available in Profiles Table, allowing you to refine results, customize displayed metrics, and navigate to related reports.
Available actions include:
Filter
Add to Filter
Exclude from Results
Jump To
Add/Remove Columns
Save
Export
Customize the Map Display
Profiles Map includes several visualization options that allow you to tailor the map display to your analysis needs.
Themes
Change the appearance of the map using one of the available themes:
Light: Provides a simplified view that can make data overlays easier to read.
Standard: Displays the default map view.
Satellite: Displays satellite imagery for additional geographic context.
Data Layers
Use Data Layers to control how profile data is displayed on the map.
The Online Profiles layer visualizes the distribution of profile populations across the selected geography.
Available customization options include:
Colors
Choose a color scheme to improve visibility or align with presentation preferences:
Blue
Green
Purple
Display Styles
Select how geographic areas should be shaded:
Choropleth: Uses varying color intensity to represent differences in profile concentrations across regions.
Solid Fill: Applies a uniform fill style to selected geographic areas.
Navigation Tools
Use the map controls to explore data more closely:
Located on the top-left corner of the map, the Zoom In function helps you to focus on specific geographic areas.
Located on the top-left corner of the map, the Zoom Out function helps you to view broader regional patterns.
Located on the top-right corner of the map, the Expand to Full Screen function helps you to maximize the map workspace and improve visibility when analyzing larger datasets.
Export Profiles Map
Profiles Map can be exported as:
Excel
Word
PDF
Image
CSV (Tableau, Domo, and other reporting tools)
Profiles List
Profiles List displays individual profiles matching the selected criteria.
Users can browse profile records and continue exploring worker-level profile information.
Profiles List supports exporting to:
Excel
Excel Multiple Regions - This will run and export the report for each region selected. Requires more than one region selected (max of 20 regions).
Additional Notes
Self-Reported Data
Profile data includes self-reported information gathered from publicly available professional sources. For additional information, see Self-Reported Nature of Profile Data.
Regional Availability
Available columns and metrics may vary by geography. Certain concentration metrics are available only for US datasets.