MOCKUP — U - Data Quality · Phase 1 — future · admin · ops · Follow REPORT-DESIGN-SPEC.md in Power BI Desktop to build this
Cq Claritiq · U - Data Quality Refreshed today
Critical Caution Healthy · target
Scope: eni.enigron.com · c1.eni.enigron.com
Users Missing Department
89
8% of enabled
Unique Departments
143
inc. 47 variations
Users Missing Manager
247
21% of enabled
Users Missing EmpID
78
AAD Connect at risk
Users Missing Email
34
Mail routing broken
Overall Completeness
74%
weighted across 8 attrs
Attribute completeness scorecard
AttributeFilledBlankFill rate
UPN11620
100%
Email112834
97%
EmpID108478
93%
Department107389
92%
Office1012150
87%
Division987175
85%
Company944218
81%
Manager915247
79%
EmpType823339
71%
Department variations — cleanup candidates
CanonicalVariantsUsers
Sales"Sales", "sales", "SALES", "Sales Team"
312
Engineering"Engineering", "Eng", "engineering", "R&D"
247
Operations"Operations", "Ops", "OPERATIONS"
189
Finance"Finance", "Finance & Admin", "FIN"
142
Human Resources"HR", "Human Resources", "People Ops"
88
Marketing"Marketing", "Mktg", "Growth"
65
IT"IT", "I.T.", "Information Technology"
54
47 variation clusters detected across 143 raw values. Each cluster is a cleanup task. Export this table to hand to HR-IT for remediation.
Quick views
Users with incomplete attributes Showing 8 of 356 · Sorted by Missing count ↓
Display NameUPNSAMEmpIDDepartmentDivisionCompanyManagerEmpTypeMissing
Marcus Holtmarcus.holt@contoso.commholtEmpIDDeptDivCoMgrType
Rina Satorina.sato@contoso.comrsatoE04402salesContractorDivCoMgr
svc-legacy-syncsvc-legacy-sync@contoso.comsvc-legacy-syncAll HR attrs
Tomás Riveratomas.rivera@contoso.comtriveraE04691EngProductFTECoMgr
Priya Patelpriya.patel@contoso.comppatelE04712OperationsContoso LtdDivMgrType
Alex Morganalex.morgan@contoso.comamorganE04780salesNorth AmericaContoso Ltdvp.sales@contoso.comFTEDept capitalization
Ola Bergola.berg@contoso.comobergE04514R&DProductFTEDept cluster mismatchCoMgr
Hana Dvořákhana.dvorak@contoso.comhdvorakE04489Finance & AdminEMEAContoso GmbHFTEDept cluster mismatchMgr