Challenge: Automated Build Out Results: 2 people in 2 weeks merged 3 systems, built a full EDW 5 star schemas 3 BI reports zero production errors Generated: 90% of the ETL code 100% of the Staging Data Model 75% of the finished EDW data
Success Stories
Challenge:Rapid Merger and Acuqisition Results: Merged 3 companies in 90 days (Circa 2001) ALL systems, ALL DATA! 125 people, multiple cultures Business Value produced during Due Diligence phase. JP Morgan Chase used the Data Vault model, methodology and architecture to perform due diligence, and
Challenge: Minimized Re-Engineering and Full Auditability Results: “Data Vault 2.0 delivers full auditability by protecting the integrity and origin of the data.” “For us, the Data Vault 2.0 has provided significant benefits. We were able to change our data warehouse whilst minimizing the re-engineering
Challenge: Government Agencies Sharing Data Results: CBS (central bureau of statistics) and Belastingdienst (Dutch tax authority) Share Data Between the Agencies By Leveraging Data Vault 2.0 Data Models And leveraging DV2.0 Processes
Challenge: Team Size Scalability / Elasticity… Scaling Team Sizes: (Circa 2009) Grew team to 60 people for two weeks Shrunk team to 20 critical staff for business delivery (6 weeks) Included Entry Level When Needed They had a need to increase the team size
Challenge: Scalability with No Re-Engineering Produced Data Vault, Scaled to 3 Petabytes (circa 2003) still growing today Sub-second query responses Zero re-engineering to add more data, and expand This project was done to serve the needs of the public. They captured real-time streams that
Challenge: Replace Legacy Solution Results: 5 Year Program, Finished in 4 years!(Circa 2011-2016) 1 year Early 1 year under-budget! “Balance within 1/10th of 1% Because of the Data Vault”, CFO This program was setup to be a 5 year program. One of the
Challenge: Achieving Agility in the Methodology Results: “DV2.0 brings the assurance that we can cope with an increased velocity in change, without falling behind in our ability to support time sensitive decision-making. The quality improvement and estimate accuracy resulting from the disciplined process are
Challenge: Unstructured Image Processing in Real Time Results: Ingesting 100,000 images per second across 10 parallel streams, creating business value by capturing Satellite Images of weather, hashing them for correlation analysis. (Circa 2001, still in use today) Turning unstructured data into information in real-time!
Challenge: Closing Operational Gaps Results: Cendant Timeshare Resource Group implemented Operational Data Vault, eliminating all other sources and rewriting their application. Increased their profitability by 2.5x in 24 months. (Circa 2003) Managed 100,000 properties world wide. Cendant had 5 disparate operational systems, and 2