{"id":7286,"date":"2023-10-23T19:59:50","date_gmt":"2023-10-23T19:59:50","guid":{"rendered":"https:\/\/amarello.cloud\/financial-support\/"},"modified":"2024-10-22T21:56:58","modified_gmt":"2024-10-22T21:56:58","slug":"financial-support","status":"publish","type":"post","link":"https:\/\/amarello.cloud\/en\/financial-support\/","title":{"rendered":"Financial support"},"content":{"rendered":"\n<p>Smart business analytics and AI<\/p>\n\n<h1 class=\"wp-block-heading\">Accelerate analytical processes for risk management in Google Cloud.<\/h1>\n\n<p>Apoyo Econ\u00f3mico is a company in the financial sector that provides microloans, with more than 170 branches nationwide. Among the needs of our client were the migration of relational databases based on licensing and optimization of analytical processes On Premises to Google Cloud. The main advantages that the client obtained by adopting a cloud model are: the reduction in licensing costs and very significant improvements in information processing time.  <\/p>\n\n<p>Within the most important business processes, critical analytical processes that use large volumes of information are executed on a monthly basis. Their main function is to deliver the analysis required by the business in the shortest possible time. In turn, risk analysts require the flexibility to perform additional analytical processes on the entire volume of information available.  <\/p>\n\n<p>The central requirement was to migrate the analytical process that generates as output the risk portfolio, which requires the processing of a large volume of historical information. Most of the process was implemented in an on-prem relational database which was limited to the use of licensed CPUs and hard disk space. <\/p>\n\n<p>Our team of Google Cloud Certified Data Engineers migrated and re-engineered analytical processes to Google BigQuery as an Enterprise Data Warehouse to streamline processing time from several days to a couple of hours and empower analysts with a new universe of available information.<\/p>\n\n<figure class=\"wp-block-image size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"680\" src=\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph-1024x680.png\" alt=\"\" class=\"wp-image-1117\" style=\"aspect-ratio:1.5061728395061729;width:1200px;height:auto\" srcset=\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph-1024x680.png 1024w, https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph-300x199.png 300w, https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph-768x510.png 768w, https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph-1536x1020.png 1536w, https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/AEF-graph.png 1708w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<p>BigQuery was enabled to connect with Google DataStudio and Google Sheets to generate dashboards efficiently and with real-time data, which dramatically facilitated the delivery of reports to different business areas in a controlled and secure manner.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Smart business analytics and AI Accelerate analytical processes for risk management in Google Cloud. Apoyo Econ\u00f3mico is a company in the financial sector that provides microloans, with more than 170 branches nationwide. Among the needs of our client were the migration of relational databases based on licensing and optimization of analytical processes On Premises to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":8118,"comment_status":"open","ping_status":"closed","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-7286","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>Financial support - 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\/apoyo-economico\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Financial support - F\u00e1brica de proyectos con IA | Amarello\" \/>\n<meta property=\"og:description\" content=\"Smart business analytics and AI Accelerate analytical processes for risk management in Google Cloud. Apoyo Econ\u00f3mico is a company in the financial sector that provides microloans, with more than 170 branches nationwide. Among the needs of our client were the migration of relational databases based on licensing and optimization of analytical processes On Premises to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/amarello.cloud\/apoyo-economico\/\" \/>\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-23T19:59:50+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\/Group-237815.png\" \/>\n\t<meta property=\"og:image:width\" content=\"592\" \/>\n\t<meta property=\"og:image:height\" content=\"592\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\/apoyo-economico\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/\"},\"author\":{\"name\":\"Leih Servin\",\"@id\":\"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b\"},\"headline\":\"Financial support\",\"datePublished\":\"2023-10-23T19:59:50+00:00\",\"dateModified\":\"2024-10-22T21:56:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/\"},\"wordCount\":272,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/amarello.cloud\/#organization\"},\"image\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp\",\"articleSection\":[\"Success stories\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/amarello.cloud\/apoyo-economico\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/\",\"url\":\"https:\/\/amarello.cloud\/apoyo-economico\/\",\"name\":\"Financial support - F\u00e1brica de proyectos con IA | Amarello\",\"isPartOf\":{\"@id\":\"https:\/\/amarello.cloud\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp\",\"datePublished\":\"2023-10-23T19:59:50+00:00\",\"dateModified\":\"2024-10-22T21:56:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/amarello.cloud\/apoyo-economico\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage\",\"url\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp\",\"contentUrl\":\"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/amarello.cloud\/apoyo-economico\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/amarello.cloud\/en\/home-amarello-sep\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial support\"}]},{\"@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":"Financial support - 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\/apoyo-economico\/","og_locale":"en_US","og_type":"article","og_title":"Financial support - F\u00e1brica de proyectos con IA | Amarello","og_description":"Smart business analytics and AI Accelerate analytical processes for risk management in Google Cloud. Apoyo Econ\u00f3mico is a company in the financial sector that provides microloans, with more than 170 branches nationwide. Among the needs of our client were the migration of relational databases based on licensing and optimization of analytical processes On Premises to [&hellip;]","og_url":"https:\/\/amarello.cloud\/apoyo-economico\/","og_site_name":"F\u00e1brica de proyectos con IA | Amarello","article_publisher":"https:\/\/www.facebook.com\/amarello.mx","article_published_time":"2023-10-23T19:59:50+00:00","article_modified_time":"2024-10-22T21:56:58+00:00","og_image":[{"width":592,"height":592,"url":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/Group-237815.png","type":"image\/png"}],"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\/apoyo-economico\/#article","isPartOf":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/"},"author":{"name":"Leih Servin","@id":"https:\/\/amarello.cloud\/#\/schema\/person\/43f573f298fb5cfcc73b7cf28e65af4b"},"headline":"Financial support","datePublished":"2023-10-23T19:59:50+00:00","dateModified":"2024-10-22T21:56:58+00:00","mainEntityOfPage":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/"},"wordCount":272,"commentCount":0,"publisher":{"@id":"https:\/\/amarello.cloud\/#organization"},"image":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage"},"thumbnailUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp","articleSection":["Success stories"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/amarello.cloud\/apoyo-economico\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/amarello.cloud\/apoyo-economico\/","url":"https:\/\/amarello.cloud\/apoyo-economico\/","name":"Financial support - F\u00e1brica de proyectos con IA | Amarello","isPartOf":{"@id":"https:\/\/amarello.cloud\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage"},"image":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage"},"thumbnailUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp","datePublished":"2023-10-23T19:59:50+00:00","dateModified":"2024-10-22T21:56:58+00:00","breadcrumb":{"@id":"https:\/\/amarello.cloud\/apoyo-economico\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amarello.cloud\/apoyo-economico\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/amarello.cloud\/apoyo-economico\/#primaryimage","url":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp","contentUrl":"https:\/\/amarello.cloud\/wp-content\/uploads\/2023\/10\/apoyo-economico.webp","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/amarello.cloud\/apoyo-economico\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/amarello.cloud\/en\/home-amarello-sep\/"},{"@type":"ListItem","position":2,"name":"Financial support"}]},{"@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\/7286","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=7286"}],"version-history":[{"count":1,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts\/7286\/revisions"}],"predecessor-version":[{"id":7287,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/posts\/7286\/revisions\/7287"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/media\/8118"}],"wp:attachment":[{"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/media?parent=7286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/categories?post=7286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amarello.cloud\/en\/wp-json\/wp\/v2\/tags?post=7286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}