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

“It’s more than I have, but less than I want.”

November 17, 2021

“It’s more than I have, but less than I want.” “It’s more than I have, […]

Don’t forget Parkinson’s Law

November 10, 2021

Don’t forget Parkinson’s Law “Work expands so as to fill the time available for its […]

Just Respond

November 3, 2021

Just Respond Growing up my father used to tell my many siblings and me that […]

People fear uncertainty, not change

October 27, 2021

People fear uncertainty, not change If you’ve ever worked on any big project that was […]

“Working with you is like going to therapy.”

October 20, 2021

“Working with you is like going to therapy.” I was working with a client last […]

The best ideas are stolen

October 13, 2021

The best ideas are stolen I don’t remember where I first heard it, but someone said […]

It’s all about expectations

October 7, 2021

It’s all about expectations One of the most critical contributors to the success of a […]

Either you test, or your members will

September 29, 2021

Either you test, or your members will If I was forced to choose the single […]

But are you really willing to change?

September 22, 2021

But are you really willing to change? When any organization is making a change in data management […]

Two tips for data conversion

September 15, 2021

Two Tips for Data Conversion I’ve written a lot about data conversion over the years […]

Leave a Comment

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

Scroll to Top