Workforce Data Analytics - Demo

Revelio Labs provides workforce intelligence analytics. We absorb and standardize hundreds of millions of public employment records to create the world's first universal HR database, allowing us to see workforce composition and trends of any company, public or private. We’ve created a standard structure to unify occupations and job titles, skills and activities, and companies and other organizations. Our team of data scientists, economists, and engineers use the latest methods in statistical research to remove sampling bias, and anticipate lags in reporting to create a comprehensive and current understanding of workforce dynamics in every region and across every industry. Our data provides insights on company composition, hiring and attrition trends, geographic composition, career transitions, diversity, and more.

This is a sample dataset for 6 companies lagged by a year. The complete dataset, or an expanded version of our trial set, can be accessed through our personalized listing.

Some of our key tables in the shared schema include:

Workforce Dynamics (Geography, Demographics, Roles), Skill Dynamics,
Transitions (Inflows, Outflows), Individual,
Job Posting Dynamics
Employee Review Trends, Employee Reviews, Employee Sentiment,
Company Reference

Every dataset will include our Revelio Company Universe identifier (RCID) which you can use to centrally identify a company across all datasets.

Key data fields include:

1. Company Reference table:
- rcid
- company
- linkedin_url
- ticker
- exchange_name
- factset_entity_id
- cusip
- sedol
- isin
- naics_code
- cik
- lei
- sic

2. Employee Review Trends table:
- rating_overall
- rating_career_opportunities
- rating_compensation_and_benefits
- rating_culture_and_values
- rating_diversity_and_inclusion
- rating_senior_leadership
- rating_work_life_balance
- rating_business_outlook

3. Job Posting Dynamics table:
- job_category
- start_date
- active_posting
- new_posting
- removed_posting
- active_salary_avg
- filling_time_avg

4. / 5. Transition Inflow & Outflow tables:
- prev_company
- prev_seniority
- prev_salary
- new_company
- new_seniority
- new_startdate
- new_salary

6. Workforce Dynamics: Demographic Breakdown table
- company
- gender
- ethnicity
- month
- count
- inflow
- outflow
- salary

7. Workforce Dynamics: Geographic Breakdown table
- company
- region
- country
- state
- metro_area (metropolitan statistical area)
- count
- inflow
- outflow
- salary

8. Workforce Dynamics: Role Breakdown table
- job_category
- role_k50
- role_k150
- count
- inflow
- outflow
- salary

9. Skills Dynamics table
- company
- seniority
- job_category
- skill
- month
- count
- inflow
- outflow

Full schemas for each dataset can be found in our data dictionary: https://www.data-dictionary.reveliolabs.com/

搜集汇总

背景与挑战

背景概述

该样本数据集来自Revelio Labs的全球人力资源数据库，涵盖6家公司的劳动力动态信息，包含员工构成、技能分布、职业流动等核心维度。数据通过标准化处理消除抽样偏差，提供公司参考、员工评价、职位发布等8类结构化表格，可通过唯一标识符RCID进行跨数据集关联。