Human Capital Management Data Warehouse

1
Human Capital Management Data Warehouse

• Noel Pelletier
• Business Intelligence/Analytics Specialist
• Public Sector

2
Visibility and Insight to Optimize Human Capital
Management
SAMPLE METRICS
BENEFITS
Workforce Profile

• Provide a consistent and accurate view of
  workforce to management
• Identify and Retain Key Employee Talent
• Lower Costs through reduced Turnover and targeted
  Recruiting
• Optimize Compensation Plans to meet goals while
  managing Costs
• Reduce Time and Cost of Compliance Reporting
• Better Utilize Personnel and Skills
• Optimize Staffing across Organization
• Manage Leave and Absence of Workforce
• Understand and Plan Workforce Development Needs

Compensation
Recruitment

• Headcount
• Length of Service
• Age
• FTE Pct
• Terminate Count
• Hire Count
• Promotion Count
• Transfer Count
• Turnover Rate
• Incident Count
• Grievance Count
• Hire to Separation Ratio
• Contingent Labor Utilization
• Involuntary Term Rate
• Minority Headcount

• Regular Hours
• Overtime Hours
• Base Amount
• Variable Amount
• Month to Date Hours
• Earnings Rate
• Pension Amount
• Current Leave Balance
• Leave Taken YTD
• Absence Duration
• Deduction Costs

• Applicant Count
• Offer Count
• Hire Count
• Time to Fill
• Time to Hire
• Job Opening Count
• Expense Amount
• Screening Score

Learning Development

• Trained Headcount
• Time Spent Training
• Costs per Training Unit
• Review Rating
• Competency Headcount
• Accomplishment Test Score
• Government Credit Hours
• Achieved Proficiency

3
Workforce Profile Analysis -Understand
Workforce Composition and Movement

• Review workforce by length of service, age,
  gender, salary grades, position or job, or
  organizational parameters
• Understand Workforce Movement (Transfers,
  Promotions, Terminations) duration and counts
• Investigate HR discrepancies
• Review Personnel Action Requests

Sample Questions

• What is the workforce total FTE this month?
• What is total number of my employees?
• What is the average age of my employees?
• What is the average length of service of my
  employees?
• What is the average length of time my employees
  have been serving in his/her current job code,
  department, salary grade?
• What is the hiring, attrition, transfer, and
  promotion rate by department, agency, geography,
  etc.?

• Average Headcount by Dept.
• HR Ratio
• FTE
• Service Duration
• Promotion Count

• Employee-Supervisor Ratio
• Job Code Duration
• Transfer Count
• Terminate Count
• Number of Retiring Employees

4
Workforce Profile Analysis -Plan and Manage
Retention Effectively

• Monitor employee accessions and losses
• Analyze voluntary vs. involuntary turnover by
  reason, organizational unit, gender, and other
  specified aspects
• Review employee processes for purposes of
  restructuring
• Identify length of service trends across the
  organization

Sample Questions

• Does my organization have involuntary separation
  issues?
• What is the attrition rate by service duration,
  jobcode, age, sex, etc?
• What are the main reasons for voluntary
  separation?
• What is the annual attrition rate by agency,
  jobcode, etc.?
• How is the hire to separation, and hire to total
  headcount ratio across the organization?

SAMPLE METRICS

• Male / Female TO Rate
• Annualized Turnover
• Voluntary Termination Ratio
• Involuntary Termination Ratio

• Dissatisfied Termination Ratio
• Rehires ratio
• Minority TO rate

5
Workforce Profile Analysis - Analyze Human
Resources for Statutory Compliance

• Monitor employee job progression, compensation,
  hires, terminations, and promotions by gender,
  ethnicity, and EEO job categories
• Maintain compliance with employment policies
• Maintain internal compliance with internal policy
  on employee welfare and diversity

Sample Questions

• What is the gender and ethnicity of all
  employees?
• Are we in compliance with our employment policies
  and goals?
• What is the average service duration of our
  minority employees?
• Are we experiencing high turnover in certain
  minority areas?
• Is our recruiting diverse and balanced?

SAMPLE METRICS

• Disabled Headcount
• Length of Service

• Minority Headcount
• Average Tenure of Minority Female Employees

6
Workforce Profile Analysis - Manage Employee
Action Management

• Understand Disciplinary Actions taken against
  employees as a result of wrong doing.
• Manage all employee grievances and steps taken to
  satisfy the grievances against the organization.
• Investigate Injury and Illness issues of workforce

Sample Questions

• How many employees have filed grievances?
• What is the average length of service of the
  employees who filed grievances?
• How many employees have been put through a
  disciplinary action?
• Which agency/dept. have the highest number of
  health and safety incidents?
• What is the employee lost time factor (sum lost
  time/headcount) for each of those same locations?

SAMPLE METRICS

• Total Employee Grievances
• Total Disciplinary Actions
• Age of Employee
• Service Duration

• Days Away from Work
• Restricted Workdays
• Hours Unconscious
• Minutes Unconscious

7
HCM Data Warehouse
Demonstration