“It’s in the database…”

"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

Be careful not to overbuy

June 14, 2023

Be careful not to overbuy I recently spoke with an association of ten staff that was …

Be careful not to overbuy Read More »

When is the best time to clean your data?

June 7, 2023

When is the best time to clean your data? One of the most common questions …

When is the best time to clean your data? Read More »

Do the benefits outweigh the risks?

May 31, 2023

Do the benefits outweigh the risks? As the economist Thomas Sowell points out, there are …

Do the benefits outweigh the risks? Read More »

Painting the Bridge

May 24, 2023

Painting the Bridge According to this article, the Golden Gate Bridge is painted continuously year-round. …

Painting the Bridge Read More »

Maintenance isn’t sexy

May 17, 2023

Maintenance isn’t sexy I remember reading once long ago that one of the reasons our …

Maintenance isn’t sexy Read More »

“Will I still have a job when this is done?”

May 10, 2023

“Will I still have a job when this is done? While working with a client …

“Will I still have a job when this is done?” Read More »

Evolution, not revolution

May 3, 2023

Evolution, not revolution I don’t recall where I first heard it many decades ago, but …

Evolution, not revolution Read More »

The power of the users’ group

April 26, 2023

The power of the users’ group Recently in an online users group forum for an …

The power of the users’ group Read More »

Who is your data evangelist?

April 19, 2023

Who is your data evangelist? I was recently talking with a client of mine about …

Who is your data evangelist? Read More »

Who is your data evangelist?

April 19, 2023

Who is your data evangelist? I was recently talking with a client of mine about …

Who is your data evangelist? Read More »

Scroll to Top