Dashboards for Data Integrity

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

Who do you trust?

January 31, 2019

Who Do You Trust I was reading an article recently about Warren Buffet’s “rules” for …

Who do you trust? Read More »

Set benchmarks to measure progress

January 24, 2019

It’s impossible to measure progress if you don’t know your starting point. This sounds axiomatic, …

Set benchmarks to measure progress Read More »

You’ll make incorrect decisions. Acknowledge them and fix it.

January 17, 2019

A client of mine recently wrote the following to me: “It’s so hard to set …

You’ll make incorrect decisions. Acknowledge them and fix it. Read More »

"Experience is unobservable to everyone except the person who it happens to."

January 10, 2019

In Dan Gilbert’s book Stumbling on Happiness, he writes: “Experience is unobservable to everyone except …

"Experience is unobservable to everyone except the person who it happens to." Read More »

Know Your Audience Before You Speak

December 20, 2018

This one may seem obvious, but when you’re speaking to anyone, whether it’s one person, …

Know Your Audience Before You Speak Read More »

"Behavior is a function of the person in their environment."

December 13, 2018

Lewin’s equation says “behavior is a function of the person in their environment.” (He was …

"Behavior is a function of the person in their environment." Read More »

Signal-to-noise ratio

December 5, 2018

Signal-to-noise ratio Signal-to-noise ratio, formally used, applies to electricity and engineering, and refers to how …

Signal-to-noise ratio Read More »

Consultants bring perspective

November 28, 2018

Consultants bring perspective At a recent speaking engagement, I was asked what I think is …

Consultants bring perspective Read More »

Garbage in, gospel out

November 22, 2018

Garbage in, gospel out We’ve all heard the phrase “Garbage in, garbage out.” If the …

Garbage in, gospel out Read More »

Dramatic change does not happen overnight

November 15, 2018

Dramatic change does not happen overnight Like most things in life, dramatic change does not …

Dramatic change does not happen overnight Read More »

Scroll to Top