Most time for data quality

When informatici begin at a business-intelligence (BI)-project, then study they first the documentation of the data boss in question. about which data sees to one” How are they raised in tables and columns” They go also after or the data source filled in be, and correct filled in be or they. For instance, by an analysis of the clientsdata appeared often that the facturatieaddress source correct is, but that the fields 'occupation' and 'humans composition' not filled in are, whether they the value contain that on the screen of the user as first appeared in the choice list. Also as the customers self their data fill in, via a paper form or a form on a webpage, is the chance large that the data incomplete are. Or double, when the customer was found of already in the data boss.

Only there yet other scenarios are that lead till faulty data quality. Let us assume that the software application do not satisfies for the assimilation of data at the wishes of the users. Let us assume that they absolutely a particular type given want to fill in, but that before no field foresee is. Then they use before normally someone else field. This comes as source for by package software, that not or only with high expenses can be changed, if by measure software, that the programmers not good know and therefore dare not change. The appointments about the use of the fields are passed mostly normally oral and nowhere gedocumenteerd.

Supply Chain Management

Also in the domain Supply Chain Management, one stumbles about erroneous data. This is also the experience of B and M Consulting, specialized in kostprijscalculatie, budget tuberculosis and planning, financile rapportering, strategy and Balanced Scorecard. Kris Morales, Partner by B and M Consulting: 'We regularly erroneous data discover. Sometimes one goes wrong code ring. Sometimes arises the problem because the business sees to about two different and aboutlapping applications. Users spend have to lead often only the data in that they self necessarily their branches. For instance, a software application for supply management offers to give raised becomes the possibility at on what child of type pallet each product. That value mostly also is filled in, for the user has that necessarily. In the ERP-application on the other hand becomes not not this field filled in, and can one thus in the rear often these landlords use by analyses.'

Morales yet single examples gives: 'A business a route planning application uses has been filled in, then in that the address of the customer certainly correct. In someone else application on the other hand, can the post number once in a while wrong be. Sometimes also we find an order in a sale application for a particular product, while this product in the 'product master line' in someone else application on nun-active state. We discover analyze these problems when we the data. We do not obetain succeeds to find (matching) statistics that are clear wrong, or our application there in the corresponding data in two applications.'