Cochez builds a 360-degree view of its business with data analytics on Google Cloud
Cochez, a leader in construction materials, finishes and hardware in Panama, needed a data platform with better cost, capacity, elasticity and integration than the one it had on another public cloud. With Data Fusion, BigQuery and Vertex AI it integrates financial, operational, inventory, customer and human resources sources and runs its predictive models end to end.
- Client
- Cochez
- Sector
- Retail and wholesale
- Country
- Panama
- Project
- Data platform migration and predictive analytics
- Technologies
- Data Fusion · BigQuery · Vertex AI · Google Cloud
In numbers
- 40%
cost optimization of the data platform
- 10x
faster extraction, transformation and loading processes
- Vertex AI
integrated lifecycle for the predictive models
In short
Cochez is a Panamanian company with more than 60 years in the market, a leader in the supply of construction materials, finishes and hardware, from basic household needs to construction projects, offering its customers an omnichannel shopping experience across digital channels and physical stores.
Exploiting data efficiently, with a 360-degree view of the business, is a fundamental part of its strategy for data-driven decision making.
01 · The problem
A data platform that limited the 360-degree view of the business
- 01
Cost and capacity
The previous solution, on another public cloud, imposed limitations on cost, capacity and elasticity.
- 02
Integration
Financial, operational, inventory, customer and human resources data had to be integrated into a single data architecture.
- 03
Predictive models
Developing artificial intelligence and machine learning models required a platform that covered their entire lifecycle.
02 · How we solved it
Data Fusion and BigQuery to integrate, Vertex AI to predict
- 1
Source integration in BigQuery
Data Fusion integrates data from various sources (financial, operational, inventory, customer system, human resources and more) to be stored and processed in BigQuery in a faster and more scalable way.
- 2
Predictive models end to end
With Vertex AI, predictive models fulfill their lifecycle in an integrated way: data processing, predictive modeling and delivery of results.
03 · The benefit for the client
Lower cost, more speed and more models
Cost
- 40% cost optimization.
Efficiency
- Increased efficiency and agility in data exploitation, visualization and analysis.
- Extraction, transformation and loading processes improved by a factor of 10 in execution time.
Advanced analytics
- Increased development of new models based on artificial intelligence and machine learning.
In the client's words
The migration to GCP gave us greater autonomy in our analytics projects and greater control over our infrastructure costs. BigQuery allows us to exploit data more efficiently, with greater scalability and flexibility (…). We have been able to create a SaaS ecosystem to perform data science, and thus find the elements to better satisfy our customers.
Related solutions
See all case studies- Cloud, data and governanceWe design, migrate and operate infrastructure and data platforms. We assess architecture, security, continuity and costs against the project's needs.See how we work on it
- Custom engineeringWe build agents, modernize applications and integrate data and systems. We work with you to decide what to build and which existing tools to use.See how we work on it
Does your data platform limit cost, capacity or integration?
Tell us which sources you need to integrate and which decisions you want to support. We define an initial scope with you.