{"id":12134,"date":"2021-08-16T13:38:14","date_gmt":"2021-08-16T13:38:14","guid":{"rendered":"http:\/\/ismiletechnologies.com\/?p=12134"},"modified":"2022-10-06T17:17:12","modified_gmt":"2022-10-06T11:47:12","slug":"masterdata-management","status":"publish","type":"post","link":"https:\/\/ismiletechnologies.com\/en_us\/cloud-services\/masterdata-management\/","title":{"rendered":"Masterdata Management"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Masterdata Management; Matching,&nbsp;Merging,&nbsp;Normalisation, Consolidation<\/strong>&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data of an organization generally includes&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Unstructured data found in emails, intranet portals, product files carrying specifications, collaterals and more.&nbsp;<\/li><li>Transactional data- Data like shipping documents, invoices orders, credit card payments, insurance claims and others&nbsp;<\/li><li>Metadata- It is the data about the other data of the&nbsp;organisations&nbsp;generally xml files, configuration files, logs&nbsp;etc&nbsp;<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Hierarchical data- Those data of the organization which are in parent child relationship in the organization data tree&nbsp;<\/li><li>Reference data \u2013 A special type of data that is used to&nbsp;categorise&nbsp;and index other data&nbsp;<\/li><li>Master data- the data around which the core business is connected&nbsp;<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The four main domains of master data include&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Customers, products, locations, warranty licenses&nbsp;etc&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Masterdata management encompasses tools, technologies and procedures that enable coordination of Masterdata along the entire enterprise. The two most important functions for Masterdata management&nbsp;are&nbsp;matching master data and merging them&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are various methods of matching data that can be accomplished by automation on pre-defined rules and passing the uncertain data through a review process&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Exact Match- Exact Match depends on linking two different sets of data with the help of a common key or match identity like national identification number or a barcode encoding the item number.&nbsp;<\/li><li>Phonetic Match- This is usually employed for those data which can not be matched by exact match. This is generally applicable to data which have been inputted manually or through&nbsp;voice-based&nbsp;input methods. For example,&nbsp;recording customer name at point of sales. We generally include phonetic algorithms like Soundex in databases like SQL or&nbsp;Postgress&nbsp;<\/li><li>Fuzzy Match- This involves matching users when&nbsp;other&nbsp;criteria match. That is the items falling within a certain radius of match is considered to be same. This is not very exact way of matching. It helps in greater coverage of data matching but accuracy is least in all the types of matching&nbsp;<\/li><li>Negative Match- It requires some extra conditions which if not met the data shouldn\u2019t be matched. They are used for excluding an unlikely event.&nbsp;<\/li><\/ul>\n\n\n\n\n\n\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"33253\" class=\"elementor elementor-33253\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1f27ef0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f27ef0\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c65c317\" data-id=\"c65c317\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-dc3c880 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc3c880\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-3248be5\" data-id=\"3248be5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5886bd6 elementor-widget elementor-widget-heading\" data-id=\"5886bd6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Ready to experience the full power of cloud technology?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f56c4e elementor-widget elementor-widget-text-editor\" data-id=\"1f56c4e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span class=\"TextRun Highlight SCXW216552313 BCX0\" lang=\"EN-IN\" xml:lang=\"EN-IN\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW216552313 BCX0\">Our cloud experts will speed up cloud deployment, and make your business more efficient.\u00a0<\/span><\/span><span class=\"EOP SCXW216552313 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-4b7dd61\" data-id=\"4b7dd61\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-81f081a elementor-align-center elementor-widget elementor-widget-lottie\" data-id=\"81f081a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;source&quot;:&quot;external_url&quot;,&quot;source_external_url&quot;:{&quot;url&quot;:&quot;https:\\\/\\\/assets4.lottiefiles.com\\\/packages\\\/lf20_kkesf8mx.json&quot;,&quot;is_external&quot;:&quot;&quot;,&quot;nofollow&quot;:&quot;&quot;,&quot;custom_attributes&quot;:&quot;&quot;},&quot;loop&quot;:&quot;yes&quot;,&quot;play_speed&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:0.9,&quot;sizes&quot;:[]},&quot;lazyload&quot;:&quot;yes&quot;,&quot;link_to&quot;:&quot;none&quot;,&quot;trigger&quot;:&quot;arriving_to_viewport&quot;,&quot;viewport&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:{&quot;start&quot;:0,&quot;end&quot;:100}},&quot;start_point&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:0,&quot;sizes&quot;:[]},&quot;end_point&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:100,&quot;sizes&quot;:[]},&quot;renderer&quot;:&quot;svg&quot;}\" data-widget_type=\"lottie.default\">\n\t\t\t\t\t<div class=\"e-lottie__container\"><div class=\"e-lottie__animation\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-ac6262c\" data-id=\"ac6262c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e19f719 elementor-align-right elementor-mobile-align-left elementor-tablet-align-right elementor-widget elementor-widget-button\" data-id=\"e19f719\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-xs\" href=\"#elementor-action%3Aaction%3Dpopup%3Aopen%26settings%3DeyJpZCI6IjI5OTEiLCJ0b2dnbGUiOnRydWV9\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Start Today !<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Matching and&nbsp;Merging data; Essentials to be considered<\/strong>&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Name frequency for merging- While matching and merging name data, one should take into consideration the frequency of the names.&nbsp;Frequent names need to be validated at higher levels before they are match. There may be 50K Alex in US but 1 or fewer&nbsp;karadas. The burden of validation is more in the prior case.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Languages- One entity can have multiple representation in different languages&nbsp;<\/p>\n\n\n\n\n\n<p class=\"wp-block-paragraph\">Abbreviations- One entity can have different abbreviations. For example,&nbsp;Sam for Samuel, Rose for Rosalyn and so on&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are many other numeric, strings and variables consideration to be taken while matching and merging data&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After matching and merging the third step is data cleansing and normalisation, then data consolidation and finally putting data into production.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Masterdata Management; Matching,&nbsp;Merging,&nbsp;Normalisation, Consolidation&nbsp; Data of an organization generally includes&nbsp; Unstructured data found in emails, intranet portals, product files carrying specifications, collaterals and more.&nbsp; Transactional data- Data like shipping documents, invoices orders, credit card payments, insurance claims and others&nbsp; Metadata- It is the data about the other data of the&nbsp;organisations&nbsp;generally xml files, configuration files, logs&nbsp;etc&nbsp; [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":12488,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[81],"tags":[],"class_list":["post-12134","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-services"],"_links":{"self":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/comments?post=12134"}],"version-history":[{"count":5,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12134\/revisions"}],"predecessor-version":[{"id":33669,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12134\/revisions\/33669"}],"wp:attachment":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media?parent=12134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/categories?post=12134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/tags?post=12134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}