Yale University showcased its Datavault journey at the Data Vault North America User Group in September 2023.

Yale recognized the urgent need to consolidate data for improved reporting and analytics, breaking free from the constraints of information silos. This led to the strategic development of an Enterprise Common Reporting platform.

The Datavault Journey:
Yale embarked on a journey to implement a Data Vault strategy, focusing on unifying critical data streams in People, Space, Finance, and Academics while fostering self-service capabilities and preserving historical information.

Design Goals:
The platform was designed with a focus on flexibility, repeatability, reliability, and high quality, enabling rapid adjustments, replicable processes, data integrity, and dependable reporting.

Simplified Processes & Leveraging Metadata-Driven Code Generation for ETL/ELT:
Yale embraced simplification by breaking down complex processes, leveraging reusable patterns, and generating code from metadata, particularly using SQL.

In 2016, it developed its first DV 2.0 Data Warehouse, hand-coded. Subsequently, it decided to utilize the Business Model-Driven Data Warehouse Automation tool, Datavault Builder, for future Data Warehouse projects.

Datavault Builder’s Impact:
Transitioning to Datavault Builder delivered significant benefits:

1. Productivity and Time to Insights:

2. Data Warehouse Extension:

3. Team Resources:

Hand coding vs model driven development approach (original presentation slide of Yale University)

Datavault Builder supported Yale in implementing an Enterprise Common Reporting platform, meeting design goals, and minimizing the total cost of ownership.

The 75% cost savings, reduced time to insights, and optimized team roles and composition reduced complexity in team management.