{"id":7288,"date":"2023-10-23T20:19:34","date_gmt":"2023-10-23T20:19:34","guid":{"rendered":"https:\/\/amarello.cloud\/econ\/"},"modified":"2024-10-22T21:56:58","modified_gmt":"2024-10-22T21:56:58","slug":"econ","status":"publish","type":"post","link":"https:\/\/amarello.cloud\/en\/econ\/","title":{"rendered":"Econ"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Smart business analytics and AI<\/p>\n\n<h1 class=\"wp-block-heading\" id=\"h-llevar-al-siguiente-nivel-la-valuacion-en-la-cadena-de-suministro-de-commodities-con-google-cloud\">Taking commodity supply chain valuation to the next level with Google Cloud.<\/h1>\n\n<p class=\"wp-block-paragraph\">ECOM Agroindustrial Corp. Ltd. is a company in the commodity industry and sustainable supply chain management. With operations in over 35 countries, focusing mainly on coffee, cotton and cocoa.    <\/p>\n\n<p class=\"wp-block-paragraph\"><strong>The supply chain generates a large amount of data related to the handling of commodities. The business objective was to migrate legacy processes to an automated process that performs complex financial analysis for each by-product in an efficient and secure manner.   <\/strong><\/p>\n\n<p class=\"wp-block-paragraph\">The information inputs were siloed and comprised a large volume dataset fragmented across multiple geographic locations with heterogeneous data sources. Our proposed solution facilitated centralizing and unifying the information in an EDW (Enterprise Data Warehouse) for the business.   <\/p>\n\n<p class=\"wp-block-paragraph\"><strong>The final solution was able to deliver to the general management the analyzed information in a better time for decision making in a more effective and faster way.  <\/strong><\/p>\n\n<p class=\"wp-block-paragraph\">Our team of Google Cloud Certified Data Engineers designed and implemented a pipeline with Cloud Storage as DataLake. The data is normalized, cleansed and ingested with DataPrep to BigQuery as EDW (Enterprise Data Warehouse), where the financial analysis of the information is then performed. <\/p>\n\n<figure class=\"wp-block-image alignfull size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"692\" height=\"459\" src=\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-graph-1024x679-copia.webp\" alt=\"\" class=\"wp-image-6494\" srcset=\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-graph-1024x679-copia.webp 692w, https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-graph-1024x679-copia-300x199.webp 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure>\n\n<p class=\"wp-block-paragraph\">The end result is a dashboard with the main KPIs that the business was looking for in DataStudio connected in real time to BigQuery which is updated every time new information is ingested. Google Sheets was also connected to generate working documents directly from BigQuery which helped to eliminate information silos and obtain a single source of truth.   <\/p>\n\n<p class=\"wp-block-paragraph\"><strong>Processing times went from waiting 5 days for calculations to getting them in 1 hour, which led to the possibility of producing these reports several times a month or daily on demand.<\/strong><\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Smart business analytics and AI Taking commodity supply chain valuation to the next level with Google Cloud. ECOM Agroindustrial Corp. Ltd. is a company in the commodity industry and sustainable supply chain management. With operations in over 35 countries, focusing mainly on coffee, cotton and cocoa. The supply chain generates a large amount of data [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":8116,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[93],"tags":[],"class_list":["post-7288","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-success-stories"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Econ - F\u00e1brica de proyectos con IA | Amarello<\/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:\/\/amarello.cloud\/econ\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Econ - F\u00e1brica de proyectos con IA | Amarello\" \/>\n<meta property=\"og:description\" content=\"Smart business analytics and AI Taking commodity supply chain valuation to the next level with Google Cloud. ECOM Agroindustrial Corp. Ltd. is a company in the commodity industry and sustainable supply chain management. With operations in over 35 countries, focusing mainly on coffee, cotton and cocoa. The supply chain generates a large amount of data [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/amarello.cloud\/econ\/\" \/>\n<meta property=\"og:site_name\" content=\"F\u00e1brica de proyectos con IA | Amarello\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/amarello.mx\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-23T20:19:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-22T21:56:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Leih Servin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@amarello_mx\" \/>\n<meta name=\"twitter:site\" content=\"@amarello_mx\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leih Servin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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:\/\/amarello.cloud\/econ\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/\"},\"author\":{\"name\":\"Leih Servin\",\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b\"},\"headline\":\"Econ\",\"datePublished\":\"2023-10-23T20:19:34+00:00\",\"dateModified\":\"2024-10-22T21:56:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/\"},\"wordCount\":285,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/amarello.cloud\/#organization\"},\"image\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp\",\"articleSection\":[\"Success stories\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/amarello.cloud\/econ\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/amarello.cloud\/econ\/\",\"url\":\"https:\/\/amarello.cloud\/econ\/\",\"name\":\"Econ - F\u00e1brica de proyectos con IA | Amarello\",\"isPartOf\":{\"@id\":\"https:\/\/amarello.cloud\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp\",\"datePublished\":\"2023-10-23T20:19:34+00:00\",\"dateModified\":\"2024-10-22T21:56:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/amarello.cloud\/econ\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/amarello.cloud\/econ\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amarello.cloud\/econ\/#primaryimage\",\"url\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp\",\"contentUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/amarello.cloud\/econ\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/amarello.cloud\/en\/home-amarello-sep\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Econ\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/amarello.cloud\/#website\",\"url\":\"https:\/\/amarello.cloud\/\",\"name\":\"Google Partner Premier | Amarello\",\"description\":\"Exponenciamos negocios con la fuerza de la nube e IA\",\"publisher\":{\"@id\":\"https:\/\/amarello.cloud\/#organization\"},\"alternateName\":\"Proveedores de cloud computing gestionados\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/amarello.cloud\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/amarello.cloud\/#organization\",\"name\":\"Amarello\",\"alternateName\":\"Proveedores de Google cloud para empresas\",\"url\":\"https:\/\/amarello.cloud\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/12\/a.svg\",\"contentUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/12\/a.svg\",\"width\":425,\"height\":425,\"caption\":\"Amarello\"},\"image\":{\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/amarello.mx\",\"https:\/\/x.com\/amarello_mx\",\"https:\/\/www.linkedin.com\/company\/amarello-tecnologias-de-informacion\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b\",\"name\":\"Leih Servin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/90a37942d4cc6321cb21068fb7d9bf05fcac850bf159139ecaf69988b89f27c1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/90a37942d4cc6321cb21068fb7d9bf05fcac850bf159139ecaf69988b89f27c1?s=96&d=mm&r=g\",\"caption\":\"Leih Servin\"},\"sameAs\":[\"http:\/\/Amarello.cloud\"],\"url\":\"https:\/\/amarello.cloud\/en\/author\/leih-servin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Econ - F\u00e1brica de proyectos con IA | Amarello","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:\/\/amarello.cloud\/econ\/","og_locale":"en_US","og_type":"article","og_title":"Econ - F\u00e1brica de proyectos con IA | Amarello","og_description":"Smart business analytics and AI Taking commodity supply chain valuation to the next level with Google Cloud. ECOM Agroindustrial Corp. Ltd. is a company in the commodity industry and sustainable supply chain management. With operations in over 35 countries, focusing mainly on coffee, cotton and cocoa. The supply chain generates a large amount of data [&hellip;]","og_url":"https:\/\/amarello.cloud\/econ\/","og_site_name":"F\u00e1brica de proyectos con IA | Amarello","article_publisher":"https:\/\/www.facebook.com\/amarello.mx","article_published_time":"2023-10-23T20:19:34+00:00","article_modified_time":"2024-10-22T21:56:58+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-1.webp","type":"image\/webp"}],"author":"Leih Servin","twitter_card":"summary_large_image","twitter_creator":"@amarello_mx","twitter_site":"@amarello_mx","twitter_misc":{"Written by":"Leih Servin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/amarello.cloud\/econ\/#article","isPartOf":{"@id":"https:\/\/amarello.cloud\/econ\/"},"author":{"name":"Leih Servin","@id":"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b"},"headline":"Econ","datePublished":"2023-10-23T20:19:34+00:00","dateModified":"2024-10-22T21:56:58+00:00","mainEntityOfPage":{"@id":"https:\/\/amarello.cloud\/econ\/"},"wordCount":285,"commentCount":0,"publisher":{"@id":"https:\/\/amarello.cloud\/#organization"},"image":{"@id":"https:\/\/amarello.cloud\/econ\/#primaryimage"},"thumbnailUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp","articleSection":["Success stories"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/amarello.cloud\/econ\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/amarello.cloud\/econ\/","url":"https:\/\/amarello.cloud\/econ\/","name":"Econ - F\u00e1brica de proyectos con IA | Amarello","isPartOf":{"@id":"https:\/\/amarello.cloud\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amarello.cloud\/econ\/#primaryimage"},"image":{"@id":"https:\/\/amarello.cloud\/econ\/#primaryimage"},"thumbnailUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp","datePublished":"2023-10-23T20:19:34+00:00","dateModified":"2024-10-22T21:56:58+00:00","breadcrumb":{"@id":"https:\/\/amarello.cloud\/econ\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amarello.cloud\/econ\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amarello.cloud\/econ\/#primaryimage","url":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp","contentUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/ecom-2.webp","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/amarello.cloud\/econ\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/amarello.cloud\/en\/home-amarello-sep\/"},{"@type":"ListItem","position":2,"name":"Econ"}]},{"@type":"WebSite","@id":"https:\/\/amarello.cloud\/#website","url":"https:\/\/amarello.cloud\/","name":"Google Partner Premier | Amarello","description":"Exponenciamos negocios con la fuerza de la nube e IA","publisher":{"@id":"https:\/\/amarello.cloud\/#organization"},"alternateName":"Proveedores de cloud computing gestionados","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/amarello.cloud\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/amarello.cloud\/#organization","name":"Amarello","alternateName":"Proveedores de Google cloud para empresas","url":"https:\/\/amarello.cloud\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amarello.cloud\/#\/schema\/logo\/image\/","url":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/12\/a.svg","contentUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/12\/a.svg","width":425,"height":425,"caption":"Amarello"},"image":{"@id":"https:\/\/amarello.cloud\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/amarello.mx","https:\/\/x.com\/amarello_mx","https:\/\/www.linkedin.com\/company\/amarello-tecnologias-de-informacion\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b","name":"Leih Servin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amarello.cloud\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/90a37942d4cc6321cb21068fb7d9bf05fcac850bf159139ecaf69988b89f27c1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/90a37942d4cc6321cb21068fb7d9bf05fcac850bf159139ecaf69988b89f27c1?s=96&d=mm&r=g","caption":"Leih Servin"},"sameAs":["http:\/\/Amarello.cloud"],"url":"https:\/\/amarello.cloud\/en\/author\/leih-servin\/"}]}},"_links":{"self":[{"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts\/7288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/comments?post=7288"}],"version-history":[{"count":1,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts\/7288\/revisions"}],"predecessor-version":[{"id":7289,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts\/7288\/revisions\/7289"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/media\/8116"}],"wp:attachment":[{"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/media?parent=7288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/categories?post=7288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/tags?post=7288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}