jump to navigation

How do you prevent data errors in your database today? August 16, 2007

Posted by Peter Benza in Data Errors, Data Hygiene, Data Processes, Data Sources, Data Templates, Data Verification.

Data errors can be reduced but not totally eliminated, so be realistic.  First consideration must be given at point of entry and depending of the size of your organization this could be many.  Once your data is consumed, a number of other places should be considered to monitor data errors, such as: data convertion, data preparation, data migration, data integration, data reporting, data analysis, and finally when it is consumed and displayed for use in a dashboard.

Collectively, once you document where most of these errors are orginating from – then and only then will you be able to classify data errors given the entire end to end process from point of entry to using the data in its original or transformed state in a report, analysis, or dashboard.

Now, that you have compiled all these data errors (specific to your organization) you can begin to feed some/most of these findings back into your data quality, data governance, and data management frameworks.


No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: