Author Archives: admin

X Marks the Spot? Mapping errors cost a house…

Leave a reply

via Nic Jefferis comes this great example of the impact of a data inaccuracy, and one that is all too uncommon!

http://www.engadget.com/2016/03/24/texas-wrong-house-torn-down-google-maps/

Demolition workers relied on google maps to bring them to an address of a residential property that was to be demolished after storm damage.

The problem was that Google Maps had the location in the wrong place. The actual address was a block away. This resulted in a home being demolished, despite the owners having applied for funding to repair the storm damage it had suffered.

Yet again, the builders maxim of “Measure twice, cut once” appears to apply to a classic information quality problem.

 

 

Spelling mistake contributes to death of pensioner…

Leave a reply

From the Guardian (again) http://www.theguardian.com/uk-news/2016/feb/02/irmgard-cooper-bleeds-to-death-surgery-spelling-error-delays-blood-supply

A woman bled to death after a spelling mistake meant blood intended for her during an operation was sent back

The spelling mistake: IrNgard instead of IrMgard.

A second mistake related to the communication of key facts about the availability of blood during the procedure – an example of timeliness and completeness of data errors.

The Guardian report quotes the family solicitor as saying:

The first error was the misspelling of the patient’s name on the blood sample. The lack of communication between the anaesthetist and the surgeon over the absence of blood was the second error

It’s good to see that systems have been implemented to prevent recurrence. But sometimes, the processes we need to manage the quality of data in are zero-defect areas.

Bad Data Quality affects UK Pensioners

Leave a reply

From the Guardian:

Government watchdog blames lack of data and bad governance for poor performance by MyCSP and delays in payments for thousands of pensioners

According to the UK’s National Audit Office more than three-quarters of civil service pension records – 1.25m – are incomplete or incorrect, which it says has caused hardship and distress to many pensioners.

The NAO office report cites:

  • Systems capabilities not being in place to deal with processes and data on payroll and pensions
  • A lack of data governance and oversight
  • A lack of any methods to track benefits and other KPIs

This case has been cited by critics as a “text book case” of how not to reform public services.

The full NAO Audit report can be found here: https://www.nao.org.uk/report/investigation-into-members-experience-of-civil-service-pension-administration/

Wrong Number for Jury

Leave a reply

This story in the Irish Examiner caught our eye recently:

mix-up-leaves-350-potential-jurors-calling-sex-line-

It’s an example of a classic digit transposition error in telephone numbers, but in this case the wrong number called was one that might cause offence for some of the people making the call. Also, as the article points out, there was a question over whether the County Clerk would be liable for the cost of calls to the (almost certainly premium rated) sex line.

The article ends with the Count Clerk saying they’d be reviewing all letters that went out in future. This is an example of Scrap and Rework – a non-value adding action that catches defects but doesn’t actually improve the process.

A better solution: Change the phone number for the jury duty office so that it is different to the sex line and the transposition error cannot occur. Or use a standard letter template that has been properly proof-read.

But checking each letter… that’s not cost effective or sustainable as a quality control.

 

Zero Entertainment in Norway

Leave a reply

This story comes from our Norwegian Correspondent, Mr. Arnt-Erik Hansen (former IAIDQ Director of Member Services). We let him tell his tale in his own words, with only minor editing….

++++

Norway is the only country in the world, as far as I know, with full transparency with regards to personal income, wealth and state tax. One of the big Autumnal Entertainments in Norway is the annual publication of the list of taxpayers, their incomes, and the amount of tax they have paid. . Here you can search for your neighbor, your friends, enemies, public companies or government officials to find what their income was, how much they contributed to the state and how wealthy they are. On October 20, 2010 the list was published on the internet

Newspapers, TV, and blogs (including this one) find this a great event to generate stories.  Every year there are stories about the person earning the least and the most. Not only that, they compare a person’s income to the average income in the country, according to your age. They will even go as far as determining the street in Norway with the lowest average income. This is business intelligence on real live data.

