Data Vault Modeling Seminar
Who needs to attend? The target audience for this course includes data warehousing and business intelligence professionals, data modelers, data architects, model managers, data warehouse DBAs, and ETL professionals. Because data vault modeling concepts are closely aligned with the business aspects of DWBI programs our target audience also includes program managers, business analysts, information modelers, information architects, BICC professionals, and data scientists.
The Data Vault Approach focuses on a realistic and repeatable way to build your EDW
About us
Actbayan Solutions
Established in 2007, Actbayan Pte Ltd is a Singapore based company that specializes in designing data warehouse.
Roy Baldonado, the principal consultant of Actbayan Solutions with over 25 years of experience. He specializes in IBM and Teradata Industry model, focusing on financial models.
Data warehouses have been at the forefront of information technology applications as a way for organizations to effectively use digital information for business planning and decision making. As information professionals, without a doubt, we encounter the data warehouse phenomenon if we have not already been exposed to it in our work. Hence, an understanding of data warehouse system architecture is important in our roles and responsibilities in information management.
Why the Data Vault?
The Data Vault is simply the optimal modeling approach for the EDW.
Just as 3rd Normal Form is ideal for operational systems, and Star Schema is great for data marts and analytics, so the Data Vault is optimal for the Enterprise Data Warehouse.
Data Vault Modeling Approach & Methodology
The Data Vault modeling approach is rapidly being accepted as THE way to build enterprise data warehouses. The Data Vault model consists of Hubs, Links, and Satellites – and is flexible, scalable, and auditable. The Data Vault Approach focuses on a realistic and repeatable way to build your EDW
Beyond every data there is information. Our passion is to build the new architecture of information.
Our services
What is our competency?
Data modelling using reference on Industry Mode.
Technical Architecture in ETL
Data Quality Assurance Review
Data Analysis and mapping
Domain Management
Issue Management
Good design is good business.
TRAINING
Course Structure
This course is a three day intensive classroom based course. The course consists of five core components plus certification exam. The classroom time is based on:
• 40% Classroom Lecture
• 30% Small Group Exercise
• 30% Interactive Discussion.
Day 1
COVERAGE
- Data Vault constructs of Hub Link and Satellite
- Impact of Data Vault the benefits of applying this model
- Sales Receipt example modeling with Data Vault
- Deep dive into Hub design
- Group Case: Secaucus Soccer
- Deep dive into Link Design
- Group Case: Mt Evans Harley
- Advanced Constructs
- Assign Integration Case
Day 2
COVERAGE
- Group Case: Integration Case
- Working with Data Vault
- Loading Pradigms
- Applying to the EDW
- Data Vault in Practice
Day 3
COVERAGE
- Exam Review and Discussions
- CDVDM Exam