"It's in the database..."
I often joke with my clients that AMS nirvana looks like this: When someone asks "Where is the data about topic X?" the answer is always "It's in the database."
- Q: "Who were the award winners in 2019?" A: "It's in the database."
- Q: "Which meetings did this person attend in the past three years? A: "It's in the database."
- Q: "Who served on our membership committee in 2021?" A: "It's in the database."
One of the single biggest challenges (and time-wasters) that I see my clients struggle with is data being spread all over the organization, instead of being centralized in one place. Award winners are on spreadsheets. Meeting attendance is in a third-party event registration system. Committee information is in someone's Outlook address book.
Is database nirvana achievable? Since nirvana is a form of perfection, no. But we should always be striving for it.
Look around your organization. Where are the silos of data that create additional work and confusion? How can you move that data to the AMS so it can be located easily? That's how you achieve nirvana.
![]()
Wes's Wednesday Wisdom Archives
The “S” stands for “Standard”
The “S” stands for “Standard” In a conversation with a past client, we were discussing […]
Is that meaningless data?
Is that meaningless data? I’m not a big quotes guy, but one of the few […]
Be aware of unintended consequences
Be aware of unintended consequences I’ve written before that every decision involves a trade-off. When […]
Positive change is harder to see
Positive change is harder to see Humans are wired to see negative change because we […]
MVP: Minimum Viable Product
MVP: Minimum Viable Product In product development there is a concept known as MVP, or […]
You always need a reason for collecting data
You always need a reason for collecting data When you ask for data from someone […]
If you’re unhappy, speak up!
If you’re unhappy, speak up! My clients will often ask me something along the lines […]
Does it advance the mission?
Does it advance the mission? Because associations are mission-driven, everything you do should be seen […]
How should you start a new data project?
How should you start a new data project? When you’ve got a new data project […]
A Data Integrity Report…for Reports!
I’ve written elsewhere about the value of data integrity reports. But one of the most […]
