Data preparation for MDM system

In the first step, an MS Access database is created, which is used as an import buffer, problem visualization and for data transformation. The Excel data and the relevant SQL Server inventory data are read into this application and can be sorted, filtered or queried according to criteria using the MS Access basic options. This problem visualization process can be used to identify data deviations with system support that cannot be recognized automatically (e.g. an object that is technically the same but with different spellings, spaces, etc.). In addition to the user's manual options, automated assignments of key values such as the personnel number are carried out – if the data structures allow it.