Yesterday I posted a small piece called So I’m not a Capricorn? about how astrology may (also) be completely wrong because something has changed.
On the serious side: Don’t expect that because you get it Right the First Time then everything will be just fine from this day forward. Things change.
The most known example in data quality prevention is probably that it is of course important that when you enter the address belonging to a customer, you get it right. But as people (and companies) relocates you must also have procedures in place tracking those movements by establishing an Ongoing Data Maintenance program in order to ensure the timeliness of your data.
The other thing, so to speak, is that having things right (the first time) is always seen in the context of what was right at that time. Maybe you always asked your customers for a physical postal address, but because your way of doing business has changed, you actually become much more interested in having the eMail address. And, because What’s in an eMail Address, you would actually like to have had all of them. So your completeness went from being just fine to being just awful by following the same procedure as last year.
Predicting accuracy is hard. Expect to deal with Unpredictable Inaccuracy.
Great topic Henrik. Yes the timeliness of data is a crucial data quality element and one that can mean the difference between success and failure. People change details over time as they move house, get married, change name and so on. Some organisations find out before others. Some never find out. When it comes time to merge or match records for the same individual using such details in the process, the timeliness monster raises its head. If the details have been updated in one place and not in another, there are no prizes for guessing how successful your efforts will be.
Thanks Wayne for these timely observations on the effect of change in data matching.
Nice post. Change can make even the best data quality practices and infrastructure obsolete and useless. Funny timing on that. I just wrote a similar post last week on handling change in data integration projects.
http://www.dataintegrationblog.com/integration-horizons/three-integration-design-strategies-to-help-ride-the-waves-of-change/
Thanks Paige. I truly like your article on change in data integration. Well put.
This calls for a type 3 slowly changing dimension implementation, me thinks.
Thanks for joining Steve. With the zodiacal sign I will then have:
– Original sign: Capricorn
– Current sign: Sagittarius
– Effective date: 11/11/1111
as the constellations has slowly moved since astrology was fixed some thousands year ago.