Case Studies

Cases anonymized by NDA. Numbers and context are real. Client names are omitted; results are not.

Strategy Nearshoring SE/RNIE · CBRE · IMCO

Nearshoring Attractiveness Index

$40.9B FDI · 12 states · 7 criteria · CDMX 58/100

Consolidated FDI in CDMX (54.8%) is misleading. MCDA index with SE/RNIE, CBRE, and INEGI data that reshapes the ranking: Guanajuato leads, CDMX is last.

View full analysis →
Analytics Household economics SHF · ENIGH · ABM

The housing gap in Mexico

PTI 6.0x · 65% of income · 97% gap · 8.7% appreciation

The average home costs 6 years of income. SHF + ENIGH 2018-2025 analysis, interactive mortgage affordability calculator, and appreciation by metropolitan area.

View full analysis →
Analytics Sports Transfermarkt API

Liga MX market value: LATAM benchmark

€961M · 18 clubs · 465 players · 5 leagues

Comparative analysis of Liga MX squads vs Brasileirão, MLS, Argentina and Colombia. 5 interactive charts with real Transfermarkt data (May 2026).

View full analysis →
Analytics Finance Banxico · INEGI · CNBV

Mexico's financial system: cycle & structure

Rate 6.5% · FIX $17.32 · Inclusion 68% ENIF

Banxico monetary policy cycle, ENIF 2021 financial inclusion gap, and CNBV banking concentration. 5 visualizations from real-time public APIs.

View full analysis →
Local AI Automation Real event store

AI automation pipeline with local LLM

195 events · 95.4% uptime · $0/mo · $2,424/yr savings

Modular AI agent architecture running 100% on-premise. Real production metrics: SaaS vs local cost comparison, uptime heatmap, and 12-month ROI.

View full analysis →
Big Four · Multinational Reporting

Reporting platform for 16 countries

−80% consolidation time

Full redesign of monthly consolidation flow with Power BI + Python for a Big Four firm in LATAM.

Power BIPythonSAP BWSQL Server
Insurance · Fraud Detection

Re-engineered ETL with daily policy validation

−65% false positives in audit

Migration from manual process to automated pipeline with business rules and statistical threshold alerts.

PythonAirflowPostgreSQLJupyter
Consulting · Local AI

Management system with local LLM and proposal pipeline

Proposals generated in <5 min

Full system: CRM + PDF proposals via Groq + knowledge base with Ollama. Zero SaaS dependency.

PythonGroqOllamaSQLite

Does your problem look like one of these?

Tell me yours. The diagnostic is free.

Schedule free diagnostic