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

Do the benefits outweigh the risks?

May 31, 2023

Do the benefits outweigh the risks? As the economist Thomas Sowell points out, there are …

Do the benefits outweigh the risks? Read More »

Painting the Bridge

May 24, 2023

Painting the Bridge According to this article, the Golden Gate Bridge is painted continuously year-round. …

Painting the Bridge Read More »

Maintenance isn’t sexy

May 17, 2023

Maintenance isn’t sexy I remember reading once long ago that one of the reasons our …

Maintenance isn’t sexy Read More »

“Will I still have a job when this is done?”

May 10, 2023

“Will I still have a job when this is done? While working with a client …

“Will I still have a job when this is done?” Read More »

Evolution, not revolution

May 3, 2023

Evolution, not revolution I don’t recall where I first heard it many decades ago, but …

Evolution, not revolution Read More »

The power of the users’ group

April 26, 2023

The power of the users’ group Recently in an online users group forum for an …

The power of the users’ group Read More »

Who is your data evangelist?

April 19, 2023

Who is your data evangelist? I was recently talking with a client of mine about …

Who is your data evangelist? Read More »

Who is your data evangelist?

April 19, 2023

Who is your data evangelist? I was recently talking with a client of mine about …

Who is your data evangelist? Read More »

Ratio of Data to Errors

April 12, 2023

Ratio of Data to Errors One of the elements of a good data governance plan …

Ratio of Data to Errors Read More »

Back to basics

April 5, 2023

Back to basics Over the past couple of years I’ve noticed that some AMS vendors …

Back to basics Read More »

Scroll to Top