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

Perfect is not possible

December 11, 2024

Perfect is not possible We’ve all heard the phrase “Perfect is the enemy of good” and […]

“Different” isn’t necessarily better or worse.

December 4, 2024

“Different” isn’t necessarily better or worse. One of the biggest challenges I face when working […]

The Rule of 100 and 1,000 and automation

November 20, 2024

The Rule of 100 and 1,000 and automation I originally coined the rule of 100 […]

Once you know, what will you do?

November 13, 2024

Once you know, what will you do? I’ve yet to meet a client who didn’t […]

If it’s not in your AMS, why not?

November 6, 2024

If it’s not in your AMS, why not? I like to tell my clients they’ll […]

Why checkboxes and tags are awesome and dangerous

October 30, 2024

Why checkboxes and tags are awesome and dangerous One of the most common functions in […]

Don’t miss obvious engagement data

October 23, 2024

Don’t miss obvious engagement data What I’ve experienced with my clients over the years is […]

All data requires active management

October 16, 2024

All data requires active management It’s a simple fact of data management that is often […]

Documentation is critical for consistency

October 9, 2024

Documentation is critical for consistency There are so many reasons why documenting your data management […]

Consumer demands change and technology changes

October 2, 2024

Consumer demands change and technology changes When I work with clients on the selection of […]

Leave a Comment

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

Scroll to Top