Data Vault in a Day
5 February 2015 (10-18h)
Location: Golden Tulip Brussels Airport (Diegem)
Presented in English by Antoine Stelma
Price: 850 EUR (excl. 21% VAT)
This event is history, please check out the List of Upcoming Seminars, or send us an email
Check out these related open workshops:
- Data Modeling Masterclass (April 24-26, 2023)
- Ontwerpen van een Moderne Data-Architectuur (June 5-6, 2023)
Check out our related in-house workshops:
- Apache Spark Hands-On Training (In-Company) (INHOUSE WORKSHOP - On Request)
- Het Logisch Datawarehouse - Architectuur, Ontwerp en Technologie (INHOUSE WORKSHOP - On Request)
- Business Intelligence en Datawarehousing Fundamentals (INHOUSE WORKSHOP - On Request)
- The Hadoop Ecosystem (INHOUSE WORKSHOP - On Request)
- Big Data Oplossingen voor BI (INHOUSE WORKSHOP - On Request)
- Data Vault in a Day (INHOUSE WORKSHOP - On Request)
Learning Objectives
Why do we organise this course on Data Vault and Enterprise Data Warehousing (EDW) ?
Data Vault modelling is quickly becoming the standard approach for modelling the data warehouse. Compared to other popular approaches, Data Vault modelling represents a paradigm shift - a new way of thinking. Realising the full benefits of this approach means embracing this new paradigm in its entirety.
This course is designed to give you a consistent and clear message of the fundamentals of the Data Vault modelling paradigm. It is much more than an introduction: you get a sound and practical overview of the features - in a single day. Because there is so much to say about Data Vault, you also get a lot of exclusive background information, supporting your learning during and after this seminar. The seminar ends with an "assessment exercise" to test your knowledge and understanding of Data Vault.
This course, the background reading material and the assessment test are designed by Hans Hultgren, founder of Genesee Academy and author of the book "Modeling the Agile Data Warehouse with Data Vault (Volume 1)". You get this book free with you participation.
What will you learn in this Data Vault Modelling workshop ?
This course is intended as an initial introduction into the data vault modelling approach. Next to a global introduction, this course covers the modeling components of the data vault - the Hub, Link and Satellite. These components will be illustrated and trained via group exercises. The course ends with an assessment test to see if you have understood the basic theory and practice of Data Vault modelling.
This training is intensive and interactive. During this one-day course we cover:
- What is Data Vault ?
- Why do we need it ?
- What are the major concepts of Data Vault ?
- How does a Data Vault model look like ?
- How does it work ?
- What are core business concepts and enterprisewide business keys ?
- What are hubs, Links, Satellites, backbone models, ... ?
- What are the parts that make up data vault ?
- What are the benefits of using this approach ?
- What are source-driven and business-driven semantics ?
- How do we deal with historical data ?
- How do you apply Data Vault to your own data warehouse program ?
We also discuss the benefits of using this approach and some guidelines as to how we can apply Data Vault modelling to our own data warehouse program. In addition this course covers data warehousing business intelligence considerations that support these techniques as well as some practical modelling topics.
Who should attend this seminar ?
This course is intended for business intelligence and data warehousing professionals seeking a strong introduction to Data Vault modelling. In addition, the course is well suited for those who have heard about Data Vault or are just starting a Data Vault project and who are interested in learning what it means.
This includes but is not limited to:
- Data and Information Modelers
- Data and Information Architects
- Business Analysts
- Business Intelligence and Data Warehousing managers
- Designers, project leads and project owners
- Data Warehousing Database Administrators (DW DBAs)
- Data Mart designers
- Integration Experts and ETL Developers
- Functional Area Representatives
- ...
Because the data vault concepts are closely aligned to the business, those working on data warehousing and business intelligence from both business and technical perspectives will benefit equally from this course.
Full Programme
This course, the background reading material and the assessment test are designed by Hans Hultgren, founder of Genesee Academy and author of the book "Modeling the Agile Data Warehouse with Data Vault (Volume 1)". You get this book free with you participation.
- What is Data Vault?
- When to use it
- How it differs from other approaches (pros and cons)
- Why we need it
- The benefits of this approach
- Modelling Agility
- Unified Decomposition
- Ensemble Modelling
- The Core Business Concept
- The Modelling process
- Architecture Overview
- Data Vault foundation
- Colors analysis
- Forming the Backbone
- Tracking history
- Attributes
- Review of a sample Data Vault Model
- Workbook exercise 2: explanation and group exercise
- Discussion
- Q & A
- Attributes of a hub and their purpose
- Identifying and modelling the business key
- Core concepts versus abstraction
- Multiple keys
- Non-unique keys
- Dealing with duplicates
- Workbook exercise 2: explanation and group exercise
- Discussion
- Q & A
- Natural business relationships
- Business versus source driven
- Transactions, hierarchies, ...
- When a link grows a hub
- Unique relationships
- Circular not an issue
- "The Fly"
- Unit of Work
- Context for the key
- Designing satellites
- Splitting and merging
- Rates of change
- Types of data
- Sources of the data
- Code and Reference Tables versus "Linked Core" concepts
- Multi-valued
- History
- Folding to third normal form (3NF)
- Workbook exercise 3
- Discussion
- Q & A
The groups work on an assignment based on a practical case.
- Presentation, review, analysis and discussion of the group exercise
- Q & A
- Business-driven modelling
- Applying an agile modelling methodology
- Loading the EDW
- Designing and loading data marts sourced from Data Vault models
- Detailed architectural flow of data in the new EDW
- Guidance on how to use the course materials, book, and online resources after class
All participants do a quick assessment test to see if they have understoond the theory and practice of Data Vault modelling. If they pass, they get the Genesee Academy certificate a few weeks later.
Speakers
Antoine Stelma is lead architect and managing consultant at Centennium. As managing consultant, Antoine is a member of the Management Team of Centennium, which is responsible for the vision, strategy and management of Centennium.
Antoine is "Genesee Academy Guest Instructor" and authorised to deliver Genesee Academy trainings around the world.
Antoine also presents various Centennium courses on Business Intelligence and Datawarehousing. Antoine is Certified Data Vault Modeler, Certified Business Intelligence Professional and Oracle Certified Professional.
With over 12 years of experience in Business Intelligence and Datawarehousing, Antoine has very broad and deep knowledge of this market. By doing various jobs such as architect, project leader, information analist, coach and teacher, Antoine is an allrounder in the BI domain. He is a rational person with excellent social and communicative powers.
As lead architect, Antoine is one of the founders of the Centennium Datawarehousing Methodology.
In his advisory role, Antoine is responsible for architectural decisions at his customers. He also leads and supports the group of BI architects at Centennium in their daily job.
Questions about this ? Interested but you can't attend ? Send us an email !