Archive for August, 2009

The “miracle” of customer data integration

Monday, August 24th, 2009

mulitple view

The more a company knows about its customer’s wishes, needs and habits and the more that company is able to tailor its proposition accordingly, the greater the value it will eventually provide for its customers. We all know that there are countless examples where defective, fragmented, or just plain poor customer data cause unnecessary costs, decrease in revenue, employee dissatisfaction or frustation, damage of the corporate image and many other unsdesirable or painful consequences.

Customer data quality and integration problems impact every area of the value chain of organisations. Far too often companies have a multiple view of their customers. Customer Data Integration (or MDM for Customer Data) is the key to providing companies with a single view of their customer. (more…)

How-to create the Golden Record

Friday, August 21st, 2009

puzzle

The term Golden Record is closely related to Customer Data Integration or MDM for Customer data. It refers to the “single truth” which has been created or calculated from all those duplicate customer records from different systems. This post is not about finding or tagging all those duplicate records. There all kinds of ways to find them using advanced statistical methods, fuzzy matching etc.

But what do you once you have found the duplicates. How do you create the best possible customer data out of all gathered elements? (more…)

Confusing streetnames ending in an unfortunate fatality

Friday, August 21st, 2009

Just a few days ago I wrote about the many standards we have for streetnames in the Netherlands. But on top of that new streetnames are added constantly for newly build neighboorhoods. Sometimes this also results into changing of existing streetnames. This was also the case last week, when rescue people were not able to find the exact location in Putten. An emergency call was made for a 60 year old man, who suffered from heart failure. People who tried to re-animate the man heard the ambulance passing by, but they didn’t see the ambulance. The end result was that they arrived after 19 minutes and they were too late to save the man’s life. This is a very unfortunate accident and an investigation has been started to find out what exactly went wrong. Preliminary results shows that the navigition systems of both the police and the ambulance were not up-to-date.

I have looked at the location using Google Maps. Normally you expect that a street consists of one thoroughfare. But in this case the street, named “Kraakweg”, consists of three different parts, which are clearly not in one direct line. I have indicated it with 1, 2 and 3. Number 4 indicates another street, but with almost the same name “De Kraak”.

kraakweg1234

  (more…)

Any close encounters with the FBI terrorist watchlist?

Monday, August 17th, 2009

tsc080105aJust before this summer the U.S. Department of Justice filed a report about the FBI Terrorist Watchlist. This watchtlist serves as a critical tool for screening and  law enforcement personnel for alerting them when they come across a known or suspected terrorist. It is used by personnel at airports, harbours and the borderline. Also when you apply for a visum you are matched against this watchlist. The Terrorist Screening Center, a subsidiary of the FBI, is responsible for maintaining the watchlist.

This watchlist was created in 2004 from several other lists and at that time it consisted of about 68.000 entries. I use the word entries, because in the years after it became fuzzy if one record is the same as one individual. By the end of 2008 the list had grown to over 1,1 million entries. In 2008 after the American Civil Liberties Union (ACLU) mentioned that the list had passed the 1 million, the government came with an explanation. Although we have recorded over 1 million entries in the database, the net result is that these records correspond to about 400.000 individuals. Terrorist often use different and thus multiple identities, use several (falsified) passports etc. But adding entries with only the first initials and last name, while an entry of the full first names and last name already exists will result in unwanted side-effects. (more…)

Bi-lingual streetnames in Amsterdam, do we really need it?

Monday, August 17th, 2009

StraatnaambordSo once in a while I visit Amsterdam and have a drink or two in the centre. Afterwards I use the tram to get back to the hotel. This weekend I was quite surprised to find out that all the streetnames are announced in English, at each stop. The easy and obvious one is of course Centraal Station, which was translated to Central Station. I also can see how they came up with Rembrandt Square instead of Rembrandtsplein. But translating “Spui” to “Courtyard with a chapel” doesn’t help any tourists to find their destination. (more…)