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

Action isn’t the same as progress

January 25, 2023

Action isn’t the same as progress I’ve written before that not taking action is an …

Action isn’t the same as progress Read More »

Start with the end in mind

January 18, 2023

Start with the end in mind Like so many, I probably first heard the phrase …

Start with the end in mind Read More »

It’s quiet in here…maybe TOO quiet…

January 11, 2023

It’s quiet in here…maybe TOO quiet… One of the truisms of data management is that …

It’s quiet in here…maybe TOO quiet… Read More »

It’s ALWAYS about expectations

January 4, 2023

It’s ALWAYS about expectations The headline reads: “Tesla sets record for vehicle deliveries, an increase …

It’s ALWAYS about expectations Read More »

It’s hard to get UNangry

December 14, 2022

It’s hard to get UNangry I often emphasize to my clients the importance of testing …

It’s hard to get UNangry Read More »

Some history IS important!

December 7, 2022

Some history IS important! When I’m advising clients on data conversion (moving data from one …

Some history IS important! Read More »

“Many mickles make a muckle.”

November 30, 2022

“Many mickles make a muckle.” “Many mickles make a muckle.” – George Washington Apparently, this …

“Many mickles make a muckle.” Read More »

It’s easy to collect; it’s harder to manage

November 16, 2022

It’s easy to collect; it’s harder to manage The beauty of today’s highly configurable AMS …

It’s easy to collect; it’s harder to manage Read More »

Tell them why you want the data

November 9, 2022

Tell them why you want the data Because data is so easy to collect these …

Tell them why you want the data Read More »

Don’t get hung up on something minor

November 2, 2022

Don’t get hung up on something minor I’m a problem solver. I love to solve …

Don’t get hung up on something minor Read More »

Scroll to Top