Dashboards for Data Integrity
I've written a bunch on data integrity reports. (Click here for some examples.) The purpose of a data integrity report is to find potentially erroneous data in your system, so you can clean it up.
I've also written a lot about dashboards. (Click here for some examples.) Dashboards are simply reports that are more or less ever-present in your system. Most AMSes now offer some form of dashboard functionality that allows you to put your most important data front and center (e.g., event registrations, membership counts, etc.).
Will Slade from Protech Associates pointed out to me that dashboards are a really good tool for data integrity reports. As he put it, "When clients are able to visualize their data, it is often much easier to spot check and see data errors. When dashboards are deployed, I hear things like 'Wow, I didn’t realize that 40% of our contacts are non-members. That doesn’t seem right.'"
So if one of your dashboards is actually a data integrity report, as you open your system each day, you'll see that report and be more inclined to clean up that data.
Dashboards as data integrity reports. What a concept!
![]()
Wes's Wednesday Wisdom Archives
Perfection is expensive (in fact, it’s not possible!)
Perfection is expensive (in fact, it’s not possible!) “Perfection is expensive. The last 5 percent […]
AI is a journey, not a destination
AI is a journey, not a destination Lately I’ve noticed a lot of associations talking […]
Action produces information
Action produces information “Action produces information. If you’re unsure of what to do, just do […]
Why a single source of truth is so beneficial…
Why a single source of truth is so beneficial… The holy grail of data management is […]
Just because you can, doesn’t mean you should
Just because you can, doesn’t mean you should I’ve worked in and with associations for well […]
Data doesn’t need to be perfect to be useful
Data doesn’t need to be perfect to be useful “Your data doesn’t have to be […]
Don’t just clean data, clean reports and queries
Don’t just clean data, clean reports and queries One of the reasons I exhort my […]
Don’t forget, your staff have day jobs…
Don’t forget, your staff have day jobs… The vast majority of my work is finite […]
Beware the automated “How did we do?” trap!
Beware the automated “How did we do?” trap! One of the downsides of technology is […]
Hindsight is 20/20
Hindsight is 20/20 I’m currently working with a client that is moving from their legacy […]
