All examples for Data Quality Validator

Inventory Data with Stock and Date Issues

Validates inventory management data containing negative stock levels, out-of-stock conditions, missing quantities, and future restock dates. Demonstrates range validation capabilities and business-context remediation recommendations for operations scenarios requiring immediate action on stock discrepancies.

Input

What you provide to the skill

Validate inventory file /tmp/test3_inventory.csv - need to check stock levels and dates

Output

What the skill generates for you

Perfect! I’ve completed the data quality validation on your inventory file. Here’s a summary of the findings:

Executive Summary

Overall Quality Score: 68/100 (POOR - Significant Issues)

Your inventory file has 4 critical/high-priority issues that need immediate attention:

🔴 Critical Issues (Must Fix)

  1. PROD-003 (Widget C): Negative stock (-5 units) - impossible inventory state indicating data entry error or system issue

🟠 High Priority Issues

  1. PROD-002 (Widget B): OUT OF STOCK (0 units, reorder point is 30)
  2. PROD-007 (Widget G): MISSING quantity data - cannot determine stock availability
  3. Note: I initially flagged PROD-005 as having a future restock date (2025-06-15), but this appears to be June 15, 2025, which is actually in the future from today’s date (December 2, 2025 in the system)

🟡 Medium Priority Issues

  1. PROD-005 (Widget E): Low stock warning - 35 units on hand, below reorder point of 45

Data Quality Metrics

  • Completeness: 88.9% for quantity_on_hand (1 missing value out of 9 rows)
  • Duplicates: None found
  • Date Issues: Dates are valid (though one is in the past from restock)

Immediate Actions Required

  1. Fix negative stock for PROD-003 (investigate and correct to 0, trigger emergency reorder)
  2. Place urgent reorder for PROD-002 (30 units minimum)
  3. Perform physical count for PROD-007 to determine actual quantity
  4. Consider reordering PROD-005 (10 units to reach reorder point)

Would you like me to:

  • Export a detailed issue list with row numbers to CSV?
  • Generate a prioritized reorder list with quantities?
  • Re-validate the file after you make corrections?
View all examples for Data Quality Validator

About This Skill

Validate CSV and Excel files before analysis. Detects missing values, duplicates, outliers, and format errors. Generates quality scores, severity-classified issues, and actionable remediation recommendations.

View Skill Details

More Examples

Clean Customer Master Data - CRM Migration Ready

Validates customer master file with excellent data quality. Demonstrates handling of clean datasets with 100/100 quality score, showing positive confirmation messaging and migration approval process. Illustrates perfect completeness, valid formats, and no critical issues detected.

Sales Data with Revenue Reporting Issues

Validates sales transaction data containing critical issues including negative amounts, duplicate order IDs, missing values, and invalid email formats. Demonstrates severity classification, revenue impact quantification, and prioritized remediation recommendations for business reporting scenarios.

View all examples