Inertia Contributes to Bad Data
Without knowing anything about your organization or its data, I'd be willing to bet you have data in your system that you are no longer actively managing/using (e.g., data that was collected long ago for some initiative at the time) or, worse yet, actively collecting data that you aren't actually using (e.g., demographic data collected during membership join process).
In both cases, one of the contributing factors to why this is happening is inertia. That is, once we've started collecting data, we continue to collect it, just because we always have. Or once we've collected data, we continue to keep it on a record, even though it's not being used (because it's easier to just leave it there than it is to clean it out).
I once worked with a client on a data management project. In the course of the project, we identified several data fields within the database that no one could really explain. Finally, one staff person pointed out that, in each case, a prior marketing director had asked to collect the data. Then that marketing director left, a new one came in, and asked for different data. And then a third marketing director did the same thing. The result? Five years later, lots of data that no one is actually using.
No organization is immune to this. It requires intentional action to clean up data that is no longer being used, and intentional action to identify business processes that are collecting data that never gets touched.
What actions are you taking to keep your data clean? Don't let inertia win.
![]()
Wes's Wednesday Wisdom Archives
Data doesn’t need to be perfect to be useful
Data doesn’t need to be perfect to be useful “Your data doesn’t have to be […]
Don’t just clean data, clean reports and queries
Don’t just clean data, clean reports and queries One of the reasons I exhort my […]
Don’t forget, your staff have day jobs…
Don’t forget, your staff have day jobs… The vast majority of my work is finite […]
Beware the automated “How did we do?” trap!
Beware the automated “How did we do?” trap! One of the downsides of technology is […]
Hindsight is 20/20
Hindsight is 20/20 I’m currently working with a client that is moving from their legacy […]
Cheaper now; costlier later.
Cheaper now; costlier later. Most of my clients are very cost-conscious, understandably. After all, who […]
The unified shopping cart: Dreams vs. reality
The unified shopping cart: Dreams vs. reality One of the more common requests I hear […]
Don’t forget to celebrate!
Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]
Three thoughts on duplicate records
Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]
Please don’t do this…
Please don’t do this… I’ve noticed a trend among online retailers that I want to […]
