{"id":170,"date":"2021-01-28T10:26:20","date_gmt":"2021-01-28T09:26:20","guid":{"rendered":"http:\/\/www.billing.co.at\/test\/?page_id=170"},"modified":"2021-04-15T15:33:33","modified_gmt":"2021-04-15T14:33:33","slug":"technical-execution","status":"publish","type":"page","link":"https:\/\/www.billing.co.at\/en\/services\/data-quality-management\/technical-execution\/","title":{"rendered":"Technical execution"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-171 aligncenter\" src=\"https:\/\/www.billing.co.at\/de\/wp-content\/uploads\/2014\/11\/datamigration2_small.jpg\" alt=\"Technical execution\" width=\"259\" height=\"259\"><br \/>\n<strong><span style=\"color: green;\">1. Analyses and planing<\/span><\/strong><\/p>\n<ul>\n<li>Definition of data requirements and targets<\/li>\n<li>Analyse the current situation, discover potneital data issues<\/li>\n<li>Plan the data cleansing approach<\/li>\n<\/ul>\n<p><strong><span style=\"color: green;\">2. Restructuring<\/span><\/strong><\/p>\n<ul>\n<li>Check field values<\/li>\n<li>Split field values if required<\/li>\n<li>Correct field values<\/li>\n<li>Harmonise field values<\/li>\n<li>Relationalising the databases<\/li>\n<\/ul>\n<p><strong><span style=\"color: green;\">3. Upper\/lower case transformation<\/span><\/strong><\/p>\n<ul>\n<li>Uppercase notation will be converted into mixed upper\/lower case notation. &#8220;JBS JENAER BUEROSYS LTD&#8221;&nbsp;becomes &#8220;JBS Jenaer B\u00fcrosys Ltd&#8221;<\/li>\n<\/ul>\n<p><strong><span style=\"color: green;\">4. Postal corrections (national | international)<\/span><\/strong><\/p>\n<ul>\n<li>Correction of false written street and city\/town and county&nbsp;names, state names<\/li>\n<li>Synchronisation of postcode, town and street<\/li>\n<li>Generation of missing post codes<\/li>\n<\/ul>\n<p><strong><span style=\"color: green;\">5. Duplicate-cleansing<\/span><\/strong><\/p>\n<ul>\n<li>Duplicate addresses&nbsp;will be dicsovered using a method of similarity even notation is different<\/li>\n<li>Generation of allocation maps<\/li>\n<\/ul>\n<p><strong><span style=\"color: green;\">6. Data migration<\/span><\/strong><\/p>\n<ul>\n<li>The cleansed data will be migrated into the data model of the target system<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. Analyses and planing Definition of data requirements and targets Analyse the current situation, discover potneital data issues Plan the data cleansing approach 2. Restructuring Check field values Split field values if required Correct field values Harmonise field values Relationalising the databases 3. Upper\/lower case transformation Uppercase notation will be converted into mixed upper\/lower case notation. &#8220;JBS JENAER BUEROSYS LTD&#8221;&nbsp;becomes &#8220;JBS Jenaer B\u00fcrosys Ltd&#8221; 4. Postal corrections (national | international) Correction of false written street and city\/town and county&nbsp;names, state<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":119,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-170","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/pages\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/comments?post=170"}],"version-history":[{"count":16,"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/pages\/170\/revisions"}],"predecessor-version":[{"id":880,"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/pages\/170\/revisions\/880"}],"up":[{"embeddable":true,"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/pages\/119"}],"wp:attachment":[{"href":"https:\/\/www.billing.co.at\/en\/wp-json\/wp\/v2\/media?parent=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}