Archive for the ‘Preventative Data Quality’ Category

What do the world’s largest eCommerce sites say about you and your products?

Thursday, November 4th, 2010

With websites rapidly becoming the shop window, and shop floor, for many retail outlets how do suppliers know their products are properly represented and described on the endless array of eCommerce sites that customers use in the 21st century?


The term “looking for a needle in a haystack” comes to mind; some retailers and eCommerce sites have so many products listed it impossible to find, let alone keep track of what they are all saying about your products. Is the product description correct or even close to it? Are the dimensions right? Are all the appropriate nutritional statements or product warnings clear and accurate?


Suppliers put a lot of effort into getting all this information clear and accurate on their product packaging. But online shoppers aren’t able to physically see and hold the products to read packaging information before they buy. The data as presented by the online retailer is their only guide and if some of the data is missing, incomplete or incorrect it can cause problems. Missing or incomplete data is like the online equivalent of a store out-of-stock, resulting in missed sales opportunities. At the same time if the data is incorrect it can lead to an increase in the number of complaints and unwanted returns.


(more…)

Data Quality: Is Right First Time the Right Way to go?

Monday, January 25th, 2010

The new KPI (key performance indicator) for data quality is “Percent Right First Time”. Organizations have recognized that strategic data quality initiatives should focus on avoiding data errors rather than fixing them.

Right First Time is the core philosophy underlying Clavis Data Quality Steward and so it’s something that we talk about on a daily basis – but the other day an experienced data quality practitioner challenged me on whether Right First Time was  really a realistic objective. He questioned it on two levels: Firstly, can data be defined as ‘right ’ or ‘wrong’. After all isn’t it true that data can be right for one use case, but wrong for another. For example a product length expressed in millimetres to two decimal places may be right for use in a European sales application, but wrong for use in a US engineering application where inches may be more appropriate. Isn’t the proper measure of data quality “fit for purpose,” he asked. (more…)

Preventative Data Quality: Vaccinating against the virus

Tuesday, November 3rd, 2009

All over the world governments are hurriedly stockpiling quantities of vaccine against the H1N1 Virus. They are doing this because the medical profession understands that when it comes to stopping viruses, prevention is by far the best strategy. The benefits of disease prevention – over cure – are many:

  • There is no recovery time for people who are vaccinated so the economic cost for a country in terms of lost work days and medical treatment is largely eliminated.
  • The risk of serious illness or death from the H1N1 virus is very real while there is negligible risk associated with the vaccine.
  • If the vaccine strategy is executed effectively, i.e. at the earliest time, then the spread of the disease will be contained in smaller areas and the number of people affected in any way will be minimized.
  • There are very strong parallels in the world of data and data quality:

  • The economic cost of “recovery time” for people who contract a virus is equivalent to the cost of rework or fixing bad data once it has entered a business’ IT system. These costs can be huge.
  • Ok it would be very rare or, though not unknown, for people to die from bad data, but the risk of business failure is high. While catastrophic failure of a business due to data quality is thankfully also fairly rare, almost all companies today suffer from multiple ongoing, day-to-day problems and inefficiencies caused by low quality. It’s a bit like a persistent cold which stops your business performing at its best.
  • The parallels between the spread of a virus through a community and the spread of bad data through a company’s IT systems are also very strong. One of the big challenges with data is a single data error in a single system can quickly become multiple data errors in multiple systems. And as more systems are connected and integrated for real time data sharing this problem grows exponentially.
  • View bad data as millions of potential viruses threatening your business – and work on your prevention strategy.