002

/

Data architecture

/

Retail

Architecture design

Data ecosystem based on Lakehouse to facilitate the management, control, and use of information for a leading retailer in Colombia.

Databricks
Databricks
Databricks
Kedro
Kedro
Kedro
Lakehouse
Lakehouse
Lakehouse
Spark
Spark
Spark
Machine learning
Machine learning
Machine learning
Data-architecture
Data-architecture
Data-architecture

Challenge

A major retail company in Colombia, with more than 2,500 stores, faced the challenge of modernizing its data ecosystem as part of its digital transformation strategy, with the aim of strengthening its business value through a data-driven approach.

Solution

We lead the process of understanding, planning, design, implementation and built a data ecosystem with a lakehouse-type architecture, which allowed us to centralize and make available strategic information on a single platform for analytical and BI purposes. Currently, this platform processes more than 700 million records per day, includes tables with volumes exceeding 11 billion records, and more than 22 TB of information that is clean, standardized, enriched, governed, and available for decision-making with business impact. Currently, we continue to support the client in administration, maintenance, and support activities of the platform, as well as its growth based on new initiatives.


The representation of our data universe was created with the help of artificial intelligence and teamwork.

Carrera 13 # 93-68 Bogotá, Colombia

©2023

The representation of our data universe was created with the help of artificial intelligence and teamwork.

Carrera 13 # 93-68 Bogotá, Colombia

©2023

The representation of our data universe was created with the help of artificial intelligence and teamwork.

Carrera 13 # 93-68 Bogotá, Colombia

©2023