Alquería speeds up its reports 100 times and paves the way for predictive data
Alquería needed the business reports to be available, complete and correct at the start of each day of operation, something its legacy on-premise data platform no longer allowed. With its team and Amarello's support, it modernized its data warehouse on Google Cloud: better processing times, a first analytical forecast model and more users with access to the data.
- Client
- Alquería
- Sector
- Consumer goods · Food and beverage
- Country
- Colombia
- Project
- Data warehouse modernization and analytics platform
- Technologies
- BigQuery · Data Fusion · AI Platform · Google Cloud
In numbers
- 100x
faster report processing times for the commercial area
- First model
for sales forecasting based on machine learning
- Fewer licenses
savings on BI tools that made it possible to expand the user base of the reports
In short
Alquería is a Colombian corporate group in the food and beverage industry, in the dairy sector, recognized as the leading brand in Top of Mind and Top of Heart in the milk segment, with 62 years in the market and 23% market share.
With its specialized team and the expert support of Amarello, it implemented on Google Cloud a data solution that improves processing times and enables predictive scenarios.
01 · The problem
Reports that had to be ready at the start of each day, on a legacy platform
- 01
Delivery time
The business needs the reports available, complete and correct at the start of each day of operation. The processes were not arriving in time.
- 02
Legacy data platform
The solution ran on a legacy data platform in an on-premise environment, with limited processing capacity.
- 03
No predictive scenarios
Data scientists lacked tools to experiment and create analytical models with first-hand access to business information.
02 · How we solved it
A modern data warehouse on BigQuery and tools for data science
- 1
Data warehouse modernization
The data warehouse modernization was carried out with BigQuery and Data Fusion: a secure, scalable solution with more processing capacity.
- 2
Platform for analytical models
With AI Platform, data scientists have tools that allow them to experiment and create analytical models with flexibility and direct access to business information.
03 · The benefit for the client
More speed, the first predictive model and data for more people
Speed
- Report processing times for the commercial area improved by a factor of 100.
Prediction
- First analytical model for sales forecasting based on machine learning.
Cost and reach
- Savings on BI tool licenses, which made it possible to expand the user base that benefits from the reports.
- The way to data democratization was paved.
In the client's words
The first step on our path to becoming a Data Driven Company was to democratize access to information in a secure, reliable and flexible way. With Google Cloud we now have new capabilities to model future scenarios that allow us to make better decisions, seeking to strengthen our partnerships with suppliers and continue to gain the preference of 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
Do your reports arrive late, or has your data platform reached its limit?
Tell us which analytical processes you want to speed up and which systems feed them. We define an initial scope with you.