Data quality
Data quality is the degree to which business data is accurate, complete, consistent, timely and usable for the purpose it is meant for.
What it means
Poor data quality shows up as wrong invoices, missed deliveries, duplicate customers and reports that nobody trusts. It is improved by clear entry rules, a single master list, regular checks and fixing causes at the point of entry. Quality is judged against use: data good enough for a monthly review may not suit a daily dispatch plan.
Example
A trading firm finds 40 duplicate items in its stock master, each with a slightly different name. Purchases are made against one while sales are posted against another, so the stock shows negative on one and excess on the other.
Records and checks
- Record the quality rules for each key list, such as mandatory fields and allowed formats, and the results of each check.
- Verify by sampling entries against source documents and by looking for duplicates and blanks.
- The data owner corrects issues, and the management reviews quality results every quarter.
Common mistakes
- Cleaning data once in a big exercise but leaving the entry habits that caused the problem.
- Treating data quality as an IT matter when the errors come from daily entry.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →