Use it or lose it!

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

November 27, 2019

Be grateful As Thanksgiving approaches here in the US, I’m reminded of two words: Be […]

Do you really need to approve them?

November 20, 2019

Do you really need to approve them? I often joke that the very best (because […]

Negativity bias is why we need database PR

November 13, 2019

Negativity bias is why we need database PR I’ve written before how cognitive biases can affect […]

A system change requires a culture change

November 6, 2019

A system change requires a culture change By its very nature, when you introduce a […]

Where is that data?

October 30, 2019

Where is that data? This is what data management nirvana looks like: When the question starts with […]

Be deliberate, but act quickly

October 23, 2019

Be deliberate, but act quickly Be deliberate, but act quickly. These are my words of […]

Why associations don’t like the “S” word

October 16, 2019

Why associations don’t like the “S” word A couple of weeks ago I asked my […]

The “S” stands for “Standard”

October 9, 2019

The “S” stands for “Standard” In a conversation with a past client, we were discussing […]

Is that meaningless data?

September 25, 2019

Is that meaningless data? I’m not a big quotes guy, but one of the few […]

Be aware of unintended consequences

September 18, 2019

Be aware of unintended consequences I’ve written before that every decision involves a trade-off. When […]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top