{"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\/fr\/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.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>International Database Consolidation - Oxford<\/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=\"fr_FR\" \/>\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\" \/>\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=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Summers\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\":\"fr-FR\"},{\"@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\",\"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\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.oxfordcorp.com\\\/insights\\\/case-study\\\/international-database-consolidation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\\\/\"},{\"@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\",\"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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.oxfordcorp.com\\\/de\\\/#\\\/schema\\\/person\\\/e880f6edc6bcf421204f294431943cd3\",\"name\":\"Luke Summers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g\",\"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\\\/fr\\\/insights\\\/author\\\/lsummersthiel-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"International Database Consolidation - Oxford","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":"fr_FR","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","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":{"\u00c9crit par":"Luke Summers","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"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":"fr-FR"},{"@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","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":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oxfordcorp.com\/insights\/case-study\/international-database-consolidation\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@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\/"},{"@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","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":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3","name":"Luke Summers","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g","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\/fr\/insights\/author\/lsummersthiel-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/posts\/14378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/comments?post=14378"}],"version-history":[{"count":0,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/posts\/14378\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/media\/15432"}],"wp:attachment":[{"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/media?parent=14378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/categories?post=14378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/tags?post=14378"},{"taxonomy":"category-tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/fr\/wp-json\/wp\/v2\/category-tag?post=14378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}