{"id":2800,"date":"2021-01-28T20:39:58","date_gmt":"2021-01-28T19:39:58","guid":{"rendered":"https:\/\/plugandbet.com\/datenharmonisierung\/"},"modified":"2021-06-11T16:30:38","modified_gmt":"2021-06-11T14:30:38","slug":"data-harmonization","status":"publish","type":"post","link":"https:\/\/plugandbet.com\/en\/data-harmonization\/","title":{"rendered":"Data harmonization"},"content":{"rendered":"[et_pb_section fb_built=”1″ _builder_version=”4.9.0″ background_color=”RGBA(0,0,0,0)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false”][et_pb_row _builder_version=”4.9.0″ background_color=”RGBA(0,0,0,0)” background_size=”initial” background_position=”top_left” background_repeat=”repeat” width=”100%” custom_margin=”||0px||false|false” custom_padding=”0px||10vh||false|false”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.9.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]

How we tamed a data monster and locked it into a slick dashboard.<\/h2>\r\n

<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default” background_color=”RGBA(0,0,0,0)” width=”100%” custom_padding=”0px||||false|false”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ sticky_enabled=”0″]

The problem.<\/h3>\r\n

<\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]

An international company was having difficulty accounting for sales reported by customers because there was no standard format for sales reports and each report was structured differently.<\/p>\r\n

<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default” width=”100%”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]

The solution.<\/h3>\r\n

<\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]

We analyzed the entire process, developed a browser-based solution for the different sales reports that feeds them into a central database and at the same time manages plausibility checks of the reported sales. Using a business intelligence tool available on the market, we developed a dashboard for the management that displays the reported sales in a structured manner.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.0″ _module_preset=”default” width=”100%”][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]

The result.<\/h3>\r\n

<\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ sticky_enabled=”0″]

The customer is now able to record sales more quickly as well as provide analyses of the various markets and product movements. The process as a whole is now streamlined and management has 24\/7 access to up-to-date data.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]","protected":false},"excerpt":{"rendered":"

