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

Once it’s lost, trust can be difficult to regain

May 15, 2024

Once it’s lost, trust can be difficult to regain I recall hearing once long ago […]

Share your successes!

May 8, 2024

Share your successes! I was speaking at an association meeting recently and one of the points […]

What are YOUR data integrity reports?

May 1, 2024

What are YOUR data integrity reports? Sitting in an AMS demo with a client recently, […]

You might have to do SOME of the work yourself!

April 24, 2024

You might have to do SOME of the work yourself! Many, many years ago I […]

Don’t manage to the exception!

April 17, 2024

Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]

It’s always about improvement

April 10, 2024

It’s always about improvement Talking with a client recently, she expressed frustration about one particular project […]

Don’t be a hoarder!

April 3, 2024

Don’t be a hoarder! The simple truth is that it’s almost “free” to collect data. […]

With data analytics (as with most things), keep it simple!

March 27, 2024

With data analytics (as with most things), keep it simple! Over the past several years […]

Don’t forget about periodic maintenance

March 20, 2024

Don’t forget about periodic maintenance Just as most automobiles need periodic maintenance, keeping your data as […]

Users Groups are ALWAYS Valuable

March 13, 2024

Users Groups are ALWAYS Valuable I am a huge fan of users groups. (Here’s a […]

Scroll to Top