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

How do you know if you’re making progress?

April 8, 2020

How do you know if you’re making progress? We all want to improve our data management, […]

Don’t move too quickly OR too slowly

April 1, 2020

Don’t move too quickly OR too slowly This may sound like a big “duh!” but I’ll […]

“Your current habits are perfectly designed to deliver your current results.”

March 25, 2020

“Your current habits are perfectly designed to deliver your current results.” “Your current habits are […]

There is value in just going through the exercise

March 18, 2020

There is value in just going through the exercise I was working with a client […]

Daylight savings and business rules

March 11, 2020

Daylight savings and business rules This past Sunday, most of the US observed Daylight Savings […]

It’s always about priorities

March 4, 2020

It’s always about priorities No matter the size or type of technology project, you will […]

Only one can be best

February 26, 2020

Only one can be best One of my (many) pet peeves with software vendor marketing […]

Seek to simplify

February 19, 2020

Seek to simplify When I work with my clients on system selection or implementation, one […]

Some problems are not problems

February 12, 2020

Some problems are not problems “A problem with no solution is not a problem, it’s […]

UI Matters!

January 29, 2020

UI Matters! Almost since I began consulting over 20 years, I’ve noted how important the […]

Leave a Comment

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

Scroll to Top