When is the best time to clean your data?

When is the best time to clean your data?

One of the most common questions I get from my clients who want to clean up their data is "This is all so overwhelming. Where do we start?"

My response is typically: "Start somewhere, and start today."

I've heard a variation of this phrase applied to many different worlds (e.g., exercise, planting a tree), and I'll use it here. "The best time to start cleaning your data was 20 years ago; the second best time is to start today."

The thing about data is it's never completely "clean." You will always have some bad data. But the only way to make sure you don't have a lot of really bad data is to clean it as frequently and effectively as you can.

So where to start? Maybe start with your board list. Or some subset of your members (e.g., everyone with a last name starting with A). Or everyone who attended your last meeting.

Pick a set of data, clean it up, and them move to the next set of data. But whatever you do, start today.

Wes's Wednesday Wisdom Archives

Some history IS important!

December 7, 2022

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

“Many mickles make a muckle.”

November 30, 2022

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

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

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

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

Be flexible, especially for unusual requests

October 26, 2022

Be flexible, especially for unusual requests One of the great benefits of off-the-shelf association management software (AMS) […]

“Her eyes were bigger than her stomach.”

October 19, 2022

“Her eyes were bigger than her stomach.” When I was a child, my siblings used […]

Once you buy crap…

October 12, 2022

Once you buy crap… “When you buy something cheap and bad, the best you’re going […]

It could always be worse

October 5, 2022

It could always be worse Because most of us don’t have the benefit (like I […]

It’s all about managing expectations

September 28, 2022

It’s all about managing expectations I placed an order online on a Friday and the […]

Leave a Comment

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

Scroll to Top