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
You need a PLAN to deal with duplicates
You need a PLAN to deal with duplicates Here’s the thing about duplicate records: No […]
Asking for more is a good sign…
Asking for more is a good sign… A client who had recently implemented a new […]
Take action…
Take action… “The greatest wisdom not applied to action and behavior is meaningless data.” – […]
The Rule of 100 and 1,000 revisited
The Rule of 100 and 1,000 revisited I’m finding that the “Rule of 100 and […]
You gotta wanna
You gotta wanna Long ago I heard a training consultant say you can’t train people […]
Be careful not to overbuy
Be careful not to overbuy I recently spoke with an association of ten staff that was […]
When is the best time to clean your data?
When is the best time to clean your data? One of the most common questions […]
Do the benefits outweigh the risks?
Do the benefits outweigh the risks? As the economist Thomas Sowell points out, there are […]
Painting the Bridge
Painting the Bridge According to this article, the Golden Gate Bridge is painted continuously year-round. […]
Maintenance isn’t sexy
Maintenance isn’t sexy I remember reading once long ago that one of the reasons our […]
