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
Do we have access to that data?
Do we have access to that data? When I work with my clients on a […]
The three “buckets” of contact data
The three “buckets” of contact data Broadly speaking, when collecting data on contacts (individuals or organizations), […]
Balancing what is possible with what is realistic
Balancing what is possible with what is realistic When I work with clients on technology […]
“Humans want to be surrounded by beauty.”
“Humans want to be surrounded by beauty.” “Humans want to be surrounded by beauty.” – […]
Data managers vs data consumers
Data managers vs data consumers When I work with clients on any data management project, […]
Another universal truth
Another universal truth There are many universal truths in data management. Some examples: You will […]
Don’t miss this year’s DAN Science Fair!
Don’t miss this year’s DAN Science Fair! I’m taking a break from my weekly tips […]
Just start. And it’s never done.
Just start. And it’s never done. Last week I had the opportunity to lead a […]
Don’t ask if you’re not going to answer!
Don’t ask if you’re not going to answer! In the past week, on three different […]
Seek forgiveness rather than permission
Seek forgiveness rather than permission “Seek forgiveness, not permission.” I can’t remember when I first […]
