Skip to Content
Author's profile photo Former Member

Why doesn’t my system work? Your data is rubbish!

How many times have you heard the users complain that the system doesn’t work?  Then when you investigate you find that a key piece of data is missing and the whole process failed as a result.  This is a common occurrence; many times the system gets blamed for what is a data problem.

How do you fix this?  The answer is multi-faceted – with four major steps.


  1. Make sure there is an owner for the data, someone who takes responsibility for the completeness, consistency, conformity and accuracy of the data.
  2. Make sure it is clear what the standards and business rules are that the data needs to conform too.  Ensure the people who are entering the data know what is required of them.
  3. As far as practicable, get the system to enforce these standards and rules at time of data entry.
  4. Set up the appropriate monitoring, reporting to identify problems with the data and then take the actions required to fix the problem and prevent the problems from occurring again.

Sounds easy, doesn’t it?  However, as people know it is far from easy and requires people who are dedicated to getting the data right.  Part of the answer is to ensure DATA has its own stream in the ERP implementation and that it is handled by people who are experts in data.  They need to understand data migration, data quality and how the data is going to get used in the new ERP system.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Luke Marson
      Luke Marson
      I often find that a visulization tool such as SAP Org Visualization by Nakisa OrgChart often identifies bad data very easily.

      But how often have I heard "it's displaying my dara wrong!". Actually, your data IS wrong!

      Author's profile photo Former Member
      Former Member
      With HR/Payroll projects I tell clients all the time that good data lead to a good payroll. We can have the best calculations in place, but if we get garbage in, we will have garbage coming out. Your points about data are insightful - thanks!
      Author's profile photo muthuraman govindasamy
      muthuraman govindasamy
      most of the issues due to master data set up wrong. Master data team must be strong and should knew the impacts in all business objects which is related.