Something went wrong!
Hang in there while we get back on track
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.
Input
What you provide to the skill
Check customer master file /tmp/test2_customers.csv for CRM migration readiness
Output
What the skill generates for you
Summary
Congratulations! Your customer master file /tmp/test2_customers.csv has achieved a perfect 100/100 quality score and is APPROVED for CRM migration.
Key Findings:
✅ All Critical Checks Passed:
- Zero duplicate customer IDs
- 100% valid email formats
- All lifetime values are positive (range: $456.25 - $3,450.00)
- Perfect data completeness (no missing values)
- No duplicate records
- No statistical outliers
📊 Data Profile:
- 5 customers with 6 attributes each
- Average lifetime value: $1,677.50
- All required fields populated
Migration Readiness: APPROVED ✅
Your data is production-ready. You can proceed with your CRM migration with confidence. The file demonstrates excellent data hygiene with no critical, high, medium, or low priority issues detected.
Optional Next Steps:
- Document these data quality standards for ongoing data entry
- Set up validation rules in your new CRM to maintain this quality level
- Consider adding additional customer attributes (address, city, state, country) for more robust segmentation capabilities
Would you like me to:
- Export this report to a file?
- Add additional validation checks for specific business rules?
- Validate another dataset?
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 DetailsMore Examples
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.
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.