Sandra Krenn

Jan 26 2021

Handling Validation of Relationships in Data Vault 2.0

Validation of Relationships in Data Vault 2.0 There are different ways of handling validation of relationships from source systems depending on how the data is delivered, (full-extract or CDC), and…

Nov 24 2020

Salesforce Meets Data Vault

By Sandra Krenn Data Tools No Comments

It’s a Match! Data integration with Salesforce can be tricky and is in dire need of a system of business intelligence to handle that complexity. Data Vault is capable of…

Oct 27 2020

Data Quality in the Data Vault Architecture

By Sandra Krenn Data Architecture No Comments

The Basis for solid decision-making In making business decisions whether daily or long term, the quality of data is a critical facet to factor into these decision-making processes. Thus, the…

Sep 29 2020

Write Backs in the Enterprise Data Warehouse Architecture

By Sandra Krenn Data Architecture One Comment

Many people already know the three layer architecture of data warehouses which is used in Data Vault 2.0. The first layer represents the staging area which holds the raw data…

Aug 25 2020

Data Vault Use Cases Beyond Classical Reporting – Part 3

By Sandra Krenn Data Vault, Intermediate No Comments

New Possibilities with Data Vault 2.0 Data Vault 2.0 empowers organizations to go beyond traditional reporting by unlocking new avenues for scalability, automation, and data-driven decision-making. From cleansing data and…

Jul 28 2020

Satellite Modeling for Any Structural Changes in the Source System

By Sandra Krenn Data Modeling No Comments

Modeling a Satellite in the instance of any structural changes within the source system Over time, most source systems change. The question is how to absorb these changes into the…

Jun 30 2020

Splitting a Satellite Entity Based on the Source Data

By Sandra Krenn Data Vault No Comments

Satellite splitting criteria plays a vital role in a satellite’s structure. Being such, it is not recommended that the entirety of descriptive data related to a business key should be…

May 28 2020

Recommended Naming Conventions for EDW layers

What to Consider for Naming Conventions in Data Warehousing – Part 2

By Sandra Krenn Data Architecture No Comments

Naming Conventions in Data Warehousing Throughout this article, we will continue presenting our suggestions for naming conventions in a data warehouse solution, as well as sharing examples for naming standards,…

Jan 28 2020

Delete and Change Handling Approaches in Data Vault 2.0 Without a Trail

By Sandra Krenn Data Vault 3 Comments

In this article we will show you how to use counter records for change or delete practices in Data Vault 2.0. In January of this year, we published a piece…

Dec 11 2019

Data Vault Use Cases Beyond Classical Reporting – Part 2

By Sandra Krenn Data Vault, Intermediate No Comments

The Role of the Enterprise Data Warehouse The Enterprise Data Warehouse (EDW) is no longer limited to reporting and dashboarding; it is a powerful tool for driving business process automation…

Handling Validation of Relationships in Data Vault 2.0

Salesforce Meets Data Vault

Data Quality in the Data Vault Architecture

Write Backs in the Enterprise Data Warehouse Architecture

Data Vault Use Cases Beyond Classical Reporting – Part 3

Satellite Modeling for Any Structural Changes in the Source System

Splitting a Satellite Entity Based on the Source Data

What to Consider for Naming Conventions in Data Warehousing – Part 2

Delete and Change Handling Approaches in Data Vault 2.0 Without a Trail

Data Vault Use Cases Beyond Classical Reporting – Part 2

Subscribe to our
free monthly newsletter

Subscribe to our
free monthly newsletter

SOLUTIONS

TRAININGS

EVENTS

KNOWLEDGE HUB

CAREERS

COMPANY

Sandra Krenn

Subscribe to our free monthly newsletter

Subscribe to our free monthly newsletter

SOLUTIONS

TRAININGS

EVENTS

KNOWLEDGE HUB

CAREERS

COMPANY

Subscribe to our
free monthly newsletter

Subscribe to our
free monthly newsletter