{"id":2029,"date":"2020-08-26T00:00:49","date_gmt":"2020-08-25T22:00:49","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=2029"},"modified":"2023-05-24T09:43:01","modified_gmt":"2023-05-24T07:43:01","slug":"bix-ai-tools-fallbeispiel-stammdatenoptimierung","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/bix-ai-tools-fallbeispiel-stammdatenoptimierung\/","title":{"rendered":"biX AI Tools - Case study: Master data optimisation"},"content":{"rendered":"

[et_pb_section fb_built=“1″ _builder_version=“4.16″ _module_preset=“default“ custom_padding=“4px|||||“ border_color_bottom=“#e08a00″ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

biX Consulting examined the quality and distribution of master data for a provider of fuel and toll invoices. In the case described, 30,000 German number plates, which were directly available in SAP BW, were to be checked for quality, as they were entered manually in the source system. Since a manual check is too time-consuming, the quality was assessed by examining the similarity of the number plates to each other.<\/p>\n

For this purpose, the labels were abstracted in a feature engineering in order to consider only the sequences of numbers, letters and special characters. For example, \"ME AB 123\" became \"AA AA 111\". This made it possible to combine the licence plates into groups of identical character sequences. The size of these groups and their similarity to each other were then visualised using a machine learning algorithm. In the visualisation, similar groups of labels were close to each other.<\/p>\n

 <\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_image src=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/10\/bix_ai_tools_stammdatenoptimierung.png“ title_text=“bix_ai_tools_stammdatenoptimierung“ _builder_version=“4.19.5″ _module_preset=“default“ hover_enabled=“0″ global_colors_info=“{}“ theme_builder_area=“post_content“ alt=“Verteilung aller Kennzeichengruppen und ihre Gr\u00f6\u00dfe (Darstellung in Tableau Desktop)“ sticky_enabled=“0″][\/et_pb_image][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_text_color=“#a0a0a0″ text_font_size=“12px“ hover_enabled=“0″ global_colors_info=“{}“ theme_builder_area=“post_content“ sticky_enabled=“0″]<\/p>\n

Distribution of all indicator groups and their size (visualisation in Tableau Desktop)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

The visualisation showed that there were several hundred indicator groups that varied greatly in their characteristics and of which many combinations, such as A!!A-111A or A-AAAAA-AAA, were invalid.<\/p>\n

[\/et_pb_text][et_pb_image src=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/10\/bix_ai_tools_stammdatenoptimierung2.png“ title_text=“bix_ai_tools_stammdatenoptimierung2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_text_color=“#a0a0a0″ text_font_size=“12px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

 <\/p>\n

Highlighting of some indicator groups with their character strings (display in Tableau Desktop)<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.6em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

After a quick analysis, the direct further use of the master data could therefore initially be ruled out due to the lack of quality.<\/p>\n

However, the grouping and visualisation offer good prerequisites for subsequent use cases. For example, for training scenarios in the machine learning environment, the data can be grouped much more quickly and labelled as correct or incorrect.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“30px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

Contact Person<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/08\/Oliver-Ossenbrink-e1598705178874.png“ align=“center“ _builder_version=“4.16″ _module_preset=“default“ transform_translate=“-4px|22px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“16px“ transform_translate=“-3px|30px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

\n
\n

Oliver Ossenbrink<\/h3>\n<\/div>\n<\/div>\n
\n
\n

Management of sales and HR<\/p>\n<\/div>\n<\/div>\n

[\/et_pb_text][et_pb_social_media_follow _builder_version=“4.16″ _module_preset=“default“ transform_translate=“0px|33px“ transform_translate_linked=“off“ text_orientation=“center“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_social_media_follow_network url=“mailto:oliver.ossenbrink@bix-consulting.de?cc=info@bix-consulting.de“ _builder_version=“4.16″ _module_preset=“default“ background_image=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/08\/E-Mail.png“ background_enable_image=“on“ background_size=“contain“ global_colors_info=“{}“ theme_builder_area=“post_content“ follow_button=“off“ url_new_window=“on“][\/et_pb_social_media_follow_network][\/et_pb_social_media_follow][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"

biX Consulting hat f\u00fcr einen Anbieter von Tank- und Mautabrechnungen Stammdaten auf Qualit\u00e4t und Verteilung untersucht. Im dargestellten Fall sollten 30.000 deutsche\u00a0Kfz-Kennzeichen, die direkt im SAP BW vorlagen, auf Qualit\u00e4t gepr\u00fcft werden, da sie h\u00e4ndisch im Quellsystem erfasst wurden. Da eine manuelle Pr\u00fcfung zu aufwendig ist, wurde die Qualit\u00e4t durch eine Untersuchung der \u00c4hnlichkeit der […]<\/p>","protected":false},"author":6,"featured_media":980,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[18],"tags":[154,158,163,43,39,26,156,45,29,30,31,48,40,155,162,38,27,44,41,50,28,42,49,46,47,107,165,157,82],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2029"}],"collection":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=2029"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2029\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/980"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=2029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=2029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=2029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}