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

Use it or lose it!

December 8, 2021

Use it or lose it! I’m referring here to the data you collect. If you […]

“If I could only do one thing…”

December 1, 2021

“If I could only do one thing…” Managing data throughout your organization can be overwhelming. Do […]

Gratitude

November 24, 2021

Gratitude As Thanksgiving in the US approaches, I’m reminded of the importance of gratitude, in […]

“It’s more than I have, but less than I want.”

November 17, 2021

“It’s more than I have, but less than I want.” “It’s more than I have, […]

Don’t forget Parkinson’s Law

November 10, 2021

Don’t forget Parkinson’s Law “Work expands so as to fill the time available for its […]

Just Respond

November 3, 2021

Just Respond Growing up my father used to tell my many siblings and me that […]

People fear uncertainty, not change

October 27, 2021

People fear uncertainty, not change If you’ve ever worked on any big project that was […]

“Working with you is like going to therapy.”

October 20, 2021

“Working with you is like going to therapy.” I was working with a client last […]

The best ideas are stolen

October 13, 2021

The best ideas are stolen I don’t remember where I first heard it, but someone said […]

It’s all about expectations

October 7, 2021

It’s all about expectations One of the most critical contributors to the success of a […]

Leave a Comment

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

Scroll to Top