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
Opting out and communication preferences
Opting out and communication preferences Last week’s newsletter discussed the need for associations to collect mobile […]
Are you collecting mobile phone numbers? You should be.
Are you collecting mobile phone numbers? You should be. Are you collecting (and using) the […]
Spend less time on data management and more on higher value activities
Spend less time on data management and more on higher value activities Data management is very […]
Change anything you want, except your name!
Change anything you want, except your name! This is an oldy but a goody, but […]
If you don’t trust your vendor…
If you don’t trust your vendor… When I start an AMS selection project with a […]
Your RFP should go to no more than five vendors!
Your RFP should go to no more than five vendors! As a rule, when I […]
Be concise!
Be concise! I started a monthly newsletter almost 25 years ago (which I recently discontinued). […]
A great example of a data integrity report!
A great example of a data integrity report! A couple months back I discussed the […]
“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.”
“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.” I saw […]
Rather than adding something new, try subtracting
Rather than adding something new, try subtracting I read recently that sociological research suggests, when presented […]