Monday, 4 January 2016

Will 2016 be the Year you Clean up your Dirty Data? via @dqmartindoyle

Will 2016 be the Year you Clean up your Dirty Data? via @dqmartindoyle on +Datafloq - in this article Martin Doyle says it feels like forever, we've been warning about the dangers of low quality data. Our warnings have been reinforced and echoed by some of the world’s biggest think tanks. However, despite this, some organisations still haven't acted to improve the quality of their data.  Will 2016 be the year that organisations will clean their dirty data?

I have to say the only place to fix this is at source.  Limit the allowed values in data fields, Use drop down lists to limit values, use free format text sparingly.  Bad data pollutes any reporting or intelligence you look to gain from data and removing bad data from reporting stops it matching the system of record that it came from (which is almost as bad).

No comments:

Post a Comment

Note: only a member of this blog may post a comment.