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
Do the benefits outweigh the risks?
Do the benefits outweigh the risks? As the economist Thomas Sowell points out, there are …
Painting the Bridge
Painting the Bridge According to this article, the Golden Gate Bridge is painted continuously year-round. …
Maintenance isn’t sexy
Maintenance isn’t sexy I remember reading once long ago that one of the reasons our …
“Will I still have a job when this is done?”
“Will I still have a job when this is done? While working with a client …
Evolution, not revolution
Evolution, not revolution I don’t recall where I first heard it many decades ago, but …
The power of the users’ group
The power of the users’ group Recently in an online users group forum for an …
Who is your data evangelist?
Who is your data evangelist? I was recently talking with a client of mine about …
Who is your data evangelist?
Who is your data evangelist? I was recently talking with a client of mine about …
Ratio of Data to Errors
Ratio of Data to Errors One of the elements of a good data governance plan …
Back to basics
Back to basics Over the past couple of years I’ve noticed that some AMS vendors …