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

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 […]

Don’t forget about periodic maintenance

March 20, 2024

Don’t forget about periodic maintenance Just as most automobiles need periodic maintenance, keeping your data as […]

Users Groups are ALWAYS Valuable

March 13, 2024

Users Groups are ALWAYS Valuable I am a huge fan of users groups. (Here’s a […]

But will you DO anything with that data?

February 28, 2024

But will you DO anything with that data? I frequently exhort my clients to always answer […]

It’s not what happens, but how you react…

February 21, 2024

It’s not what happens, but how you react… “It’s not what happens to you, but […]

Saying it and doing it are two different things

February 14, 2024

Saying it and doing it are two different things When I work with my clients […]

Benefits downstream are difficult to implement

February 7, 2024

Benefits downstream are difficult to implement In my 25 years of consulting, one of the […]

Scroll to Top