Why “weeding the garden” is so important

Why "weeding the garden" is so important

One of the most important activities for maintaining quality data in your database is what I call "weeding the garden." Simply put, weeding the garden means proactively managing your data, consistently, over time, rather than trying to clean up the data in one big effort once every couple of years.

This point was driven home recently in a post on ASAE's Collaborate online community. The poster wrote, in part: "Using our data has been difficult with so many different "hands in the pot" over the years. We have so many redundant fields that all gathered data at different times and in different places. I am currently trying to find all the data, de-dupe it, and combine it all into one new field."

I see this all too frequently with my clients. A system that has been in place for many years, with many users over time, but no one consistently weeding the garden. And so eventually you wind up with "many redundant fields that all gathered data at different times and in different places." It's a database overgrown with weeds.

The alternative is to proactively manage the data, identifying redundant or no-longer-used data, and cleaning it up, early and often.

The choice is yours.

Wes's Wednesday Wisdom Archives

Rather than adding something new, try subtracting

May 29, 2024

Rather than adding something new, try subtracting I read recently that sociological research suggests, when presented […]

It’s always people, process, and technology

May 22, 2024

It’s always people, process, and technology I speak and write a lot about people, process, […]

Once it’s lost, trust can be difficult to regain

May 15, 2024

Once it’s lost, trust can be difficult to regain I recall hearing once long ago […]

Share your successes!

May 8, 2024

Share your successes! I was speaking at an association meeting recently and one of the points […]

What are YOUR data integrity reports?

May 1, 2024

What are YOUR data integrity reports? Sitting in an AMS demo with a client recently, […]

You might have to do SOME of the work yourself!

April 24, 2024

You might have to do SOME of the work yourself! Many, many years ago I […]

Don’t manage to the exception!

April 17, 2024

Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]

It’s always about improvement

April 10, 2024

It’s always about improvement Talking with a client recently, she expressed frustration about one particular project […]

Don’t be a hoarder!

April 3, 2024

Don’t be a hoarder! The simple truth is that it’s almost “free” to collect data. […]

With data analytics (as with most things), keep it simple!

March 27, 2024

With data analytics (as with most things), keep it simple! Over the past several years […]

Scroll to Top