However the Norwegian tax authorities are not immune to data quality problems. Here are some of the stories I read in the newspapers today (all online of course [editor: Links to the stories will be posted here soon])

A polish citizen, address in Polen and with a modest Norwegian income is reported to have paid more than 119’000’000 Norwegian Kroner (approx US$20.4 million, or €14.6million ) in taxes for 2009. As a consequence he can claim to be the biggest contributor to the state coffers. Thanks Polen, I am sure that someone will be there to collect the money soon.

This is of course wrong and the reason is, most likely, that someone punched in the wrong number – a number with too many zeros. We’ll call this “The Fat Finger Zero Error“.

Apart from errors in the data itself, there appear to be errors in the actual interpretation of the data. For example, a lady working as a cleaner got a tax claim of no less than 84’005’501 Norwegian Kroner (€10.3million or US$14.4million). Her income for 2009 was reported by one newspaper to be 324’000 (US$55,600, or €39,818) so this is an obvious error. Another newspaper reported her income to be 240’000.

A key question is: What has happened here?

The answer from the tax authorities when asked to comment on this was simply – errors happen, unfortunately, and will be corrected immediately. However, the reason was, most likely, that someone punched in the wrong number – a number with too many zeros. Well, seems that someone has a problem with zeros.

There is another story to come about the “Fat Finger Zero” error.  But first we need to share some insight into the tax reporting and collection process in Norway works.

It’s not too different to any other country. Except in Norway the State sends you your forms filled in with the information the tax authorities have about you and you simply have to sign them and send them back.  And, like most tax authorities, they most likely know more about you than yourself.

For instance, banks in Norway send megabytes of data about all customers and their accounts to the tax authorities. Which leads us to our third IQTrainwreck example in this story…

This year two banks managed to put zeros behind the customer account balances instead of in front for 500 customers.  So €00000500 became €500,0000.

A possible root cause: the definition of the attributes in the file has gone astray.

But from two banks?

Or was the requirement wrong?

It  seems that Norway has a problem with zeros.

Oh, almost forgot to mention – today the Norwegian State Fund was valued above the 3’000 Billion mark for the first time. That’s 3’000’000’000’000 Norwegian Kroner (US$514,610,220,303).

I think I understand the problems with zeros. (But how much of that is due to tax collection errors? – the sting in the tail for Norwegian tax payers is that if there is an error in their tax calculations they have to pay the decided amount and then are refunded the amount of any error).

PS! If you look up my name you will find income 0, wealth 0 and taxes 0. The reason: I lived in Switzerland in 2009 and in that country you are invited to pay taxes and it is not a criminal offence if you don’t tell the state everything.

Police Untelligence

2 Replies

From The Register comes this wonderful example of the problems that can arise where data is used for unintended purposes, resulting in poor quality outcomes for all involved.

The NYPD have been regularly raiding the home of an elderly Brooklyn couple. They’ve been hit 50 times over the past 4 years, which might mark them out as leading crime kingpins but for the fact that their address has wound up included in police data used to test notification systems. The Reg tags this as “a glitch in one of the department’s computers”, but Information Quality trainwreck observers will immediately recognise that the problem isn’t with the technology but with the Information.

The trainwreck is compounded by two facts which emerge in the article:

  1. NYPD believed that they had removed the couple’s address from the system back in 2007, but it appears to have not been the case (or perhaps it was restored from a backup)
  2. The solution the NYPD have now implemented is to put a flag on the couple’s address advising officers NOT to respond to calls to that address.

The latter “solution” echoes many of the pitfalls information quality professionals encounter on a daily basis where a “quick fix” is put in to address a specific symptom which then triggers (as el Reg puts it) “the law of unintended consequences”.  To cut through implication and suggestion, let’s pose the question – what happens if there is an actual incident at this couple’s home which requires a police response?

What might the alternative approaches or solutions be to this?

(And are the NYPD in discussions with the Slovak Border police about the perils of using live data or live subjects for testing?)

The perils of perpetuating errors

Leave a reply