How we tamed a data monster and locked it into a slick dashboard.<\/p>\n","protected":false},"author":1,"featured_media":2441,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[3],"tags":[],"dipi_cpt_category":[],"class_list":["post-2800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-projects"],"yoast_head":"\nData harmonization - Plug & Bet<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/plugandbet.com\/en\/data-harmonization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data harmonization - Plug & Bet\" \/>\n<meta property=\"og:description\" content=\"How we tamed a data monster and locked it into a slick dashboard.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/plugandbet.com\/en\/data-harmonization\/\" \/>\n<meta property=\"og:site_name\" content=\"Plug & Bet\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-28T19:39:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-11T14:30:38+00:00\" \/>\n<meta name=\"author\" content=\"topfmaler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"topfmaler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/\"},\"author\":{\"name\":\"topfmaler\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/#\\\/schema\\\/person\\\/c857e0c2048f17d9b3433cc678f74517\"},\"headline\":\"Data harmonization\",\"datePublished\":\"2021-01-28T19:39:58+00:00\",\"dateModified\":\"2021-06-11T14:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/\"},\"wordCount\":471,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/plugandbet.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/datenharmonisierung-01-1.svg\",\"articleSection\":[\"Projects\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/\",\"url\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/\",\"name\":\"Data harmonization - Plug & Bet\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/plugandbet.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/datenharmonisierung-01-1.svg\",\"datePublished\":\"2021-01-28T19:39:58+00:00\",\"dateModified\":\"2021-06-11T14:30:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/#\\\/schema\\\/person\\\/c857e0c2048f17d9b3433cc678f74517\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#primaryimage\",\"url\":\"https:\\\/\\\/plugandbet.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/datenharmonisierung-01-1.svg\",\"contentUrl\":\"https:\\\/\\\/plugandbet.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/datenharmonisierung-01-1.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/data-harmonization\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/plugandbet.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data harmonization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/\",\"name\":\"Plug & Bet\",\"description\":\"Wir sind die Unternehmensberatung mit Anpack.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/plugandbet.com\\\/de\\\/#\\\/schema\\\/person\\\/c857e0c2048f17d9b3433cc678f74517\",\"name\":\"topfmaler\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g\",\"caption\":\"topfmaler\"},\"sameAs\":[\"https:\\\/\\\/plugandbet.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data harmonization - Plug & Bet","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/plugandbet.com\/en\/data-harmonization\/","og_locale":"en_US","og_type":"article","og_title":"Data harmonization - Plug & Bet","og_description":"How we tamed a data monster and locked it into a slick dashboard.","og_url":"https:\/\/plugandbet.com\/en\/data-harmonization\/","og_site_name":"Plug & Bet","article_published_time":"2021-01-28T19:39:58+00:00","article_modified_time":"2021-06-11T14:30:38+00:00","author":"topfmaler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"topfmaler","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#article","isPartOf":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/"},"author":{"name":"topfmaler","@id":"https:\/\/plugandbet.com\/de\/#\/schema\/person\/c857e0c2048f17d9b3433cc678f74517"},"headline":"Data harmonization","datePublished":"2021-01-28T19:39:58+00:00","dateModified":"2021-06-11T14:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/"},"wordCount":471,"commentCount":0,"image":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#primaryimage"},"thumbnailUrl":"https:\/\/plugandbet.com\/wp-content\/uploads\/2021\/01\/datenharmonisierung-01-1.svg","articleSection":["Projects"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/plugandbet.com\/en\/data-harmonization\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/","url":"https:\/\/plugandbet.com\/en\/data-harmonization\/","name":"Data harmonization - Plug & Bet","isPartOf":{"@id":"https:\/\/plugandbet.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#primaryimage"},"image":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#primaryimage"},"thumbnailUrl":"https:\/\/plugandbet.com\/wp-content\/uploads\/2021\/01\/datenharmonisierung-01-1.svg","datePublished":"2021-01-28T19:39:58+00:00","dateModified":"2021-06-11T14:30:38+00:00","author":{"@id":"https:\/\/plugandbet.com\/de\/#\/schema\/person\/c857e0c2048f17d9b3433cc678f74517"},"breadcrumb":{"@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/plugandbet.com\/en\/data-harmonization\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#primaryimage","url":"https:\/\/plugandbet.com\/wp-content\/uploads\/2021\/01\/datenharmonisierung-01-1.svg","contentUrl":"https:\/\/plugandbet.com\/wp-content\/uploads\/2021\/01\/datenharmonisierung-01-1.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/plugandbet.com\/en\/data-harmonization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/plugandbet.com\/en\/"},{"@type":"ListItem","position":2,"name":"Data harmonization"}]},{"@type":"WebSite","@id":"https:\/\/plugandbet.com\/de\/#website","url":"https:\/\/plugandbet.com\/de\/","name":"Plug & Bet","description":"Wir sind die Unternehmensberatung mit Anpack.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/plugandbet.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/plugandbet.com\/de\/#\/schema\/person\/c857e0c2048f17d9b3433cc678f74517","name":"topfmaler","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/751e835722265162c1d94c040da30cd3c7e903f05e69d4bbde07c2d7e695a053?s=96&d=mm&r=g","caption":"topfmaler"},"sameAs":["https:\/\/plugandbet.com"]}]}},"_links":{"self":[{"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/posts\/2800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/comments?post=2800"}],"version-history":[{"count":5,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/posts\/2800\/revisions"}],"predecessor-version":[{"id":2806,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/posts\/2800\/revisions\/2806"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/media\/2441"}],"wp:attachment":[{"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/media?parent=2800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/categories?post=2800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/tags?post=2800"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/plugandbet.com\/en\/wp-json\/wp\/v2\/dipi_cpt_category?post=2800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}