All examples for Data Quality Checker

Employee Directory Referential Integrity Check

Validates an employee directory for referential integrity issues including circular manager references (employee manages themselves), orphaned manager IDs pointing to non-existent employees, and duplicate records. Critical for HR system migrations.

Input

What you provide to the skill

Quality check: emp_id,name,manager_id,dept
1,Alice,1,Sales
2,Bob,5,
3,Carol,1,Marketing
3,Carol,1,Marketing

Output

What the skill generates for you

DATA QUALITY HEALTH CHECK REPORT

============================================================



Records: 4

Columns: 4

Analysis Date: 2025-12-03



OVERALL QUALITY SCORE: 72/100 - GOOD



DIMENSION SCORES:

  Completeness:     88/100

  Validity:         100/100

  Consistency:      50/100

  Uniqueness:       0/100

  Accuracy:         100/100



TOP 5 CRITICAL ISSUES (by impact)

------------------------------------------------------------



1. CRITICAL - Circular manager references

   Impact: CRITICAL | Affected: 1 rows (25.0%)

   Details: Row(s) with emp_id=[1]: employees listed as their own managers

   Fix: Correct manager relationships - employees cannot manage themselves



2. CRITICAL - Orphaned manager references

   Impact: CRITICAL | Affected: 1 rows (25.0%)

   Details: Row(s) [1]: manager_id [5] not found in employee list

   Fix: Verify manager IDs exist in employee records



3. CRITICAL - Duplicate records found

   Impact: CRITICAL | Affected: 1 rows (25.0%)

   Details: Row(s) [2, 3]: completely identical records

   Fix: df.drop_duplicates(keep="first")



4. CRITICAL - Duplicate employee IDs

   Impact: CRITICAL | Affected: 1 rows (25.0%)

   Details: emp_id [3] appears multiple times

   Fix: df.drop_duplicates(subset=["emp_id"], keep="first")



5. HIGH - Missing values in dept

   Impact: HIGH | Affected: 1 rows (25.0%)

   Details: 1 missing values (25.0%)

   Fix: Collect missing data or use imputation strategy



ACTIONABLE RECOMMENDATIONS

------------------------------------------------------------



IMMEDIATE ACTIONS (Critical Priority):



1. Circular manager references

   Action: Correct manager relationships - employees cannot manage themselves



2. Orphaned manager references

   Action: Verify manager IDs exist in employee records



3. Duplicate records found

   Action: df.drop_duplicates(keep="first")



4. Duplicate employee IDs

   Action: df.drop_duplicates(subset=["emp_id"], keep="first")



ESTIMATED IMPROVEMENT IMPACT

------------------------------------------------------------



Current Score:     72/100

Projected Score:   100/100 (after fixes)



STATUS: CONDITIONAL PASS (fix critical issues first)
View all examples for Data Quality Checker

About This Skill

Automated data quality assessment across 5 dimensions with actionable fix recommendations

View Skill Details

More Examples

Customer Database Quality Check

Validates a customer database CSV with common issues: missing email addresses, duplicate customer IDs, invalid email formats, and impossible dates. Demonstrates completeness, validity, and uniqueness dimension scoring with specific row-level issue identification.

Sales Transaction Calculation Validation

Analyzes a sales orders dataset to detect calculation mismatches where total doesn't equal quantity times price. Demonstrates the consistency dimension by catching arithmetic errors and missing values in transactional data.

View all examples