Employee Data Preparation

Clean records · Merge departments · Calculate tenure

+6.8%

Avg Employee Tenure

4.7 yrs

↑ 0.3 yrs vs last quarter

Average time employees stay before attrition or exit. Healthy benchmark is 5+ years.

-2.1%

Missing Values %

8.4%

312 fields across 1,847 records

Fields with null or inconsistent values affecting model accuracy. Target: below 3%.

Stable

Gender Ratio (F:M)

42:58

776 Female · 1,071 Male

Current workforce gender split. DEI target is 45:55 by Q4 2026.

Data Quality Audit

10 fields · 1,847 employee records

FieldTotalMissingCompletenessStatusRecommended Action
Employee ID1,8470
100%
CleanNo action needed
Department1,8474
100%
CleanAuto-fill from manager
Date of Birth1,84718
99%
Needs ReviewRequest from HRMS
Monthly Income1,84737
98%
Needs ReviewPull from payroll
Tenure (Years)1,8470
100%
CleanNo action needed
Performance Rating1,84789
95%
CriticalTrigger review cycle
Job Satisfaction1,847112
94%
CriticalRe-send survey
Last Promotion Date1,84752
97%
Needs ReviewCheck HR records
Manager ID1,8479
100%
CleanAuto-assign from org chart
Exit Reason312198
37%
CriticalConduct exit interviews

Department Mapping

12 source · 2 pending merge

2 unresolved
SourceMapped ToCountStatus
EngineeringR&D342Merged
Research & DevR&D89Merged
SalesSales & BD218Merged
Business DevSales & BD54Merged
Human ResourcesHR67Clean
FinanceFinance112Clean
MarketingMarketing143Clean

Employee Records

12 of 12 records

Emp IDFull NameDepartmentTenureAgeMonthly IncomeStatusData CompleteManagerLast Review
EMP-0299David OseiMIT & Systems5.8 yrs37$7,800Active
88%
Lena Müller2026-01-30
EMP-0432Sven LarssonMOperations11.4 yrs48$13,100Active
100%
Ben Osei2026-02-05
EMP-0561Rajesh GuptaMFinance9.3 yrs43$11,200Active
100%
Shreya Mehta2026-02-18
EMP-0744James CaldwellMSales & BD0.9 yrs24$3,900At Risk
44%
Diana ChenOverdue
EMP-0873Marcus WebbMSales & BD2.1 yrs28$5,200At Risk
71%
Diana Chen2025-11-22
EMP-0987Emmanuel DialloMFinance4.1 yrs35$7,200Active
91%
Shreya Mehta2026-03-05
EMP-1042Priya NairFR&D6.2 yrs34$8,400Active
100%
Arjun Kapoor2026-03-14
EMP-1103Fatima Al-RashidFR&D7.1 yrs39$9,700Active
97%
Arjun Kapoor2026-04-15

Showing 18 of 12 records