The hidden costs of bad data
Nobody likes bad data, and presumably we're all working tirelessly to minimize it. After all, bad data has a price.
Some obvious "costs" of bad data include poor deliverability of email/snail mail, inability to target market/message, inability to analyze data effectively, and potential reputational embarrassment.
But there are also many indirect costs for bad data. One example of this is querying and report-writing. When data is bad, writing queries or reports that are accurate and usable can become very time-consuming, as staff (or a paid contractor) has to make extra efforts to filter out bad data. Every time a report has to be refined to address bad data is an increase of direct or indirect costs to the organization.
Another example is loss of trust in the data itself, by staff and, potentially, by the board and members. The more bad data that consumers of the data see, the less likely they are to trust data they see in the future. And of course, this can lead to the cycle of doom.
The cost of bad data is high, especially when you consider indirect costs. Are you doing everything you can to keep your data clean?
(Hat tip to Mike Frye for this idea.)
![]()
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 […]
