{"id":14378,"date":"2019-09-28T23:24:57","date_gmt":"2019-09-28T23:24:57","guid":{"rendered":"https:\/\/oxfordcorp.com\/?p=14378"},"modified":"2023-10-24T10:16:38","modified_gmt":"2023-10-24T10:16:38","slug":"international-database-consolidation","status":"publish","type":"post","link":"https:\/\/www.oxfordcorp.com\/nl-d\/insights\/case-study\/international-database-consolidation\/","title":{"rendered":"International Database Consolidation"},"content":{"rendered":"<p><strong>INDUSTRY<\/strong><br \/>\nSolar Innovation<\/p>\n<p><strong>SERVICES<\/strong><br \/>\nBig Data and Information Management<br \/>\nBusiness Intelligence and Analytics<br \/>\nApplication Development<\/p>\n<p><strong>SKILLS<\/strong><br \/>\nAWS<br \/>\nBig Data<br \/>\nHadoop<br \/>\nData Governance<\/p>\n<p><strong>The Challenge<\/strong><br \/>\nA leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Their system consisted of five international databases that allowed for data storage but lacked the ability to be leveraged for data queries. The separate databases prevented information sharing between applications. Key issues to be addressed included:<\/p>\n<ul>\n<li>Data Quality<\/li>\n<li>Data governance and process controls<\/li>\n<li>Manual reporting process<\/li>\n<\/ul>\n<p><strong>The Solution<\/strong><br \/>\nAs a leading Big Data services provider, we designed and implemented a Hadoop\u2122 data lake consolidating the unconnected data from the five databases. The data lake was built on Amazon Web Services (AWS)\u2122 as a scalable and centralized solution. The solution, coupled with our process improvements, leveraged their deep data science expertise and resolved the previous issues. The solution provided an automated predictive model with a self-service yield calculation reporting solution.<\/p>\n<p><strong>The Result<\/strong><br \/>\nOur solution ultimately provided the following values to the client:<\/p>\n<ul>\n<li>Automated data integration empowering reporting users with self-service<\/li>\n<li>A scalable solution allowing applications to share information, preventing silos<\/li>\n<li>The predictive model created actionable insights<\/li>\n<li>Accurate yield calculation without quality concerns<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0<\/p>\n","protected":false},"author":10,"featured_media":15432,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[181],"tags":[251],"category-tag":[],"class_list":["post-14378","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","tag-technology-communications"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.1 (Yoast SEO v27.1.1) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>International Database Consolidation - Oxford Global Resources<\/title>\n<meta name=\"description\" content=\"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\" \/>\n<meta property=\"og:locale\" content=\"nl_BE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"International Database Consolidation\" \/>\n<meta property=\"og:description\" content=\"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\" \/>\n<meta property=\"og:site_name\" content=\"Oxford Global Resources\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-28T23:24:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-24T10:16:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"516\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Luke Summers\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Summers\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\"},\"author\":{\"name\":\"Luke Summers\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\"},\"headline\":\"International Database Consolidation\",\"datePublished\":\"2019-09-28T23:24:57+00:00\",\"dateModified\":\"2023-10-24T10:16:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\"},\"wordCount\":201,\"image\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg\",\"keywords\":[\"Technology &amp; Communications\"],\"articleSection\":[\"Case Study\"],\"inLanguage\":\"nl-BE\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\",\"url\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\",\"name\":\"International Database Consolidation - Oxford Global Resources\",\"isPartOf\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg\",\"datePublished\":\"2019-09-28T23:24:57+00:00\",\"dateModified\":\"2023-10-24T10:16:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\"},\"description\":\"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#breadcrumb\"},\"inLanguage\":\"nl-BE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-BE\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage\",\"url\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg\",\"contentUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg\",\"width\":1600,\"height\":430,\"caption\":\"international database consolidation 2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.oxfordcorp.com\/nl-d\/final-homepage-2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"International Database Consolidation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#website\",\"url\":\"https:\/\/www.oxfordcorp.com\/de\/\",\"name\":\"Oxford Global Resources\",\"description\":\"Global\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.oxfordcorp.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-BE\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\",\"name\":\"Luke Summers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-BE\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g\",\"caption\":\"Luke Summers\"},\"url\":\"https:\/\/www.oxfordcorp.com\/nl-d\/insights\/author\/lsummersthiel-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"International Database Consolidation - Oxford Global Resources","description":"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0","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:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/","og_locale":"nl_BE","og_type":"article","og_title":"International Database Consolidation","og_description":"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0","og_url":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/","og_site_name":"Oxford Global Resources","article_published_time":"2019-09-28T23:24:57+00:00","article_modified_time":"2023-10-24T10:16:38+00:00","og_image":[{"width":1920,"height":516,"url":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg","type":"image\/jpeg"}],"author":"Luke Summers","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Luke Summers","Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#article","isPartOf":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/"},"author":{"name":"Luke Summers","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3"},"headline":"International Database Consolidation","datePublished":"2019-09-28T23:24:57+00:00","dateModified":"2023-10-24T10:16:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/"},"wordCount":201,"image":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg","keywords":["Technology &amp; Communications"],"articleSection":["Case Study"],"inLanguage":"nl-BE"},{"@type":"WebPage","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/","url":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/","name":"International Database Consolidation - Oxford Global Resources","isPartOf":{"@id":"https:\/\/www.oxfordcorp.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage"},"image":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg","datePublished":"2019-09-28T23:24:57+00:00","dateModified":"2023-10-24T10:16:38+00:00","author":{"@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3"},"description":"A leading global solar innovation firm experienced gaps in reporting and analytics capabilities. Learn how Oxford helped them optimize and streamline their system.\u00a0","breadcrumb":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#breadcrumb"},"inLanguage":"nl-BE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/"]}]},{"@type":"ImageObject","inLanguage":"nl-BE","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#primaryimage","url":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg","contentUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2019\/10\/international_database_consolidation_2.jpeg","width":1600,"height":430,"caption":"international database consolidation 2"},{"@type":"BreadcrumbList","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oxfordcorp.com\/nl-d\/final-homepage-2\/"},{"@type":"ListItem","position":2,"name":"International Database Consolidation"}]},{"@type":"WebSite","@id":"https:\/\/www.oxfordcorp.com\/de\/#website","url":"https:\/\/www.oxfordcorp.com\/de\/","name":"Oxford Global Resources","description":"Global","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oxfordcorp.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-BE"},{"@type":"Person","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3","name":"Luke Summers","image":{"@type":"ImageObject","inLanguage":"nl-BE","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g","caption":"Luke Summers"},"url":"https:\/\/www.oxfordcorp.com\/nl-d\/insights\/author\/lsummersthiel-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/posts\/14378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/comments?post=14378"}],"version-history":[{"count":0,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/posts\/14378\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/media\/15432"}],"wp:attachment":[{"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/media?parent=14378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/categories?post=14378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/tags?post=14378"},{"taxonomy":"category-tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/nl-d\/wp-json\/wp\/v2\/category-tag?post=14378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}