Customized Data Vault 2.0 Training

INFO DELIVERY TOPICS

� Common requirements in info delivery � Introduction to Data Vault 2.0 Architecture � Business Vault reviewed � Advanced Business Vault patterns � Information marts and target models reviewed � Agile delivery of information assets � PIT and bridge tables for performance tuning � Introduction to multi-temporal solutions � Real-time information delivery � Information delivery in CDC environments � Multi-active information delivery � Use of reference data in information delivery � Optimizing data flows for resource consumption

MULTI-TEMPORAL TOPICS

� Introduction to different timelines � Temporality in EDW’s � Temporal SQL functions and performance considerations � Satellite data cases � Building & Loading PITs and Bridges � Real-time issues with Load Dates � Temporal data and CDC � Temporal multi-active data � Dual Entry Aggregates � Master data temporality � Information delivery: Dimensions � Information delivery: Facts � Managing storage consumption (Multi-Temporal)

FURTHER TOPICS

� Effort estimation � Concept modeling � Regular expressions for data warehouse � Data Vault query patterns � Information delivery (efficient dashboarding and reporting) � Data Vault testing � Data Vault refactoring � Performance tuning � Visual Data Vault modeling � Information requirements analysis � Automation & tools (dbt, Vaultspeed, Wherescape) � Specific database knowledge (Snowflake, Synape, BigQuery, Oracle, Microsoft SQL Serv er, PostgreSQL & derivates, etc.)

4/6

Data Vault 2.0 Customized Training | Scalefree 2023