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

Next-to-Nothing Goals

January 27, 2021

Next-to-Nothing Goals I saw a Ted Talk by Christine Carter recently discussing the concept of […]

Just because you can…

January 20, 2021

Just because you can… In response to a recent Wednesday Wisdom on averages hiding the […]

Always ask “Why?”

January 13, 2021

Always ask “Why?” Little kids ask “Why?” all the time, because they are sponges for […]

Averages hide the extremes

January 6, 2021

Averages hide the extremes I can’t remember where I first heard it, but “averages hide […]

Look up PARTIAL names!

December 24, 2020

Look up PARTIAL names! Train your staff to do look ups on partial names, not full […]

Not Just Technology

December 16, 2020

Not Just Technology There was recently a discussion on the ASAE online community about project management […]

Consider quitting

December 4, 2020

Consider quitting Patient: “Doctor, it hurts when I do this.” Doctor: “Then stop doing that.” […]

There is nothing so permanent as business rules

November 25, 2020

There is nothing so permanent as business rules Nobel Prize-winning economist Milton Friedman said, “There’s nothing […]

Budget for feature discovery and adoption

November 18, 2020

Budget for feature discovery and adoption When developing a budget for implementation of a new […]

Customize staff pages for better user adoption

November 11, 2020

Customize staff pages for better user adoption The single most important element to data management […]

Leave a Comment

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

Scroll to Top