The DOBlog

Category: Information/Data Quality Issues

  • Conferences and me for the end of 2007…

    Conference season is upon us in the Information Quality Community…

    At the end of September I’m off to Las Vegas to deliver a presentation at the IAIDQ’s North American conference the IDQ 2007 Conference.

    At the end of October I’m off to sunny London for the IRMUK Data Management and Information Quality Conferences. This will be my sixth year at this conference and my fourth as a presenter. This year I hit the ‘big leagues’ with a 3 hour tutorial on some of the legal aspects of Information Quality, going head to head with Larry English (amongst others)on the time table.

    Then in November the Irish CoP of the IAIDQ, the IQ Network will be hosting our IQ Forum… we’re planning it to co-incide with World Quality Day on the 8th of November to tie in with some IAIDQ events that will be taking place world wide.

    Who knows, maybe I’ll meet somebody from Dell at one of those conferences who might be able to fix my laptop problem before Christmas. 😉
    That would be nice.

  • Dell Hell Ireland (and other flavours) on Google

    So for shits and giggles I decided to google Dell Hell and Ireland. (The wife is out for the night, I’m bored, it seemed like a good idea at the time).

    http://www.google.ie/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GGLF_en-GBIE226IE228&q=dell+hell+ireland

    To increase the sample size, I removed the reference to “Ireland” and instead googled for “Dell Hell Information Quality”… frack me, there I am again – the top 2 (tonight, 27 July 07).

    http://www.google.ie/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GGLF_en-GBIE226IE228&q=dell+hell+information+quality

    So to be fair to Dell I removed the reference to “hell” to see how the DoBlog might fare with the Great Search Algorithm in the sky. This was a ‘positive control’. Wasn’t I pleasantly surprised when I was again the top 2 listed links on this day…

    http://www.google.ie/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GGLF_en-GBIE226IE228&q=dell+information+quality

    Not yet in Damien Mulley/SkyHandling Partners/”the server cannae take it Captain, she’s goin’ te blow” territory one can always dream…

    I googled a few other combinations… for “Dell quality Information” I was results 3 and 4 out of 16,800,000. That was a very neutral query. Still other combinations were picked but I can’t be bothered typing them … the screenshots below will show you the story.

    What I learned is that I am missing a very important tag from these posts… “Dell Quality”. That will be fixed tonight.

    Also by googling for Dell Quality and Ireland I found this pdf of a Dell presentation. I was interested to read this quote from Michael Hammer (Business Process Re-engineering guru) towards the end of the slides… I’ve highlighted a few words that leapt out at me.

    “ The 21st Century Belongs to the
    Process Organization Centered on
    Customers     and…Operates With
    High Quality    , Enormous Flexibility,
    Low Cost, and Extraordinary Speed.”

    With regards to my broken keyboard Dell are hitting the marks on this one. Quickly dealt with, within the agreed time period – the failure of the delivery is down to me… (sorry Dell, I’ll sort it out as soon as I can).

    My Graphics card issue however is a result of a failed process (assembly) as a result of poor quality information (either the assembler didn’t know to put in a 256mb card or couldn’t tell a 128mb card from a 256mb card) which has dragged on now for five months (which is extraordinary speed, just not in a good way). The fact that the issue still isn’t resolved and I’ve got a second ‘Customer Advocate’ from Round Rock Texas on the case now is indicative of how wide of their goals Dell are.

    (A big shout out to Rick and John… hope you guys are reading this as you reached out and I believe you have done your best to help with my situation. Elizabeth in Dublin… if you are back in the office could you PLEASE respond to the last few emails I’ve sent you as they are quite important… the email address you gave for the person who was covering for you kept bouncing back.)

    Joseph Juran, the Quality Management guru put it very well:

    “They thought they could make the right speeches, establish broad goals, and leave everything else to subordinates… They didn’t realize that fixing quality meant fixing whole companies, a task that cannot be delegated.”

    Joseph M. Juran, “Made in the USA: A Renaissance in Quality”, Harvard Business Review, July 1, 1993

    Deming’s Point 10 tells us “Eliminate slogans, exhortations and numerical targets for the workforce since they are divisory. The difficulties belong to the whole system”.

    Firefighting does not improve quality, especially when the fire is let smoulder on for nearly half a year (and a whole new product launch).

    Dell Information Quality search results

    Dell quality Ireland

    Dell quality information

    Dell Hell Ireland

    I have others but I can’t be bothered to put them up… I think my point is made.

    Perhaps Dell should consider getting in contact with the knowledgable practitioners in the International Association for Information and Data Quality (www.iaidq.org) who might be able to share some pointers on how to address the root causes of this problem.

  • Dell Hell… but not mine, but perhaps a different circle of the same techno hell

    The other guy’s story

    Came across this on Tom Raftery’s blog. Looks like Tom’s guest writer Frank P had ‘issues’ with Dell when trying to buy some kit off them. A barrier had been created that prevented him from buying a machine from the UK Dell outlet store simply (it would seem) because the UK uses sterling and the Irish Republic uses the Euro.

    This does not seem to be a problem for Marks and Spencer, who will happily charge my credit card in Euros or Sterling when I am buying bits and bobs when on trips to London. Nor do the people in the UK I’ve bought stuff from (including a laptop and spares for my guitar) on ebay have any problems selling to the Republic of Ireland just because we use Euros… they let paypal sort the currency conversion for them and whammo the wifey has a new toy and I can get back to trying to hammer a few tunes out of my much abused fender strat.

    Quality is about meeting or exceeding customer expectations. Deming advises us in his 14 Points to ‘break down barriers between departments’. To meet FrankP’s request, Dell could have simply charged him a slightly higher fee to cover currency conversion costs and transport from the UK (chances are the machine is in a warehouse in Ireland though…). Bingo- one sale, one happy customer. The barrier might have more to do with internal accounting for products by the market they are sold to… but that is a supposition on my part.

    The economics of this ‘non-quality’

    If I’m right, that is just crazy and is an excellent example of how ‘stovepiped’ management of ‘battling business units’ is a fricking recipe for disaster in most businesses and how such artificial barriers to delivery of quality products or service should be torn down.

    It’s like having a football team with defenders who won’t pass the ball to their strikers who are in the box with a clear shot on goal and the keeper off his line just because the strikers are paid in Euros while the defenders get their cheques in sterling. (Jaysus, I think that was a football metaphor.. not sure what it means or if it makes sense but it reads well).

    If you have ‘seconds’ stock or ‘returns’ you have inventory on hand. That costs money to store and if not sold costs money to dispose of. The longer it is stock on hand (in a warehouse gathering dust) the faster the resale price is dropping (due to obsolescence and the entry of newer/better products into the market at the original price point) and the less likely you are to recoup the cost of production, cost of storage and other related costs. Eventually the inventory becomes ‘below-zero’ in that it will have cost you more than you’ll make by selling it… resulting in declining profit margins.

    In order to reduce the costs to your business you should really be trying to sell that fecker to anyone (within the bounds of the law) who comes knocking/calling/writing as soon as possible without putting seemingly petty administrative barriers in the way. Doing so results in a business process that does not meet the expectation of the customer and as such is not a process that delivers ‘quality’. Furthermore it creates a risk of negative profit margins in the business.

    Instead Dell got a blog post on a highly trafficked blog (Tom Raferty’s)written by a respected professional pundit on the IT industry and Web2.0 trends (not an amateur by any stretch) where through various comments the customer service issue is discussed at length. And then that post is in turn linked to by me, with my particular perpsective on the issue.

    And for all we know the laptop still sits unsold in its cold warehouse shelf, unloved and spurned by the new Vostros and Inspirons that swank by with their swish coloured lids and ‘more bang for your buck’ specifications. Stick a red nose on that laptop and call it Rudolph. It won’t be let join in any laptop games I can tell you.

    My saga continues

    I have had and continue to have my issues with Dell. Currently I’ve been dealing with John, one of their Customer Advocates, Elizabeth (a Dell Ireland person) and half a dozen others over the past 5 months. At this rate I’ll probably have spoken to more Dell employees than Michael Dell himself by the end of the year.

    To cap things off (no pun intended), the ‘Q’ key on my keyboard broke off on Tuesday (too much angry typing of ‘Quality’ I fear and the end of my career as a ghost-writer for James Bond novels unless I do some business re-organisation of MI6 or cut back on the gadgets).

    HAPPY NEWS

    I contacted Dell support and was dealt with promptly. I was informed I’d have the keyboard today. I arranged to work from home to be available to take delivery here. Unfortunately I missed the call from the courier and will need to try to rearrange delivery (hopefully I can get it tomorrow rather than having to work from home Monday as well).

    Crappy News

    This is the GOOD NEWS. The BAD news is that some strange things happened to my information as it bounced around Dell Customer Support. For one, they changed my name.

    Here is the email I received yesterday informing me of delivery:

    Dear Mr. Brien,

    Thank you for your reply.

    Your call has been logged, and your reference number is [edited out by me]. Keyboard will be with you on next business day, between 09.00 and 17.30 (or other local working hours). If you are office based then please advises your reception of the expected Courier visit. You will be contacted in the event of any unforeseen delays.

    Thank you for giving me the opportunity to assist you. Your case number for this interaction is [edited out by me].

    Thank you again for contacting Dell Hardware E-Support.

    “BRIEN” That’s not my name. That annoys me. That’s not good information quality. Why not?

    Well, Dell’s on-line Tech Support form looks like this (once you key in the asset tag that identifies your machine)

    Dell’s Support Site

    I’ve blocked out the asset tag for my machine (for privacy) and you’ll need to click on the thumnail to see the full image but you’ll need to for the rest of this to make sense…
    Note the first two mandatory fields:

    • First Name
    • Last Name

    I won’t go into why this is a bad labelling convention that is Anglo-centric (Given Name/Family Name are better)… for now it is enought that Dell’s form has distinct fields for my Firstname (given name): DARAGH and my Lastname (Family Name): O Brien. That’s what got typed in there. So why/how did Dell decide that the “O” in my name was surplus to requirements?

    Attention to the little details (like getting my name right or ensuring that my laptop ships with the correct graphics card installed) are evidence of a coherent and congruent quality culture. Soundbites, slogans and self-contratulatory marketing materials don’t build such a culture. The IAIDQ is a professional organisation that exists to support the development of ‘Information/Data Quality’ as a management discipline. Their website is www.iaidq.org and Dell employees (or anyone for that matter) will find some useful information there about the root causes and real impacts of these types of problems

    But back to the happy path

    That said… the tech support guy Guaran was great in sorting out the replacement keyboard and I am kicking myself I missed the couriers call when it came bang on schedule.. when you’re good you’re good.

  • Mobile phone registration

    The Irish Government have again trundled out a proposal to force mandatory registration of pre-paid mobile phones. It is stated that this will be a wonderful weapon in the war on drugs, organised crime and pixies.

    There are two small problems with the proposal as it currently stands.

    1. It is unlikely to work as the politicians claim it will
    2. It is unlikely to work as the politicians hope it will

    Now, technically, this is just one problem but it is such a doozy I thought it would be worth mentioning at least twice.

    The reason it is unlikely to work as the politicians claim it will is that in order to ensure that the Register of Mobiles does not become filled with Michael M. Ouses or I.P Freelys the process will require some form of validation of name and address. In order to mitigate the risk of forged or fraudlent documentation being used (which would result in Mr Freely freely getting his fone phraudulently phone fraudulently) this documentation will need to be of some ‘official’ form.

    For Bill Pay phones the usual documentation required is a passport or drivers licence (a work ID on its own is not usually sufficient in my experience) and a utility bill – these prove you are who you say you are and you live where you say you live. In order for the Register of Mobiles to meet the stringent evidentiary requirements that the stated purpose require (to deter criminals using mobiles and to assist in tracking and apprehending them via their mobile records) then a very high level of validity and verifiability will be required of the information used for identification purposes when the phone is being purchased.

    The majority of Ready-to-go customers would seem to be children and teenagers (I’ve lost track of the number of phones my teenage sister-in-law has had over the past few years). They may not have a passport, are unlikely to have a driver’s licence (until they are in their late teens) and are extremely unlikely to be in possession of a valid utility bill in their name.

    So how will they register their phones? Are the Government proposing that the phones would be registered to the parents of these children and teenagers? What then if the child is involved in some criminal activity? Does the parent become a suspect because of the mobile phone records?

    “I didn’t beat up little Johnnie… I’d left my phone at home. My ma hates Johnnie – she must’ve done it!”.

    One solution proposed to this (which according to the Irish Daily Mail came from Civil Servants in a review of this idea update– thanks to Antoin at eire.com who has a blog post which quotes the Dept of Communications on this topic) would be to implement the Register of Mobiles only after a National Identity Card was introduced in Ireland. In theory, this would give a standardised, State-backed identity (and possibly a unique identifier for the person). However there are no current proposals to implement such a card and previous proposals have met with opposition from various quarters.

    A further issue is that name and address data ages over time. People move house, get married, get divorced or die. What mechanism will the Government require to ensure that the information registered on the Register of Mobiles is maintained accurately and in a form that meets or exceeds the evidentiary requirements of the legal system? This is not an issue for bill Pay phones as if the bill ceases to be paid the phone is cut off… and if the bill is still being paid but the address is no longer valid the Authorities have other investigative avenues open to them (such the payment records). For ‘ready-to-throw’ mobiles this is and will be a critical problem. Not only can the person move address, but the phone may ‘move person’ by being swapped, loaned or shared between family members (this may happen with bill pay phones but it is reasonable to assume that in the case of a bill pay phone the ‘sharing’ or ‘lending’ of the phone would be temporary).

    Currently we have a very important national register of people which is collated and maintained for a very serious and important function in the operation of the State. It’s called the Electoral Register and, not to put too fine a point on it, it has some ‘issues’ with the quality of the information there-in and the levels of duplication and inaccuracy in the data. What confidence should we have that the Government will have learned the lessons of the Electoral Register in the design and implementation of any new Register of Mobiles?

    I am not saying we should not require registration of pre-pay mobile phones (all operators currently encourage registration through ‘free credit’ bribes). However if we are to require citizens to give up elements of personal privacy and provide information about their mobile phone usage to State Agencies then it is essential that the system work as it is intended it will and that the information captured meets or exceeds the expectations of the politicians, the police and, most importantly, the citizen. Crucially this must happen with out the information captured being excessive or irrelevant to the stated purposes for registration.

    If we require people to provide information into a system and set of processes that will eventually degrade into an unmanaged cacophony of inaccurate, incomplete, inconsistent and otherwise just plain awful data rather than a symphony of polished, reliable and policed information then we will have achieved nothing other than a layer of paperwork and a burden on mobile phone operators and their customers. Those with criminal intent will pervert the system – foreign SIMS, imported phones, stolen phones etc.

    By definition they don’t play by the rules.

  • Electoral Register issues

    Astute followers of the recent General Election in which there were a number of reports of problems with our national electoral register will doubtless be wondering where my comments on that issue might be.

    Rest assured that I haven’t forgotten about it and am working on collating the media reports of issues and tracking down other substantiated cases of problems with the electoral register. I will be producing an updated analysis of the likely root causes which I will publish here and over at the IQ Network website (www.iqnetwork.org). I may even get around to doing a presentation on it to the IQ Network in the coming months.

    Suffice it to say the issues are both simple and complex and the likely scope of root causes ranges from a failure of governance from Government, the lack of a clear strategy for improving the quality of the register, a reliance on scrap and rework to ensure accuracy (doomed from the beginning) and also the actions or inactions of key people in the voter registration and verification processes (including the public).

    Updates to come soon.

  • E-Voting debacle… but not in ireland (!)

    A few hours ago the Chief Electoral Officer for Northern Ireland Douglas Bain, announced that electronic voting would be considered for future elections in Northern Ireland as a result of what he had seen in Scotland where e-voting was used this week for elections.

    Fast forward to now… the Scottish election is in a state of disarray given the failure of their electronic voting system. Problems were also reported in Northern England.

    Perhaps they should have stuck to pencils and paper and avoided this embarassment?

  • Election Constituencies

    Update from McGarr Solicitors

    McGarr Solicitors have just posted an update on the Constitutional challenge to the Electoral boundaries. The case, which was to be heard today, has been adjourned on request of the Defendants. The case is now to belisted for mention again next Tuesday (8th May).

    Perhaps I am overly cynical and maybe I’m jumping at shadows but I do find it an interesting co-incidence that the Defendants sought the adjourning of this case from the day that Fianna Fail were launching their election manifesto.

    Perhaps I am seeing ill motive in otherwise innocent action given that this adjourment coincides with a week in which the Government parties have been on the back foot and have seen headline after headline tumbling out that make important things like winning an election tricky.

    Certainly it would have made life tricky for Government TDs to focus on the manifesto soundbites on the evening news if all the journos wanted to talk about was a court case about whether they had dropped the ball on protecting democracy.

    Those constituencies that are under represented based on the Census figures should consider their own version of ‘Rock the Vote’ to the tune of the classic Dire Straits track “Money for Nothing”…

    I want one more TD

    Now that I think of it, that song is eminently appropriate given the lack of clarity about the Taoiseach’s financial affairs… which may indeed be perfectly legitmate and above board. He’s just not doing a good job of convincing people that that is the case.

  • For the avoidance of doubt…

    The first bit of doubt

    Various Dell representatives have explained to me my problem as being one of how my graphics card uses hypermemory. However that doesn’t resolve the issue that I the option I selected when building my machine was for a card with 256MB dedicated video RAM – the fact that it could use hypermemory to extend that further was irrelevant.

    Screenshot of my graphics card properties.

    For the avoidance of doubt I’ve uploaded a screenshot of the properties of the graphics card from the ATI administration utility. Maybe I’m reading it wrong but it sure looks like a 128MB graphics card to me, hypermemory or no hypermemory.

    The other bit of doubt

    As some of you may know, I do the odd bit of teaching and guest lecturing at a university in Dublin City (rearrange the words to figure out which one). There’s another member of staff there who, lucky person that he is, shares a variant of my name. By variant I mean that the name is phonetically and aurally identical but there are a few small differences.

    • Dr. Darragh O’Brien uses his title (hard earned and well deserved) which is a title I don’t have (I’m just a pretender at this whole ‘knowing academic things’ it would seem).
    • Dr. Darragh spells his name with 2 ‘r’s. I don’t.
    • He uses an apostrophe in his surname (O‘Brien) where as I don’t)

    This is important as Dell just emailed him and phoned him trying to get in contact with me. The waves of surrealism are lapping harshly on the shores of my patience at this stage. Thankfully Dr. D (as I will refer to him to avoid confusion) forwarded me the email he got which I’ve responded to. He’s used to it – the Admin team in the particular faculty had him listed to teach my class for a while on the on-line course tools.

    I’m am heartily impressed that Dell went to the trouble of going to the university website and looking up contact details for me… I mean him… I mean me… …. drat, now even I’m confused. Particularly as they already had my personal email address in the email correspondence I’ve had and associated with my order and the support cases I’ve raised.

    All of which made me decide to dig out an old slide I use in presentations on Information Quality that shows why I got interested in the issue in the first place.
    Why i got into information quality

    For those of you who can’t use the powerpoint viewer here, I’ve converted the slide to a gif for your viewing pleasure.
    Why I got into IQ slide gif

    Dr. D — If you’re reading this thanks for the email forward and I hope you find my slide ‘amusing’.

  • Better late then never..

    RTE today have a story about the changing demographics revealed by the Census.

    This story mentions specifically the possible need for an additional TD in Dublin West as a result of the 8000 population growth in the area that the Census shows.

    RTE have, unfortunately, failed to point out the other constituencies that are under represented and the half-dozen or so that are over represented. They do, however, make the point that the cities in Ireland (of which there are only 5) have lost population share to other areas…

    Of course this information was available in the public domain since the 29th of March and forms the basis of the Constitutional challenge to the Electoral constituency boundaries (or rather the failure of the Government to rework those boundaries in light of the census data).

  • Electoral Constituencies…

    Interesting developments (well developments at least) over in the Hight Court…

    The Constitutional challenge to the Electoral boundaries will be heard next week. This isn’t really news to those of us who have been keeping an eye on mcgarrsolicitors over the past few weeks.

    What does it mean? Well it means that any chance of calling an election this side of the middle of May is shot to hell – rumours of emergency legislation not with standing.

    I wonder what Noel Whelan of Irish Times fame makes of this attempt by citizens to exercise not just their right of free speech but also their right to have a proportionally representative election? As a barrister, political pundit and a former political organiser with Fianna Fail (see his biog at this LINK) I’m sure he’d have an opinion to express.