Change of address A customer changes

[rahim]

His address or his last name due to marriage and does not report this. Combining multiple address databases: Customer addresses are managed in different tables and/or systems. For better market processing, the addresses are transferred to a common database. If this is not done properly, duplicates or incomplete data sets can arise. The consequences resulting from poor data quality are problems with addressing, personal customer contact and automated processes.

This can lead to higher costs, angry customers and distorted DB to Data analysis results. In order to avoid making the wrong strategic decisions due to poor data quality, awareness of the importance of data quality should be created in your company and among your employees. How to find and clean up duplicates in your customer base Poor data management can, among other things, lead to a large number of duplicates. A duplicate is a record in a database that occurs multiple times.



You can identify duplicates using appropriate software and clean them up automatically or semi-automatically. When comparing duplicates, more or less sharp phonetic, pattern-related or associative algorithms are used. Standardizing notations can lead to even better results. If an algorithm is only focused on the exact match of data, the address “Paul Klee Strasse 111” will not be found as a duplicate of “Klee Strasse 111”. Which methods you should use when comparing duplicates depends largely on your data base.