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

A Data Integrity Report…for Reports!

July 29, 2019

I’ve written elsewhere about the value of data integrity reports. But one of the most […]

Simple rules for complex systems

July 28, 2019

Simple rules for complex systems I first heard the phrase “simple rules for complex systems” […]

Accentuate the positive

July 24, 2019

Accentuate the positive I’ve written before about the importance of database public relationsand celebrating success. I’ll add […]

Annual dues vs. anniversary dues

July 10, 2019

Annual dues vs. anniversary dues I served as director of membership for several years at […]

A change of systems requires a change of mindset

July 8, 2019

Every AMS vendor will tell you that the toughest part of implementing a new system […]

It doesn’t have to be optimal to be beneficial

June 26, 2019

It doesn’t have to be optimal to be beneficial I’m a big fan of the […]

Look for small wins

June 19, 2019

Look for small wins One of the toughest things about system implementation is simply how […]

Are you closing the loop?

June 12, 2019

Are you closing the loop? If your association does a call for presentations for any […]

Declare victory and move on

June 5, 2019

Declare victory and move on The law of diminishing returns is the point at which the […]

Clean as you go

March 28, 2019

Clean As You Go A good cook or baker knows that, when working in the […]

Leave a Comment

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

Scroll to Top