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
“It’s more than I have, but less than I want.”
“It’s more than I have, but less than I want.” “It’s more than I have, […]
Don’t forget Parkinson’s Law
Don’t forget Parkinson’s Law “Work expands so as to fill the time available for its […]
Just Respond
Just Respond Growing up my father used to tell my many siblings and me that […]
People fear uncertainty, not change
People fear uncertainty, not change If you’ve ever worked on any big project that was […]
“Working with you is like going to therapy.”
“Working with you is like going to therapy.” I was working with a client last […]
The best ideas are stolen
The best ideas are stolen I don’t remember where I first heard it, but someone said […]
It’s all about expectations
It’s all about expectations One of the most critical contributors to the success of a […]
Either you test, or your members will
Either you test, or your members will If I was forced to choose the single […]
But are you really willing to change?
But are you really willing to change? When any organization is making a change in data management […]
Two tips for data conversion
Two Tips for Data Conversion I’ve written a lot about data conversion over the years […]
