Documentation is critical for consistency
There are so many reasons why documenting your data management processes are so critical to long-term success, but one of the most important reasons is to ensure we process data consistently over time. This is especially true for processes that occur repeatedly but very infrequently.
For example, a client of mine publishes a print magazine three times per year, and sells advertising for all three issues. The majority of ad sales occur in the 60 days prior to publication of each issue, which means that for six months out of the year, they are processing few if any advertising orders.
Yet they need to process these orders in the same manner throughout the year, in order to accurately report on their ad sales. And so documentation that walks the staff person through how to process an advertising order is required, in order to ensure the orders are processed the same way, every time.
Over my 25 years of consulting I've found these types of scenarios (processes that occur repeatedly but very infrequently) are usually the greatest source of bad, messy, or nonexistent data.
One of the very first articles I ever wrote (published by ASAE) was about the importance of documentation (published in 2000, you can read it here). Some things never change. Documentation IS king.
![]()
Wes's Wednesday Wisdom Archives
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 […]
Cheaper now; costlier later.
Cheaper now; costlier later. Most of my clients are very cost-conscious, understandably. After all, who […]
The unified shopping cart: Dreams vs. reality
The unified shopping cart: Dreams vs. reality One of the more common requests I hear […]
Don’t forget to celebrate!
Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]
Three thoughts on duplicate records
Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]
Please don’t do this…
Please don’t do this… I’ve noticed a trend among online retailers that I want to […]
