Data Vault: Building a Scalable Data Warehouse Training Course
Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its flexible, scalable, consistent and adaptable design encompasses the best aspects of 3rd normal form (3NF) and star schema.
In this instructor-led, live training, participants will learn how to build a Data Vault.
By the end of this training, participants will be able to:
- Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
- Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
- Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
- Build and deploy highly scalable and repeatable warehouses.
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Course Outline
Introduction
- The shortcomings of existing data warehouse data modeling architectures
- Benefits of Data Vault modeling
Overview of Data Vault architecture and design principles
- SEI / CMM / Compliance
Data Vault applications
- Dynamic Data Warehousing
- Exploration Warehousing
- In-Database Data Mining
- Rapid Linking of External Information
Data Vault components
- Hubs, Links, Satellites
Building a Data Vault
Modeling Hubs, Links and Satellites
Data Vault reference rules
How components interact with each other
Modeling and populating a Data Vault
Converting 3NF OLTP to a Data Vault Enterprise Data Warehouse (EDW)
Understanding load dates, end-dates, and join operations
Business keys, relationships, link tables and join techniques
Query techniques
Load processing and query processing
Overview of Matrix Methodology
Getting data into data entities
Loading Hub Entities
Loading Link Entities
Loading Satellites
Using SEI/CMM Level 5 templates to obtain repeatable, reliable, and quantifiable results
Developing a consistent and repeatable ETL (Extract, Transform, Load) process
Building and deploying highly scalable and repeatable warehouses
Closing remarks
Requirements
- An understanding of data warehousing concepts
- An understanding of database and data modeling concepts
Audience
- Data modelers
- Data warehousing specialist
- Business Intelligence specialists
- Data engineers
- Database administrators
Open Training Courses require 5+ participants.
Data Vault: Building a Scalable Data Warehouse Training Course - Booking
Data Vault: Building a Scalable Data Warehouse Training Course - Enquiry
Data Vault: Building a Scalable Data Warehouse - Consultancy Enquiry
Testimonials (1)
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
Provisional Courses
Related Courses
Data Ethics
14 HoursData Ethics is the field concerned with responsible data collection, usage, and decision-making in ways that uphold human rights, privacy, transparency, and fairness.
This instructor-led, live training (online or onsite) is aimed at public sector professionals with limited or no prior training in data ethics who manage or govern data and wish to understand ethical risks, evaluate real-world dilemmas, and apply principles of responsible data use in alignment with institutional values and public trust.
By the end of this training, participants will be able to:
- Define key concepts and frameworks in data ethics.
- Identify ethical risks and trade-offs in data collection, analysis, and deployment.
- Apply principles of transparency, consent, and fairness to real-world scenarios.
- Integrate ethical review into governance or operational workflows.
Format of the Course
- Interactive lecture and discussion.
- Hands-on analysis of real-world data ethics cases.
- Guided exercises focused on ethical evaluation and policy alignment.
Course Customization Options
- To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.
Data Integrity and Availability
14 HoursData Integrity and Availability is the discipline of ensuring that data remains accurate, complete, consistent, and accessible when needed, especially in high-trust public sector environments.
This instructor-led, live training (online or onsite) is aimed at public sector professionals responsible for managing or safeguarding data—regardless of their technical background—who wish to ensure the reliability, consistency, and availability of critical datasets and systems under their control.
By the end of this training, participants will be able to:
- Define and differentiate the principles of integrity and availability in the data lifecycle.
- Detect and prevent data corruption, inconsistency, or unauthorized alterations.
- Design data environments that ensure high availability and business continuity.
- Implement policies and controls that promote long-term data reliability.
Format of the Course
- Interactive lecture and discussion.
- Hands-on evaluation of data risks and failure points.
- Guided exercises focused on policy development and incident prevention.
Course Customization Options
- To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.
Data Policies and Standards
14 HoursData Policies and Standards is the structured approach to ensuring that government data is created, maintained, accessed, and used in ways that are consistent, secure, and aligned with legal and ethical guidelines.
This instructor-led, live training (online or onsite) is aimed at public sector professionals responsible for setting or applying data policies—regardless of technical background—who wish to standardize, document, and enforce data practices across departments or systems.
By the end of this training, participants will be able to:
- Define and differentiate between data policies, standards, and procedures.
- Draft and evaluate data governance policies aligned with national and international frameworks.
- Promote consistent and high-quality data practices across teams and departments.
- Build a foundation for compliance, audit readiness, and trustworthy data systems.
Format of the Course
- Interactive lecture and discussion.
- Hands-on drafting of sample policies and standards.
- Guided evaluation of existing data workflows and controls.
Course Customization Options
- To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.
Data Strategy
14 HoursData Strategy is the long-term plan for how an organization will manage, use, and invest in data to drive its mission, improve public services, and ensure accountability.
This instructor-led, live training (online or onsite) is aimed at public sector professionals with limited or emerging experience in data strategy who shape or influence strategic decisions and wish to develop sustainable, mission-aligned data strategies across their organization or department.
By the end of this training, participants will be able to:
- Define key elements of a comprehensive data strategy.
- Align data initiatives with organizational objectives and public value.
- Develop roadmaps for data governance, infrastructure, skills, and innovation.
- Evaluate maturity and progress toward becoming a data-driven organization.
Format of the Course
- Interactive lecture and discussion.
- Hands-on development of strategy components and roadmaps.
- Guided analysis of public sector case studies and strategic frameworks.
Course Customization Options
- To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.
EBX5 for Developers
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to use EBX5 (TIBCO EBX) to enable a Master Data Management solution within their organization.
By the end of this training, participants will be able to:
- Interpret requirements and architect an MDM solution.
- Enable the management and integration of master data.
- Integrate and transfer data across multiple systems.
- Import data into EBX5 using match and merge logic.
- Design, create and document a data model that addresses their organization's business requirements.
- Integrate EBX5 with 3rd party services.
RODO / GDPR - legal changes, theoretical introduction, practical aspects
14 HoursGDPR, i.e. the General Data Protection Regulation, is a legal regulation of the European Union introduced in May 2018, aimed at protecting the privacy and personal data of EU citizens. Here are some key points about the GDPR: The GDPR regulates how EU citizens' personal data is collected, stored, processed and transferred, giving them control over their data. Applies to all organizations that process personal data of EU persons, regardless of the location of these organizations. It provides a wide range of individual rights, such as the right to information, access to data, correction of data, deletion of data ("right to be forgotten"), data portability and objection to data processing. It imposes on organizations the obligation to ensure data security, consent to data processing, maintain data processing registers, and apply appropriate technical and organizational measures to protect data. It regulates the transfer of personal data outside the EU to third countries, requiring appropriate data protection measures. In some cases, organizations are required to appoint a Data Protection Officer to oversee compliance with GDPR regulations. GDPR aims to provide greater protection for privacy and personal data, and organizations are obliged to comply with these regulations to ensure an adequate level of protection for the personal data of their users and customers.
GDPR Workshop
7 HoursMaster the General Data Protection Regulation essentials in an intensive one-day workshop designed for managers, department heads, and compliance staff. Covers GDPR foundations, data subject rights, data protection principles, consent requirements, breach notification obligations, and privacy by design. Provides practical frameworks for implementing GDPR compliance strategies across your organization, ensuring lawful data processing and building a culture of accountability in data protection.
Oracle GoldenGate
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at sysadmins and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation.
By the end of this training, participants will be able to:
- Install and configure Oracle GoldenGate.
- Understand Oracle databases replication using the Oracle GoldenGate tool.
- Understand the Oracle GoldenGate architecture.
- Configure and perform a database replication and migration.
- Optimize Oracle GoldenGate performance and troubleshoot issues.
Personal Data Protection Officer - Basic Level
21 HoursPurpose of the Training
- Acquainting the audience with systematized, comprehensive issues of the functioning of personal data protection on the basis of Polish and European law
- Providing practical knowledge about the new rules for the processing of personal data
- Presentation of the areas of the greatest legal risks in connection with the entry into force of the GDPR
- Practical preparation for independent performance of the duties of a Personal Data Protection Officer
Personal Data Protection Officer - Advanced Level
14 HoursPurpose of the Training
- Gaining practical knowledge on how to perform the tasks of the Inspector
- Gaining practical knowledge of how to audit and how to assess risk
- Providing practical knowledge about the new rules for the processing of personal data
Privacy in Federal Institutions (Requirements under the Privacy Act)
7 HoursPrivacy in Federal Institutions is a foundational course focused on the Privacy Act and its requirements for protecting personal information in government operations.
This instructor-led, live training (online or onsite) is aimed at public sector professionals with limited or emerging experience in privacy legislation who manage or process citizen data and wish to ensure compliance with the Privacy Act and related federal standards.
By the end of this training, participants will be able to:
- Understand the key provisions and principles of the Privacy Act.
- Identify personal information and handle it in accordance with legal obligations.
- Develop and implement privacy-compliant practices in day-to-day operations.
- Respond effectively to access to information and correction requests.
Format of the Course
- Interactive lecture and discussion.
- Hands-on use of policy scenarios in public sector contexts.
- Guided exercises focused on compliance, documentation, and reporting.
Course Customization Options
- To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.
Talend Administration Center (TAC)
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at system administrators, data scientists, and business analysts who wish to set up Talend Administration Center to deploy and manage the organization's roles and tasks.
By the end of this training, participants will be able to:
- Install and configure Talend Administration Center.
- Understand and implement Talend management fundamentals.
- Build, deploy, and run business projects or tasks in Talend.
- Monitor the security of datasets and develop business routines based on the TAC framework.
- Obtain a broader comprehension of big data applications.
Talend Big Data Integration
28 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at technical persons who wish to deploy Talend Open Studio for Big Data to simplifying the process of reading and crunching through Big Data.
By the end of this training, participants will be able to:
- Install and configure Talend Open Studio for Big Data.
- Connect with Big Data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
- Understand and set up Open Studio's big data components and connectors.
- Configure parameters to automatically generate MapReduce code.
- Use Open Studio's drag-and-drop interface to run Hadoop jobs.
- Prototype big data pipelines.
- Automate big data integration projects.
Talend Data Stewardship
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner to intermediate-level data analysts who wish to deepen their understanding and skills in managing and improving data quality using Talend Data Stewardship.
By the end of this training, participants will be able to:
- Gain a comprehensive understanding of the role of data stewardship in maintaining data quality.
- Use Talend Data Stewardship for managing data quality tasks.
- Create, assign, and manage tasks within Talend Data Stewardship, including workflow customization.
- Use the tool's reporting and monitoring capabilities to track data quality and stewardship efforts.
Talend Open Studio for ESB
21 HoursIn this instructor-led, live training in Poland, participants will learn how to use Talend Open Studio for ESB to create, connect, mediate and manage services and their interactions.
By the end of this training, participants will be able to
- Integrate, enhance and deliver ESB technologies as single packages in a variety of deployment environments.
- Understand and utilize Talend Open Studio's most used components.
- Integrate any application, database, API, or Web services.
- Seamlessly integrate heterogeneous systems and applications.
- Embed existing Java code libraries to extend projects.
- Leverage community components and code to extend projects.
- Rapidly integrate systems, applications and data sources within a drag-and-drop Eclipse environment.
- Reduce development time and maintenance costs by generating optimized, reusable code.