What is Data Validation?
Data Validation
Checking whether the numbers coming in are reliable.
What it means
Whether the numbers entered by a person or the numbers sent by the equipment may be incorrect. Data validation is making sure the numbers make sense before writing them down.
The most basic thing is to place them side by side with numbers counted in other ways. If the totals are different, break it down further and find out where it differs.
At the pen factory
On the 21st day, the person-counted defect was 14 pens and the equipment was 9 pens. When placed side by side by time zone, the facilities were 0 only at 13:00 and 14:00.
Why it matters
Judgments made with wrong numbers are wrong. After new equipment is installed, we look at both numbers together for a while.
Related terms
- NULLIndicates that there is no value. It is different from 0.
- Equipment IntegrationThis involves sending the quantity or status of equipment to the system without a person inputting it.
- ConsistencyThe total value of all records, the inventory on the screen, and the actual items in the warehouse match each other.