Category Archives: IQ Trainwrecks and Customer Service

Google Health – Dead on Arrival due to duff data quality?

It would seem that poor quality information has caused some definitely embarassing and potentially risky outcomes in Google’s new on-line Patient Health Record service. The story has featured (amongst other places) :

  • Here (Boston.com, the website of the Boston Globe)
  • Here  (InformationWeek.com’s Global CIO Blog)

‘Patient Zero’ for this story was this blog post by “e-patient Dave” over at e-patient.net. In this blog post “e-Patient Dave” shared his experiences migrating his personal health records over to Google Health. To say that the quality of the information that was transferred was poor is an understatement. Amongst other things:

Yes, ladies and germs, it transmitted everything I’ve ever had. With almost no dates attached.

So, to someone looking at e-Patient Dave’s medical records in Google Health it would appear that his middle name might be Lucky as he had every ailment he’s ever had… at the same time.

Not only that, for the item where dates did come across on the migration, there were factual errors in the data. For example, the date given for e-Patient Dave’s cancer diagnosis was out by four months. To cap things off, e-patient Dave tells us that:

The really fun stuff, though, is that some of the conditions transmitted are things I’ve never had: aortic aneurysm and mets to the brain or spine.

The root cause that e-Patient Dave uncovered by talking to some doctors was that the migration process transferred billing code data rather than actual diagnostic data to Google Health. As readers of Larry English’s Improving Data Warehouse and Business Information Quality will know, the quality of that data isn’t always *ahem* good enough. As English tells us:

An insurance company discovered from its data warehouse, newly loaded with claims data, that 80% of the claims from one region were paid for a claim with a medical diagnosis code of  “broken leg”. Was that region a rough neighborhood? No, claims processors were measured on how fast they paid claims, rather than for accurate claim information. Only needing a “valid diagnosis code” to pay a claim, they frequently allowed the system to default to a value of “broken leg”.

(Historical note: while this example features in Larry’s book, it originally featured in an article he wrote for DM-Review (now Information-Management.com) back in 1996.)

“e-patient Dave” adds another wrinkle to this story..

[i]f a doc needs to bill insurance for something and the list of billing codes doesn’t happen to include exactly what your condition is, they cram it into something else so the stupid system will accept it.) (And, btw, everyone in the business is apparently accustomed to the system being stupid, so it’s no surprise that nobody can tell whether things are making any sense: nobody counts on the data to be meaningful in the first place.)

