• July 22nd, 2019
Login / Register

A Clean Record


Llewellyn le Hané We have all been there. Trying to add someone’s contact details to your phone only to see that the SIM or the phone memory is full. Now comes the painful decision… ‘who do I delete, so this new contact can be saved?’ Only to realise that while scrolling through your contact list you have a multitude of duplicates in your phone taking up valuable memory space. It started me thinking. If my private phone with a couple of hundred contacts already has duplicates and multiple entries for the same person, how do companies, the government and large institutions keep the contact details of their stakeholders or customers and clients clean? What happens when someone passes away, does their data immediately get wiped from the system, or do they continue to receive letters, invoices or perhaps payments? Does each organisation have a singular method of inputting contact details and does everyone in the organisation adhere to this method. As I again look at my phone, I see my mother has a massive five entries for the same phone number with names ranging from Mum, Grandmother. I freed up for spaces in my phone by simply using one version of her name from now on. Within the public and private ICT sector, it is actually called Cleaning Data. This challenge of keep information clean and unduplicated is essential. Imagine a large organisation with perhaps one million or more entries of contact data on their systems. They need to be able to find a person’s details within seconds rather than minutes and certainly hours. This of course cannot be done manually, as it would be an all-consuming task that would take hundreds of people. There is actually software that helps with this. It keeps data clean and by simply creating ‘Rules’ that the inputted data has to adhere to, it stays clean and usable for the organisation and employees. If the data inputted does not adhere to the ‘Rules’, it simply does not make its way into the database.  Mistakes are easily made and different people approach entering contact details for someone in different ways. Different branches of the same company might already approach data entry in different ways. For example, first names in last name fields and vice versa, phone numbers in email fields or using a nickname or simply not having all the necessary data. The permutations of filling in someone’s contact details are endless.  This, however, is how data becomes tainted and incomplete and inaccurate. It means when you are trying to contact someone or send out a letter, just like my five entries for my mother, you may have five duplicates. Imagine the expense of sending out the same letter to one person who appears in five different ways in a database. So, an essential principle for clean databases is one record per customer. The more duplicates you have, the less effective any of your stakeholder communication will be. Even more costly and potentially open to fraud, abuse and corruption is the appearance of non-existent people in your databases. Imagine having people on the payroll that left the company months or years ago. Or as happened recently right here in Namibia, uncovering several ‘ghost teachers’, that were on a payroll, but did not actually exist, but did receive a salary. Strict policies on data entry and upkeep ensures there is less chance of fraud, malfeasance and detection if any fraud is being attempted.  Keeping your data clean is a continuous process and at the very basis of customer relationship management and stakeholder engagement at all levels. It is also not just something that technically innovative organisations should be doing. Every organisation with a database needs to embrace clean data. Just remember how embarrassed you get when you send a text or a WhatsApp message to someone by mistake, because you did not differentiate between the two Jonathans in your address book. Keeping your phone data clean is worth the time and effort and in organisations keeping your data clean is not just worth your time and effort it will improve your business processes and probably save the company money. Llewellyn le Hané is the Director of Green Enterprise Solutions
New Era Reporter
2018-01-05 09:38:48 1 years ago

Be the first to post a comment...

You might also like...