Snapshots are required Recently a couple of different clients have asked me why it’s necessary to take a snapshot of data (e.g., a member count) in order to track the history of data (e.g., comparing year over year membership counts). They ask: “Why can’t we just query the data from last year?” The answer? Because your …
“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 …
Using the Pomodoro Technique for data management I’m a huge fan of the Pomodoro Technique, which is a time management technique for breaking down larger projects into bite-sized pieces. I’ve found for someone like me who can be easily distracted, it’s a very effective way to stay on task. When it comes to data management, and especially …
Using the Pomodoro Technique for data management Read More »
You need a PLAN to deal with duplicates Here’s the thing about duplicate records: No matter what you do, you’ll never get rid of them completely, because humans are human. Whether it’s a staff member creating a duplicate record because they forgot to check if the record exists, or it’s a customer who doesn’t want …