To cap it all off, a lot of the key data that e-Patient Dave expected to see transferred wasn’t there, and of what was transferred the information was either inaccurate or horridly incomplete:

  • what they transmitted for diagnoses was actually billing codes
  • the one item of medication data they sent was correct, but it was only my current BP med. (Which, btw, Google Health said had an urgent conflict with my two-years-ago potassium condition, which had been sent without a date). It sent no medication history, not even the fact that I’d had four weeks of high dosage Interleukin-2, which just MIGHT be useful to have in my personal health record, eh?
  • the allergies data did NOT include the one thing I must not ever, ever violate: no steroids ever again (e.g. cortisone) (they suppress the immune system), because it’ll interfere with the immune treatment that saved my life and is still active within me. (I am well, but my type of cancer normally recurs.)
  • So, it would seem that information quality problems that have been documented in the information quality literature for over a decade are at the root of an embarassing information quality trainwreck that could (potentially) have an affect on how a patient might be treated at a new hospital – considering they have all these ailments at once but appear asypmtomatic. To cap it all off, failures in the mapping of critical data resulted in an electronic patient record that was dangerously inaccurate and incomplete.

    Hugh Laurie as Dr. Gregory House

    Hugh Laurie as Dr. Gregory House

    What would Dr. Gregory House make of e-Patient Dave’s notes?

    e-Patient Dave’s blog post makes interesting reading (and at 2800 words + covers a lot of ground). He details a number of other reasons why quality problems exist in electronic patient records and why :

    • nobody’s in the habit of actually fixing errors. (he cites an x-ray record that shows him to be a female)
    • processes for data integrity in healthcare are largely absent, by ordinary business standards. I suspect there are few, if any, processes in place to prevent wrong data from entering the system, or tracking down the cause when things do go awry.
    • Data doesn’t seem to get transferred consistently from paper forms to electronic records (specficially e-Patient Dave’s requirement not to have steriods).
    • Lack of sufficient edit controls and governance over data and patient records, including audit trails.

    e-Patient Dave is at pains to make it clear that the problem isn’t with Google Health. The problem is with the data that was migrated across to Google Health from his existing electronic patient record.

    Google Health – DOA after an IQ Trainwreck.?

    The Butterfly Effect

    I’m sure most of you are familiar with the concept of the “Butterfly Effect“, that part of Chaos theory that tells us that the small disturbances of the air by a butterfly’s wings in Cleveland can cause a natural disaster on the far side of the world.

    A popular myth is that the term ‘bug’ as applied to software glitches was coined by Admiral Grace Hopper after moths (and perhaps butterflies) were removed from the machinery of a Mark II Univac computer which had stopped working.

    These two tidbits are related by a recent story in the Financial Times about how ‘coding errors’ (bugs) in computer models has resulted in a debt rating agency having to acknowledge they’d ranked investment vehicles wrongly and as a result increased the risk exposure of investors in those funds.

    From the FT:

    Moody’s is moving to re-examine the accuracy of all its computer models and place them under a centralised monitoring system after it formally acknowledged earlier this week that a glitch had appeared in one such mathematical model used to rate complex products.

    Later in the article:

    The moves come after the agency admitted on Tuesday that a “coding bug” had led the agency to incorrectly award top notch triple-A ratings to about $1bn of complex instruments known as constant proportion debt obligations (CPDOs) in 2006. This bug was first revealed in an FT investigation in May.

    So, the bugs were found by a newspaper investigation in May 2008.. embarassing. The bugs affected the ratings applied to these CPDOs, and may have distorted the investment strategies of institutional investors. The Financial Times article in May tells us that:

    The products were designed for institutional investors. In the recent credit market turmoil, those who still hold the products will have suffered some paper losses while others who have bailed out have lost up to 60 per cent of their investment.

    Sheesh… up to 60% losses on investments. And it hit the papers.

    The FT (28th April 2008) reports that Ratings agencies are coming under increased pressure to assure the quality of the information used in assigning credit ratings. Ratings agencies are reported to have told Regulators that:

    Guaranteeing the quality of information used to assign credit ratings on structured finance securities would be “overly burdensome and redundant”

    However, the burden and cost of avoiding bugs in software, processes and controls that impact on the quality of key information used in the Financial markets should be weighed against the risk of financial ‘natural disasters’ where decisions are made on foot of inaccurate information.

    [Update] It would seem that the SEC and the European Commission (the civil service of the EU)  are intending to take action to regulate and regularise the dealings of these ratings agencies…[/Update]

    An electric (bill) shock

    Courtesy of Cambridge News comes this story of a shocking electricity bill.

    British Electricity provider N-Power sent a Cambridge woman a bill recently for just over stg£90million (US$ 177million). This was bemusing to her because she has availed of a pre-paid electricity meter. It would seem that for the woman to have run up such a bill would have taken over 1900 years.

    As an aside, the Cambridge News article also higlights a recent survey from British website www.moneysupermarket.com:

     A survey last month showed 34 per cent of people have spotted an error in a utility or credit card bill in the past 12 months, while 17 per cent were overcharged during the past quarter.

    The survey by financial website moneysupermarket.com reveals half of us don’t bother to check bills.

    British Gas Billing leaves explosive whiff in the air….

    The Register today reports that British Gas (aka Centrica) is taking legal action against international consulting firm Accenture after a total overhaul of their billing systems costing stg£300m resulted in customers being incorrectly billed (in some instances on multiple accounts – for one customer at the same address). British Gas claims that it has had to hire 2500 extra staff to work on fixing the problems. According to The Register, GB has already written off £200m resulting from customer complaints. This means that the minimum you should estimate for the total cost of non-quality here is a figure to the north of £500m sterling (Cost of implementation + costs of scrap and rework  = ‘First cut Cost of Non-Quality). For readers in the US, that is nearly US$1bn.

    And that is BEFORE the lawyers get involved. And before you take into account the cost to British Gas of lost customer revenues when customers switch to a rival supplier to get away from the problems.

    British Gas claim that Accenture are responsible for implementing  a system which didn’t work and which had “fundamental errors” in its design and implementation. Accenture, for its part, rejects the British Gas claims saying that:

    “Centrica directed the design, build and implementation of the Jupiter system and insisted on many of the features they now find problematic. At their own choice, after extensive testing, in March 2006 Centrica took over total control over all aspects of the system about which they now complain and has operated the system themselves for over two years.”

    Accenture will be ‘vigourously defending’ the High Court action. To translate this:

    1. It’s in the English High Court (“ka-ching” says the lawyer’s cash register)
    2. It will be an aggressive case (meaning lots of lawyers with cash registers going “ka-ching”).
    3. Customers (of Accenture and/or British Gas) will wind up paying the price in the end (the ‘Lawyers who like to say “Ka-Ching”‘ will require paying).

    So, is this an IQ Trainwreck?

    Yes it is. There is a significant cost to British Gas already incurred, with further costs to arise for both British Gas and Accenture. However the real impact has been on British Gas customers, who have wrestled with incorrect billing issues and related frustrations since the system went live.

    Andrew Brooks, (one of our IAIDQ members in the UK and a man with some experience in these types of projects it would seem) has a nice post on his blog about the real root cause here. He makes some very valid points about who was (or should have been) driving this particular train when it went off the rails. His short post is well worth a read.

    Continue reading

    A salutory tale of poor IQ

    Gizmodo.com occasionally features ‘localisation’ problems (they spell it with a ‘z’, yet another localisation problem). As localisation raises challenges of customer expectation, information design, information presentation and a whole heap of other potential tripwires for Information Quality disasters, this is sometimes a good source of quick examples of how poor quality information can screw up processes.

    Sometimes, however, there are stories that take it to such an extreme that they move out of the realm of ‘localisation problem’ and into the domain of ‘Information Quality trainwreck’. This following story is just such a tale. (the full Gizmodo article can be found at this link) Continue reading

    Aer Lingus pricing blunder brings everyone back down to earth (and now the lawyers are involved!)

    The IAIDQ is holding its annual US conference (the IDQ Conference) in San Antonio this September. As a Director of the Association and a potential speaker at the event I’ve been researching my options for flying to the US as cheaply (but comfortably) as possible.

    Imagine my dismay when I spotted that I’d missed an opportunity to take advantage of an IQ Trainwreck to get myself to the US on Business class for less than it costs me to get home from work!

    Ireland’s RTE news is today reporting that Aer Lingus has cancelled the bookings made by passengers who tried to avail of a €5 (US$8.00 approx) Business Class fare from Dublin to the US, a flight that normally costs €1,775 (just under US$3,000). [update 2008-04-18]Patrick O’Beirne of Systems Modelling Ltd in Gorey has pointed out to me in an email that the <u>actual</u> cost of the flights was a bit higher when taxes, charges and the relative position of the sun are taken into account[/update]

    This fare was available on the aerlingus.com website between 7:30am and 9:00am yesterday after (apparently) ‘promotional’ fares were loaded to the website in error. Around 100 people (some sources have it at 300 people, so I can’t vouch for the accuracy of this figure) managed to book the €5 fare, resulting in a potential loss to the airline of at least€177,700 (just under US$280,000).

    The airline sent emails to the customers informing them that they had cancelled the bookings as the price was in error, however the Consumer Association has pointed out that the 100 people had valid contracts. The CEO of the National Consumer Agency has sought a meeting with the airline to discuss the situation.

    The airline has argued that the fact that ‘economy class’ seats were advertised on the website at €249 should have suggested that there was an error in the €5.00 price.

    However, the Press Release from the National Consumer Agency is quite clear that Aer Lingus would be in breach of contract in cancelling the flights and that “blaming a technical error in their booking system is not good enough”.

    [update 2008-04-18] It has been reported this morning that a group of 50 property developers who had booked flights at the €5.00 price are starting legal proceedings to force Aer Lingus to honour their contracts. As we don’t have the concept of a class action suit here in Ireland, unless these property developers are part of a consortium that is a legal entity in its own right, that means that Aer Lingus is potentially facing 50 court cases, each requiring legal representation that will cost a lot more than the €17770 shortfall in the ticket price.

    Ah… you just have to love lawyers.

    Why is this an IQTrainwreck?

    Cost to Aer Lingus of honouring the contracts will be €177700. The cost to the airline of the PR fall out from cancelling the contracts would also be significant. The legal costs that will arise now are also likely to be significant.

    Dream host, Billing Nightmare

    Courtesy (yet again) of The Register comes this case of poor Information Quality. It seems that US web hosting company DreamHost accidentally overbilled its customers for services due to what has been described as a “fat finger error”.

    Full details of the good intentions that paved the path to this Information Quality Hell can be found on the company’s blog – they are refreshingly honest, if perhaps misreading the seriousness of tone that these type of issues require. Also some questions appear to be still unanswered (like how did some customers get billed twice for future dates). The ‘official story’ can be found on their Status site. On both sites the comments illustrate the impact on their customers.

    Why is this an IQ Trainwreck? Well, by the company’s own admission, nearly every one of their customers has been overbilled. Many of these customers may have incurred additional bank or credit card charges if they have exceed overdraft or credit limit thresholds – which will probably have to be refunded by Dreamhost.

    The root cause – a fat finger that created parameters for manual rebilling checks that were in the future… 2008 was the year keyed in, not 2007. And their billing software did not contain a business rule to either prevent or validate any attempt to bill for a future date.
    Dreamhost fail to identify the need for a proof reading check to ensure that data going into a process (such as dates) fall within reasonable bounds for the process (choosing of course to blame the software). Of course, many of the 415 commenters on their blog have picked up on this simple step that could have avoided this IQ Trainwreck.

    However, Dreamhost’s handling of the situation reveals another ‘cultural’ issue that means that these types of problems will recur. Their focus has not been on the customer – while some may appreciate the jokey tone of their blog post explanation, many of the commenters on their blog have condemned their ‘jokey’ if honest posting about the issue (it is perfectly OK for IQ Trainwrecks to joke about these things – we want people to laugh and then think – ‘oh, that could happen to me’).  As one commenter put it

    “Hey, sorry your rent bounced, but here’s a picture of Homer Simpson and some lulzy hipster prose. Joking around might not be the best technique when you are messing with people’s money”.

    Finally, it is an IQ Trainwreck because Dreamhosts competitors have jumped on the opportunity to steal business from them. One of their competitors has created a discount code for people switching hosting to them from Dreamhost which gives them savings on their hosting costs (with no guarantee they won’t be as clumsy with their billing I suspect).

    This will be a costly one to put right.

    oops Amazon did it again…

    Also from “The Register”, it appears that Amazon have again created ‘interesting’ relationships in their data that have had uncomfortable results for their customers.

    We previously reported on the IQ trainwreck that occured when Amazon sent email recommendations for sex toys to people who’d never bought such items from Amazon. Today they seem to have gone one better with a search for “Spiderman Watch” on Amazon.co.uk returning a quite prominent sex toy.

    The Register posted their story at 15:03 GMT+1 today, and at 16:14 this correspondent found the same item, this time TOP of the search results.

    I’ve uploaded a screen grab of my search results and clicking here will bring you to my search string… rather than risk offending readers the screen grabs are linked to rather than displayed as thumbnails.

    Spiderman Watch Search Result (Image not presented for fear of offending)

    As Amazon uses linkages within its data to present recommendations, purely in the interests of research I followed a few links on the product page for the unexpected result to see what might have lead to the association being created.

    Under the product detail for the sex toy Amazon proudly lists that customers who bought items like this also bought “Spiderman – The Animated Series” and a number of innocent children’s toys.

    The sex toy and a number of others of similar kind (which revealed themselves when I clicked on the producer name) appear to be categorised “Toys and Games” in the Amazon database… which means that they may (indeed WILL) appear in other searches. For example, if you search for “Rabbit” under the “Toys and Games” category, look what appears in the “New Arrivals” section on the left hand side

    Link to Screenshot of Search results for ‘Rabbit’ in ‘Toys and Games on Amazon’.

    Further investigation indicates that the root cause here is the nature of the classification and tagging of these particular ‘toys’ in the Amazon database… searching for “Rabbit” under “Toys & Games/Dolls & Accessories” produces an interesting result on the first page… Example of classification/metadata issue

    Why is this an IQ Trainwreck?

    1. Reputational Damage – The fact that the item is returned in a search for a children’s product is damaging to Amazon’s reputation as a retailer. As the story has appeared on The Register, it is possible that a ‘slow news day’ will result in it appearing in local nor national press in the UK (and it has been mentioned here).
    2. Derived from information – Amazon search results are returned from Amazon’s database… somewhere in the database a relationship has been created between the term ‘spiderman watch’ and this particular sex toy. This may have happened by accident or through malicious intent on the part of an individual. However the fact that it can happen suggests a lack of control over the information (should it be ‘consistent’ for a search for a children’s watch to return a sex toy? What controls might Amazon consider to improve the quality of their searches and prevent possibly inappropriate content from being shown to children?)
    3. Information is of poor quality – it fails to meet or exceed expectations.

    Personally, I wouldn’t want to have to explain to any kids what those particular toys were for.

    I am reminded of a story I heard about a particular court case in Ireland a few years ago where a children’s party hire shop sued a classified directory enquiries provider for listing them in the Adult party hire section of the directory….

    Hidden data, hidden dangers

    I have always been an advocate of speaking of “data” rather than of “databases”, and have always felt that hiding data within large integrated database systems is a danger not only to the quality of the data but to the owners of the data themselves: the customers.

    A couple of recent events illustrate this very well.

    My neighbour received an e-mail confirming that his telephone and internet cancellation request had been received and that he would be cut off in the summer of 2008. My neighbour had made no cancellation request. Calls to the call centre – as to any call centre – are to people whose access to data is severely restricted. They could not see who had made this request, why it was made, what the consequences might be. By the same token they could do little about the issue except make a note of the situation and to start a process to cancel the cancellation. These operators are never allowed to pass you on to somebody who has access to more information or who can take other actions.

    Bad enough, and it makes me paranoid to think that people, for whatever reason, could take actions like cancelling my ‘phone on my behalf. But today my neighbour’s telephone was cut off, 10 months before the date and without reference to the fact that this was in error. The company’s system has been unable to make any connection between the command to cut off the line, the command to stop this and the demand of the customer to rectify the error.

    In my own case, a certain person has requested a cable internet connection at my address, where she does not live and has never lived. This error is known to the cable company, yet they are unable to access their data in their systems to correct it properly. I have informed them, and presumably they now know where this lady really lives, because she would have complained about not getting the connection she requested (I sent the couriers with the hardware away with a flea in their ears). Yet letters continue to arrive from that company to the non-resident lady because of data quality and system integration issues which they seem powerless to correct.

    The next step, I fear, is that the company will assume that the address correction is a house move and cut off my connection. Their system seems to allow two owners of a single connection, and nobody is aware that there is a data quality problem. Explaining this to the operators in call centres does nothing to resolve the basic problems.

    My own ISP has made more errors in my account in the past 3 months than … but OK, you’re getting the picture.

    By hiding the data within their systems these companies will never be aware that there is an issue to be resolved. As far as they are concerned the system is not throwing up error messages and there is therefore no reason to assume that the system is working incorrectly. The path between customer and data is long and protective walls have been built which prevent more than a limited amount of information about such errors reaching anybody who either cares or who can do anything about it. Losing my television for a period wouldn’t be a major worry. Losing my internet connection would be a much greater problem. By the same token we are all at risk of the inflexibilities of such systems if, for example, we get mistaken for terrorists because our names are similar to somebody else’s and access to the data to verify this is blocked.

    How do we make companies aware that they have data quality and data systems problems? I wish I knew. Perhaps somebody from one of those companies (KPN, XS4ALL, UPC) with read this, will care, and will want to change things. If they do: contact me.

    http://www.grcdi.nl