Consubanco is a fast-growing Mexican bank specializing in payroll loans, deposit accounts and digital banking services. In less than 20 years, it grew from a small institution into a mid-sized player, reaching major milestones in half the time of most banks.
To support its customer-first strategy and rapid growth, Consubanco placed data at the center of its transformation. By analyzing customer behavior, preferences, and transactions, the bank can deliver timely, personalized service. This data-driven approach allows it to manage segmentation, predict customer needs, and optimize experiences across the entire journey.
The Need for Change
Every decision Consubanco made fueled its rapid growth, from independent, fast-growing business units to a full-scale financial institution. However, that success created fragmented systems and data silos, limiting visibility across the full customer journey.
The shift toward modernization was not triggered by a single point of pain. “We hit several limitations at once: technical, architectural, and analytical. It was clear we needed a platform that could grow with us and power the next generation of use cases,” said Federico Lage, Head of Data Strategy @ Consubanco.
As the bank matured, forecasting, machine learning, and real-time insights became essential, but those were not supported by its SQL Server. Simultaneously, the bank was shifting to a customer-centric, data-driven model, requiring a modern data foundation.
How Consubanco Chose Yellowbrick
After running a proof of concept, the team was impressed by Yellowbrick’s strong performance with SAS, one of the bank’s core analytics tools. “We tested it, and it was immediately clear this was the right direction,” mentioned Lage. The SQL Data Platform stood out with its ability to efficiently manage large-scale workloads, consistently deliver high-speed performance without compromising reliability, and so at a cost-effective rate – all while integrating seamlessly with existing systems.
Turning Data into Growth: Consubanco’s Strategic Use Cases
Yellowbrick powers Consubanco’s data strategy to scale AI initiatives, democratize analytics, and drive 5X customer growth in just three years. Use cases such as customer segmentation, purchase predictions, credit risk analysis, portfolio monitoring and customer 360 insights share a common goal: making data accessible for everyone without bottlenecks or IT dependency.
To enable this transformation, the bank needed to migrate with minimal business impact.
Phased Implementation Approach
This rollout, supported by AppTec, a leader in Analytics and Big Data solutions, began by stabilizing data flows and validating data quality. “With Apptec, we didn’t just get a vendor. We gained a true ally. The team understood our challenges, embraced uncertainty, and helped us turn complexity into progress.” said Lage.
The first critical process focused on migrating everything related to “customer account statements” which represented the highest transaction volume across the bank.
“Before Yellowbrick, the portfolio monitoring use case took 500+ hours to complete, resulting in frustrated customers and missed opportunities for the bank”
Top Outcomes
The modernization of Consubanco’s enterprise data warehouse improved turnaround times, accelerated operations, fueled business growth, and positioned the bank to achieve 5X customer growth in just three years. Additionally, with consolidated and accurate data across teams, the bank has strengthened its business model and improved its customer experience.
“The superpower Yellowbrick gave us is data awareness, knowing where our data comes from, how it is transformed, and how to trust it while the business keeps running. That makes a huge difference!”
- Data consolidation: Migrated from five data systems to a single Yellowbrick platform, managing over 7 TB of data and close to 900K queries per week.
- Core databases now update three times per day, while other datasets refresh nightly, freeing up resources for strategic initiatives.
- Data-driven decisions: Their clients make informed decisions with up-to-date monthly statements.
- Operational Efficiency Gains: Portfolio monitoring was cut from 500+ hours to only 10% of that time, and large data processes reduced from 5+ hours to 30 minutes.
"The data loading speed has dramatically improved. Processes that used to start at dawn and take five hours or more, now finish in 30 minutes. This has given my team extra time to take on more projects and drive greater impact with fewer resources."
- Customer and Revenue Growth: In 2025, the bank doubled its investment accounts, achieved incremental growth in credit sales, and it is on track for 5X overall customer base expansion within 3 years.
- Data Democratization: Real-time data access for marketing, risk, and product teams without IT bottlenecks.
- Ease of Use and Adoption: PostgreSQL compatibility enabled a smooth transition, allowing engineers and analysts to quickly adopt the platform.
“Yellowbrick’s ease of use simplifies my workday. I can see what’s happening—across queries, users, and system resources. I find answers faster, fix issues quickly, and get insights without delay.”
Next Steps
As Consubanco evolves toward a hybrid cloud strategy, Yellowbrick plays a critical role as the only vendor offering a SaaS-like experience across both on-premises and cloud environments. This enables the bank to keep critical always-on workloads on-prem, optimizing for performance and cost, while leveraging the cloud for customer-facing data access and resilient disaster recovery. With Yellowbrick, Consubanco is not just scaling operations; it is building a data-driven foundation to fuel the next decade of growth and innovation.
