{"id":344736,"date":"2026-02-01T10:00:00","date_gmt":"2026-02-01T10:00:00","guid":{"rendered":"https:\/\/scanda.com.mx\/?p=344736"},"modified":"2026-08-18T21:50:21","modified_gmt":"2026-08-18T21:50:21","slug":"implementacion-de-data-warehouse-en-azure-para-mejorar-la-toma-de-decisiones-de-ap-latam","status":"publish","type":"post","link":"https:\/\/scanda.com.mx\/en\/data-warehouse-implementation-in-azure-to-improve-decision-making-in-ap-platam\/","title":{"rendered":"Implementation of Data Warehouse in Azure to improve AP Latam\u2019s decision-making"},"content":{"rendered":"

Accelerating decision-making<\/strong><\/h3>\n\n\n\n

AP Latam <\/strong>It is a company that supports the best universities in Latin America to create, implement, develop and market quality online educational programs in Chile, Colombia, Ecuador, Mexico, Peru and the Dominican Republic.<\/p>\n\n\n\n

Challenges of the industry<\/strong><\/h2>\n\n\n\n

Online education is a trend that has gained more prominence with the Covid-19 pandemic. What was once an option for some institutions and programs has become a necessity for many.the only way to continue with education<\/strong>, Not to mention that the time to achieve it was crucial.<\/p>\n\n\n\n

The universities had to carry out a digital transformation<\/strong> of their programs in record time<\/strong>, To maintain service to its current students and attract new students seeking a quality online option.<\/p>\n\n\n\n

AP LATAM challenges<\/strong><\/h2>\n\n\n\n

With the surprising increase in demand for service AP Latam<\/strong>, I needed to accelerate and improve assertiveness in decision-making.<\/p>\n\n\n\n

The main challenge was to create a centralized and flexible platform that would allow it to adapt to market changes, and with reliable information to create dashboards that would allow sales and marketing users to improve decision-making, to improve student retention and lifecycle control.<\/p>\n\n\n\n

Before creating a centralized platform, AP Latam <\/strong>They were doing their reports in a disconnected and manual way, which made it difficult for them to have a comprehensive view and make decisions in a short time.<\/p>\n\n\n\n

Data <\/strong>Warehouse<\/strong> with <\/strong>Azure<\/strong><\/h2>\n\n\n\n

It was clear that, to have reliable information for decision-making, it was necessary to implement a centralized platform that would allow them to adapt to changes and the rapid growth of the market. The ideal solution for AP Latam was to implement a Data Warehouse<\/strong> in the cloud with the tools of Azure<\/strong>, To carry out the process of Data management from end to end<\/strong>.<\/p>\n\n\n\n

With Microsoft Azure technology, we automate the collection, integration, transformation and generation of dashboards<\/strong>to facilitate decision-making across the various areas of the company.<\/p>\n\n\n\n

Analytics that support the growth of the organization<\/strong><\/h2>\n\n\n\n

We integrate information from the various information sources of AP Latam as CRM, Social Media and Google Analytics<\/strong> With Azure Data Factory, storing it in a Data Lake<\/strong> using Azure Data Lake Gen 2.<\/p>\n\n\n\n

We created a Data Warehouse with Azure Synapse Analytics<\/strong> to provide reliable information to all business areas, and we built cubicles with Azure Analytics Services<\/strong><\/a> to have a single source of information with more than 150 indicators, improving the performance of dashboards created in Power BI<\/strong><\/a>.<\/p>\n\n\n\n

Benefits<\/strong><\/h4>\n\n\n\n

Now, AP Latam <\/strong>It features a centralized platform in the cloud, which allows it to adapt quickly to market changes. The project's main benefits are:<\/p>\n\n\n\n

    \n
  • Ability to perform granular analysis<\/li>\n\n\n\n
  • Optimized costs with pay-per-use models<\/li>\n\n\n\n
  • Speed up the generation of information and reports by 96%<\/li>\n<\/ul>\n\n\n\n
    \n

    \u201cWe achieved our goal, having centralized information available to make decisions quickly and reliably! Our dream has come true!\u201d<\/p>\n\n\n\n

    \u2013 Analytics Manager<\/strong><\/p>\n<\/blockquote>","protected":false},"excerpt":{"rendered":"

    Acelerando la toma de decisiones AP Latam es una empresa que apoya a las mejores universidades de Am\u00e9rica Latina para crear, implementar, desarrollar y comercializar programas educativos en l\u00ednea de calidad en: Chile, Colombia, Ecuador, M\u00e9xico, Per\u00fa y Rep\u00fablica Dominicana. Retos de la industria La educaci\u00f3n en l\u00ednea es una tendencia que tom\u00f3 m\u00e1s relevancia con […]<\/p>\n","protected":false},"author":5,"featured_media":344737,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","content-type":"","footnotes":""},"categories":[17],"tags":[],"class_list":["post-344736","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-casos-de-exito"],"_links":{"self":[{"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/posts\/344736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/comments?post=344736"}],"version-history":[{"count":1,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/posts\/344736\/revisions"}],"predecessor-version":[{"id":344738,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/posts\/344736\/revisions\/344738"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/media\/344737"}],"wp:attachment":[{"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/media?parent=344736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/categories?post=344736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scanda.com.mx\/en\/wp-json\/wp\/v2\/tags?post=344736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}