Modern data architecture with Data Vault

Arrow to the right

How can a standardized data structure be created?

Arrow to the right

How can large volumes of data from many different systems be integrated and stored reliably?

Arrow to the right

How can the data be easily connected to BI tools such as Power BI?

The company
Aachener Grundvermögen, one of Germany's leading real estate investment companies, known internationally for its focus on high-quality urban properties in prime locations across Germany and neighboring European countries.
Technologies
dbt Cloud Enterprise, Snowflake
The challenge
Promote acceptance within the company, create a flexible data structure that takes business logic into account
Result
Creation of a uniform data structure using the flexible Data Vault modeling approach
Read the case study now

Modern data architecture with Data Vault

Arrow to the right

How can a standardized data structure be created?

Arrow to the right

How can large volumes of data from many different systems be integrated and stored reliably?

Arrow to the right

How can the data be easily connected to BI tools such as Power BI?

The company
Aachener Grundvermögen, one of Germany's leading real estate investment companies, known internationally for its focus on high-quality urban properties in prime locations across Germany and neighboring European countries.
Technologies
dbt Cloud Enterprise, Snowflake
The challenge
Promote acceptance within the company, create a flexible data structure that takes business logic into account
Result
Creation of a uniform data structure using the flexible Data Vault modeling approach

Case study on building a modern data architecture using data vault modeling

Aachener Grundvermögen has been accelerating its transformation into a data-driven company for some time now. A new data architecture is intended to help optimize business processes and develop an in-depth understanding of investors. However, it faces challenges such as data inconsistencies, reliance on outdated tools such as Excel and a lack of effective code versioning, which makes simultaneous development difficult and increases the risk of errors and conflicts.

Together with taod, Aachener Grundvermögen is introducing a modern data architecture with cloud solutions and the Data Vault modeling approach. This makes data management more standardized and transparent. The introduction of the new data model facilitates the integration of different data sources and promotes an agile development environment. With this initiative, Aachener Grundvermögen is positioning itself at the forefront of digital modernization in the real estate sector.

Industry / Sector
  • Investment company
The challenge
  • Mapping business logic
  • Increase data quality
  • Promoting company-wide acceptance
Solution
Creation of a uniform data structure using the flexible Data Vault modeling approach
Result
In collaboration with taod, Aachener Grundvermögen has developed a data-driven infrastructure that optimizes the handling of extensive real estate data. The introduction of Data Vault as a modeling approach ensures data quality and creates a flexible data structure that enables the smooth connection of different source systems and extensions.

From traditional data management to modern data architecture

Aachener Grundvermögen's project aims to transform the company into a data-driven organization. The core of this project consists of building a modern data architecture based on an advanced tech stack, including the cloud data warehouse Snowflake and the transformation tool dbt. These technological innovations are designed to optimize business processes and enable a deeper understanding of investors.

Kick-off workshop and definition of the data strategy

At the beginning of the project, taod conducts a kick-off workshop to define the business requirements and develop a suitable data strategy for Aachener Grundvermögen. In this phase, the needs of the various specialist departments are collected in order to understand which data is relevant for the letting of properties, contract management and other business processes. Based on these findings, a high-level data architecture is designed that takes into account not only current but also future requirements. This architecture will be closely aligned with the company's specific services and tested for effectiveness.

Creation of a prototype and development of the data model

The team then begins to build a prototype to test the architecture and data model in practice. The taod data engineers develop an initial data model in Snowflake, based on the Data Vault approach, to integrate the different data sources and create a modular and scalable structure. The prototype is used to simulate the integration of various internal and external data sources such as SAP, hystreet and Open Street Map and to validate the effectiveness of the data architecture.

Agile development and iterative adjustments

By using Data Vault, the team can create an agile development environment in which feedback is continuously obtained and implemented. This iterative approach made it possible to gradually improve the data model and tailor it precisely to the needs of the specialist departments.

Implementation and integration into the cloud environment

Once the prototype had been successfully tested, the implementation of the complete data architecture and the migration of existing on-premise solutions to the cloud began. This included setting up Apache Airflow to orchestrate the data integration processes and connecting to Power BI for reporting. The cloud-based environment allowed Aachener Grundvermögen to react flexibly to changing business conditions and to scale performance dynamically.

Rollout and basis for future projects

With the successful establishment of the new data infrastructure, the system was gradually transferred to operations. At the same time, regular workshops and training sessions were held to promote acceptance and understanding of the data-driven way of working within the company. The project did not end with the rollout, but is moving into a phase of continuous optimization in which further use cases will be developed and implemented to further improve and expand the data-driven processes.

The modern data structures established by Aachener Grundvermögen together with taod open up a wide range of possibilities for future initiatives, such as the development of AI chatbots and predictive analytics. These innovations will help the company to further strengthen its position as a progressive player in the industry.

"By cleverly linking data, we have not only optimized our internal processes, but also broken down data silos, giving us a decisive competitive advantage."

Vanessa Kremer

Chapter Lead Data & Analytics

More on the topics of data engineering, cloud and Snowflake

BI & Data Analytics Consulting taod Consulting
Service

Data Engineering Consulting

From analysis to cloud implementation: we boost your data management strategically and technologically.

To the service

Whitepaper

Cloud Data Solutions

A compact overview of the most important terms, technologies and cloud models.

Read now
Tableau vs. Power BI Whitepaper
Technology

Snowflake advice

We help you to set up a cloud data warehouse, develop a scalable data model and bundle your data in a central location.

Learn more
Your contact to us

Do you have a similar use case or questions about our case? Just write to us!

Sabrina Tonnicchi
Sales Consultant
Stay up to date with our monthly newsletter. All new white papers, blog articles and information included.
Subscribe to our newsletter
Company headquarters Cologne

taod Consulting GmbH
Oskar-Jäger-Str. 173, K4
50825 Cologne‍‍‍
Hamburg location

taod Consulting GmbH
Alter Wall 32
20457 Hamburg‍‍‍‍
Stuttgart location

taod Consulting GmbH
Schelmenwasenstraße 37
70567 Stuttgart