BI,White Paper
CUSTOMIZED TRAINING DATA VAULT 2.0 FULLY CUSTOMIZED TO YOUR SPECIAL REQUIREMENTS
ACCESS THE NEW AGE OF DATA WAREHOUSING
Data Vault 2.0 brings many new features that help anyone who is concerned with Business Intelligence entering a new age of data warehousing.
Data Vault is a concept for data warehousing that integrates relational data warehousing with unstructured data warehousing in real- time. It is an extensible data model where new data sources are easy to add. Moreover the agile methodology is based on Scrum and the disciplined agile methodology which uses the data model for a rapid buildout of the data warehouse. The reference architecture of Data Vault 2.0 supports not only structured data sources, but also semi-structured and unstructured such as Hadoop and real-time systems.
The concept of Data Vault 2.0. based on the four pillars:
Data Vault 2.0
We got some impressive insights from the the trainer what helped us a lot to start implementing the Data Vault. ~ Customized Training participant
LEARN MORE ABOUT OUR CUSTOMIZED TRAINING
The Customized Training is a one-day class which is typically provided in-house or for special interest groups. Training can range anywhere from half-day (only user groups) to one-day (in-house training fully customized to the requirements of the company) or anywhere up to five full days. Depending on the schedule, the class may include a certification. The certi-
cation requires a three day class with similar content like the Data Vault 2.0 Boot Camp with private certification. This Data Vault Customized Training is designed especially for project managers, IT implementers, data architects, business analysts, data modelers and ETL programmers.
2/6
Data Vault 2.0 Customized Training | Scalefree 2023
THE CUSTOMIZED TRAINING IN DETAIL
The company can adjust the schedule of the class to their specific requirements. The following training agenda example is spread over four days:
BOOT CAMP TOPICS
� What is Data Vault 2.0? � Issues faced today � Data Vault in business � Lowering total cost of ownership � Architecture components � ELT/ETL Performance Tuning � Applying set logic � Loading architecture � Column compare and hash diff � Managed self-service BI � What are your agility issues? � Agile delivery and methodology � Roles & releases � Agile requirements management � Technical numbering � Methodology and CMMI® � Staging load templates � Data Vault 2.0 loading templates � End dating satellite templates � Real-time loading and IoT � PIT and bridge templates � Dealing with corrupted data � Concept modeling
� Defining common terminology � Hashing and sequences � Core Data Vault structures � Data Vault modeling constructs � Standards � Common attributes � Effectivity � Status tracking � Delete tracking � Modeling for audit trails � How to change grain � Detecting structure changes � Business Vault examples � Historical Vault Modeling � How to integrate changes
� Table overloading � Splitting/merging � BK’s in Satellites
� Normalization in staging areas � Dimensional modeling from DV � Determining business key overlap/ overloading
3/6
Data Vault 2.0 Customized Training | Scalefree 2023
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
ABOUT THE CERTIFICATION This class can be completed with a certification test online. After successful completion of the test, the student will receive a certificate, granted the lifetime assignment “Certified Data Vault 2.0 Practitioner” and will be listed on the certification list on datavaultcertification.com.
THE FOUNDERS 50 YEARS OF VIVID IT EXPERIENCE
Scalefree presents the Data Vault 2.0 System of Business Intelligence; the concept that grows with your data needs without running into limitations of scale. Data Vault 2.0 contains the first data warehouse system to increase scale without limits. Set up now, for all your future Big Data needs. Our clients understand what it means to have a lot of data. They are global automotive brands, large banks and governments. Initially developed for the U.S. government, Dan Linstedt and Michael Olschimke are now bringing this technology to the industry for everyone to use
DAN LINSTEDT Dan is a thought leader and pioneer of data wa- rehousing. He invented Data Vault 2.0 and complete Data Vault 2.0 System of Business Intelligence. He has built transactional and analytical systems for federal government and commercial enterprises for more than 30 years. He understands the needs, structures and priorities of clients. All in all, he provides sound expert advice tailored to the business scenario of clients.
MICHAEL OLSCHIMKE Michael has more than 20 years of experience in Information Technology. Specifically, the last eight years he has been working business intelligence topics like OLAP, dimensional modeling, and data mining. He has consulted for a number of clients in the automotive, insurance, banking, and non-profit industries. In addition, he has acted as a Business Intelligence consultant for government organizations in Germany.
*CDVP2 is a registered trademark of Empowered Holdings, LLC
5/6
Data Vault 2.0 Customized Training | Scalefree 2023
Scalefree International GmbH Schützenallee 3 30519 Hannover, Germany
P: +49 (511) 879 893 41 M:+49 (175) 811 0336 F: +49 (511) 879 893 49
info@scalefree.com www.scalefree.com
CEO: Michael Olschimke & Christof Wenzeritt
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6Powered by FlippingBook