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

How do you know if you’re making progress?

April 8, 2020

How do you know if you’re making progress? We all want to improve our data management, […]

Don’t move too quickly OR too slowly

April 1, 2020

Don’t move too quickly OR too slowly This may sound like a big “duh!” but I’ll […]

“Your current habits are perfectly designed to deliver your current results.”

March 25, 2020

“Your current habits are perfectly designed to deliver your current results.” “Your current habits are […]

There is value in just going through the exercise

March 18, 2020

There is value in just going through the exercise I was working with a client […]

Daylight savings and business rules

March 11, 2020

Daylight savings and business rules This past Sunday, most of the US observed Daylight Savings […]

It’s always about priorities

March 4, 2020

It’s always about priorities No matter the size or type of technology project, you will […]

Only one can be best

February 26, 2020

Only one can be best One of my (many) pet peeves with software vendor marketing […]

Seek to simplify

February 19, 2020

Seek to simplify When I work with my clients on system selection or implementation, one […]

Some problems are not problems

February 12, 2020

Some problems are not problems “A problem with no solution is not a problem, it’s […]

UI Matters!

January 29, 2020

UI Matters! Almost since I began consulting over 20 years, I’ve noted how important the […]

Leave a Comment

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

Scroll to Top