Does anyone customize Insight to capture bad data in the system?
In other words, an exception report. Suffering from much bad data and am tired of trying to capture the bad data with a brute force dump to excel. Would like to take the "Easy Button" approach by using some Insight features to test for bad data.
- Employees having an email address with the incorrect domain name
- Critical fields which are blank
- Improper use of punctuation during data entry
My hope is to use this to get a baseline and then utlize going forward to measure process improvements in data quality.
- Has anyone tried this before or have a better method?