Employees

The data model includes measures such as Employee HeadCount (Actif), Employee Male HeadCount, Employee Female HeadCount, Employee Foreign HeadCount, Employee Disability, Termination HeadCount, Termination Disabled, Termination Foreign HeadCount, Termination Total, Termination Male, and Termination Female. Views like Employees, Employees By Racial Group, Race Group by Age Group, Active Employees Engaged Over Time, Terminated Employees, and Race Group by Hierarchy Level provide insights into employee demographics, engagement levels, termination statistics, and diversity analysis within the organization.

Benefits of This Data Model

• Improved Employee Demographic Analysis: The data model allows for in-depth analysis of employee demographics, including headcounts by gender, nationality, disability status, and other factors for better workforce planning and diversity initiatives.
• Enhanced Termination Insights: By utilizing measures such as Termination HeadCount, Termination Disabled, and Termination Foreign HeadCount, the data model provides valuable insights into employee turnover trends, reasons for termination, and demographics of departing employees.
• Efficient Performance Monitoring: The data model enables tracking of active employees' engagement levels over time, facilitating effective performance monitoring and proactive management of employee engagement initiatives.
• Comprehensive Workforce Planning: With dimensions like Job Title Type ID, Nature of Contract ID, and Probation Period End Date, the data model supports detailed analysis for strategic workforce planning, contract management, and probation tracking.
• Detailed Geographic and Language Analysis: The inclusion of dimensions such as Work City Town, Work Province, Employee Nationality, and Employee Language allows for granular analysis of employees based on geographic location and language preferences, aiding in targeted communication and regional workforce optimization.

Key Performance Indicators (KPIs)

• Employee Total (Actif / Inactif): Total count of employees categorized as Active or Inactive.
• Employee HeadCount (Actif): Total count of employees who are categorized as Active.
• Employee Male HeadCount: Total count of male employees in the organization.
• Employee Female HeadCount: Total count of female employees in the organization.
• PCT of Parent: Percentage representation of employees relative to parent organization.
• Employee Foreign HeadCount: Total count of employees who are foreign nationals.
• Employee Disability: Total count of employees with disabilities.
• Physical Country Code: Code representing the physical location country of the employee.
• Termination HeadCount: Total count of terminated employees.
• Termination Disabled: Count of terminated employees with disabilities.
• Termination Foreign HeadCount: Count of terminated foreign national employees.
• Termination Total: Total count of terminated employees.
• Termination Male: Count of terminated male employees.
• Termination Female: Count of terminated female employees.
• Name: Name of the employee.
• Active: Status indicating whether the employee is active or inactive.

Available Visualisations

View Name	Description
Employees	Provides a comprehensive overview of all current and past employees in the organization.
Employees By Racial Group	Breaks down employee data based on racial demographics for diversity and inclusion analysis.
Race Group by Age Group	Analyzes the distribution of age groups within different racial categories for workforce planning.
Active Employees Engaged Over Time	Tracks the engagement levels of active employees over various time periods for performance monitoring.
Terminated Employees	Offers insights into reasons for employee turnover and exit trends within the organization.
Race Group by Hierarchy Level	Examines the representation of different racial groups across various levels of the organizational hierarchy.