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!
Some history IS important! When I’m advising clients on data conversion (moving data from one […]
“Many mickles make a muckle.”
“Many mickles make a muckle.” “Many mickles make a muckle.” – George Washington Apparently, this […]
It’s easy to collect; it’s harder to manage
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
Tell them why you want the data Because data is so easy to collect these […]
Don’t get hung up on something minor
Don’t get hung up on something minor I’m a problem solver. I love to solve […]
Be flexible, especially for unusual requests
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.”
“Her eyes were bigger than her stomach.” When I was a child, my siblings used […]
Once you buy crap…
Once you buy crap… “When you buy something cheap and bad, the best you’re going […]
It could always be worse
It could always be worse Because most of us don’t have the benefit (like I […]
It’s all about managing expectations
It’s all about managing expectations I placed an order online on a Friday and the […]
