A scalable, AI-ready analytical platform integrating SAP and GK across 400+ stores.
About the Customer
Maxicarnes Kekén (Grupo KUO) is the leading producer and marketer of pork in Mexico, with an integrated
operation spanning production, processing, and retail. Through its Maxicarne store chain, it sells directly to
consumers at more than 400 points of sale nationwide, in a market of roughly USD 6 billion per year with over
9,000 employees
Customer Challenge
Kekén’s commercial ecosystem was fragmented and manual, split between its SAP ERP and the GK CPD
promotions manager, with decisions based on partial, late, manually extracted reports that carried high operational dependency and error risk. The business had no reliable way to measure the real impact of promotions on sales, margin, and customer behavior across its 400+ stores, and SAP’s and GK’s definitions of core commercial metrics were not unified into a consistent set of KPIs. Without intervention, promotional spend would have remained effectively unmeasured, and the business’s ability to scale toward predictive, data-driven decision-making would have stayed limited
Partner Solution
Strata Analytics designed and implemented an AWS Lakehouse under the SDLF framework together with an AI-
powered promotions dashboard for Kekén, integrating commercial data from SAP and the GK CPD promotions
manager into a single, governed platform. SAP data is ingested through AWS AppFlow and AWS Glue over OData, and GK CPD data is integrated alongside it with dataset validation and certification, landing across Raw, Stage, and Analytics layers in Amazon S3.
Secure SAP connectivity runs through an AppFlow-managed VPC with a PrivateLink Endpoint Service and
Network Load Balancer, reinforced by a Site-to-Site VPN with redundant tunnels to the SAP environment for high
availability. AWS Glue Data Catalog catalogs the integrated datasets, and AWS Lake Formation governs access
across them. Amazon QuickSight then delivers executive and operational dashboards covering promotion
performance, inventory, demand by product, revenue by period, and loyal-customer analysis, all built on
infrastructure managed entirely as code for repeatable, auditable deployments.
Unifying SAP’s and GK’s differing metric definitions into a single, governed set of KPIs, with defined formulas,
owners, and validation criteria, was itself a deliverable of the engagement, establishing a Single Source of Truth for Kekén’s commercial reporting.
Results and Benefits
Promotion sales-impact visibility, comparing sales with and without promotion, moved from having no visibility at all to a measurable, quantified impact. Reporting latency moved from weeks to manually construct an analysis down to instant access through automated, always-current dashboards across Kekén’s 400+ stores. The solution is live and in production use today.
About the Partner
Strata Analytics is a cloud consulting and systems integration partner delivering data engineering, analytics, and
AI/ML solutions on AWS for enterprise retail clients across Latin America. Strata holds the AWS AI Agents
Competency, awarded March 19, 2026.
