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

Eventually automated emails get ignored

April 14, 2021

Eventually automated emails get ignored During the discovery and development phase of implementing a new […]

The challenge the AMS providers see

April 7, 2021

The challenge the AMS providers see Over the years I’ve asked AMS providers what they […]

Be careful about “solutioning” too quickly

March 31, 2021

Be careful about “solutioning” too quickly One of the great things about software developers is […]

What’s our next action?

March 24, 2021

What’s our next action? As you can imagine, I spend a lot of time in […]

Don’t automate for the sake of automation

March 17, 2021

Don’t automate for the sake of automation I’m the laziest person in the world. I […]

Don’t forget about what got better

March 10, 2021

Don’t forget about what got better Negativity bias is the tendency to focus on only […]

Give a little at a time rather than taking away

March 3, 2021

Give a little at a time rather than taking away I’m sure there’s research somewhere […]

First, you gotta have the data

February 17, 2021

First, you gotta have the data When I work with clients on a new AMS […]

Work on your relationship with your AMS vendor

February 10, 2021

Work on your relationship with your AMS vendor It is no coincidence that my most […]

Dashboards for Data Integrity

February 3, 2021

Dashboards for Data Integrity I’ve written a bunch on data integrity reports. (Click here for […]

Leave a Comment

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

Scroll to Top