Data integrity reports
I speak and write a lot about data integrity reports. So I was pleased to see a post recently on ASAE's Collaborate from Shaun Holloway, Director of Information Technology, at the American Motorcyclist Association, outlining a list of what he called "data hygiene checks."
As a reminder, the purpose of a data integrity report is to find potentially erroneous data in your system, so you can clean up the data. Here are just a few examples of what Shaun is doing at AMA:
- Common misspellings like ".cmo" or ".ogr" in the email field
- Email addresses with no @ sign
- Accounts with a City but no State
- Automated job that checks VIN numbers members submit to AMA against the Federal VIN database. These are then autocorrected with vehicle make, model, year, etc.
Shaun listed nearly two dozen data points they are checking. He didn't list the frequency of these checks, but if they can be automated (like the fourth bullet point) then they could be checked as frequently as daily.
The overarching goal of these checks is to continuously weed the garden, which is the only way you can really keep your data clean over the long term.
Wes's Wednesday Wisdom Archives
Write it down!
Write it down! If you’re in the market for a new AMS (or any new […]
Why “weeding the garden” is so important
Why “weeding the garden” is so important One of the most important activities for maintaining […]
It’s time to stop excusing association professionals
It’s time to stop excusing association professionals I worked in associations for nearly 10 years, […]
More demos is not better
More demos is not better When I work with clients on selecting a new system, […]
The database owner should be “passionate”
The database owner should be “passionate” I’m frequently asked by my clients: “Who should we […]
Discipline is required
Discipline is required Last week I discussed the importance of taking action. To manage data […]
Action is required
Action is required Over my many years of consulting, one thing I’ve noticed about many associations […]
Some data analytics tips from the DAN “Science Fair”
Some data analytics tips from the DAN “Science Fair” Last week I had the opportunity […]
Are all your processes frictionless?
Are all your processes frictionless? I’m not a huge fan of buzzwords, but I love […]
Trends don’t need perfect data
Trends don’t need perfect data When it comes to analyzing data trends (changes in data […]