Courtesy of Dataqualitypro.com on twitter comes this story about how Virgin Media in the UK have sent a letter to a customer prospect addressing them as “Mr Illegal Immigrant”.

Virgin Media have investigated the issue and state that it was an isolated incident arising from data purchased from a 3rd party. This suggests that Virgin Media might have issues with the quality control processes they apply to vetting data purchased from 3rd parties.

From an IQ Trainwrecks perspective, this ticks a lot of boxes as it has resulted in embarrassment for Virgin Media and hassle and trouble for the actual householder, a Mr Needham who told the Daily Telegraph that:

… he was offended by the letter: ”I was a bit shocked. I was taken aback. I have tried to ring up and complain and they have not really done anything about it.

”They kept passing me from pillar to post. They tried to say it was not their fault, it was somebody else. It is not good.” Continue reading →

Know your customer, know yourself

2 Replies

From today’s SUN tabloid newspaper in the UK comes this great story about how automated processes without adequate business rules and checks on information can cause embarrassment.

It seems that local government authorities in the UK have been fining themselves for parking offences and then suing themselves when the fines aren’t paid. Things have even gone as far as councils seeking awards of legal costs against themselves when they haven’t complied with their requests to themselves to pay themselves the fines that they imposed on themselves for parking their vehicles in places where they had decided people shouldn’t park.

It seems that none of them have yet tried to argue the defence that was put forward in Ferguson vs British Gas.

The lesson here is that when defining an objective in a process one should take the time to consider the various scenarios that might occur in that process and then ensure you have adequate checks and balances and controls to prevent embarrassing and costly errors from occurring.

Oh… and knowing that your customer is yourself is also a good idea.

Slovak Police accidentally cause Terror Alert in Dublin

2 Replies

The Irish and International media have been busy the past few days covering the story of the horrendously botched security test by Slovakian Border Police which resulted in 90 grams of high explosive RDX finding its way to Dublin from Bratislava in the backpack of an unsuspecting Slovakian electrician who was travelling back to Ireland after Christmas at home. This lead to a street in Dublin City Centre being closed this past Tuesday, with homes and businesses evacuated, while police and Army bomb experts raided the innocent electrician’s home to secure the explosives.

A full timeline for the story can be found here.

This is a tale which has a number of classic elements of an IQTrainwreck about it. Continue reading →

Perhaps they should have checked their listings twice?

Leave a reply

The Irish Sunday Independent reports this past weekend that the Irish State Broadcaster RTE is facing legal action from its erstwhile privately owned competitor TV3  arising from what are described as “significant and egregious” errors in the listings published for TV3’s programmes over the Christmas period in the RTE owned listing’s magazine “The RTE Guide”. The errors affect listings over the core Christmas period and also the time of one movie which is due to be broadcast tonight at 9pm but which is listed incorrectly in the Guide.

In a wonderful example which highlights the potential downstream cost and revenue implications of poor quality information, TV3 says the error is so serious that it could have a fundamental impact on its Christmas viewing figures.

And, in TV-land, viewing figures translate into hard-to-come-by-in-a-recession advertising revenues.

TV3 have asked for RTE to pulp all copies of the RTE Guide still in shops and to replace them with reprints which show the correct listings. Failing this, they have asked RTE to give prime-time advertising coverage on TV and radio to TV3 programmes over the Festive Season, which would have the effect of reducing the prime-time advertising slots which RTE would have already sold over Christmas, hitting RTE’s revenue streams as well.

RTE, for their part, blame a 3rd party supplier for the errors.

Of course, this writer’s thoughts are with the ultimate information consumers here… the viewing public. If my house as a teenager was anything to go by, the RTE Guide will have been used as the basis for negotiations about who gets to see TV ‘live’ versus programming the video recorder.

A while ago, Daragh O Brien wrote on his blog about the likely rise in Information Quality litigation, particularly as studies have shown that people become more litigious during a recession. This looks like one of those cases and it seems 2010 will be an interesting year for Information Quality management principles in Ireland.