Use it or lose it!
I'm referring here to the data you collect. If you are collecting data that you're not actually using (and I bet you are!), stop collecting it, and clean it out of your database.
Almost every client I've worked with has identified data in the database that is no longer being used. Often it was collected for one-time use (e.g., a point-in-time survey) or was being used and managed by a staff person who has long since left the organization. But the data remains in the database because no one has bothered to clean it out.
You should set aside time periodically (e.g., once every six months) to review your data and get rid of data no longer in use. I call this kind of data "noise" in the database. And the more noise you have, the less faith your users will have in the data (e.g., "Look at all this garbage in here; this data was collected years ago and is no longer being used, but it's still IN here!").
When it comes to your data, use it or lose it.
![]()
Wes's Wednesday Wisdom Archives
Be grateful
Be grateful As Thanksgiving approaches here in the US, I’m reminded of two words: Be […]
Do you really need to approve them?
Do you really need to approve them? I often joke that the very best (because […]
Negativity bias is why we need database PR
Negativity bias is why we need database PR I’ve written before how cognitive biases can affect […]
A system change requires a culture change
A system change requires a culture change By its very nature, when you introduce a […]
Where is that data?
Where is that data? This is what data management nirvana looks like: When the question starts with […]
Be deliberate, but act quickly
Be deliberate, but act quickly Be deliberate, but act quickly. These are my words of […]
Why associations don’t like the “S” word
Why associations don’t like the “S” word A couple of weeks ago I asked my […]
The “S” stands for “Standard”
The “S” stands for “Standard” In a conversation with a past client, we were discussing […]
Is that meaningless data?
Is that meaningless data? I’m not a big quotes guy, but one of the few […]
Be aware of unintended consequences
Be aware of unintended consequences I’ve written before that every decision involves a trade-off. When […]
