C3-X-MS-DV (Beginner)

Practical exercises with step-by-step instructions for the biGENIUS-X Microsoft SQL Server Data Vault Generator:

1. Setup
2. Setup Solution and Project
3. Add source system and discover
4. Define Raw Vault Hubs
5. Define Raw Vault Satellites
6. Define Raw Vault Links
7. Add transactional data
8. Add a new source
9. Define PIT tables
10. Define Current Views
11. Create a reference table and work with a Raw Vault Composite
12. Define Business Vault objects
13. Define Business Vault objects
14. Define Business Vault objects
15. Define Business Vault objects
16. Build a Data Mart

To obtain the biGENIUS-X Engineer certification, you would need to pass an online exam with 47 questions.

‍

biGENIUS Expert Guidance

Boost your e-learning experience with personalized, on-demand support from our biGENIUS experts. The add-on lets you schedule live 1:1 sessions for guidance on training content and hands-on exercises.

Knowledge prerequisites

• Completion of module: C1-X – Introduction to biGENIUS-X
• Completion of module C2-X – biGENIUS-X application features
• SQL Server basics
• Data Vault 2.0 modeling basic knowledge

Here are some links that will help you better understand data vault modeling:

• Understanding data vault 2.0    
• Data vault modeling wiki

Technical prerequisites

• Please prepare your training environment as instructed in this biGENIUS-X Knowledge Base article: Target environment for Microsoft SQL Server‍
• We suggest you use a Docker image instead of installing a local SQL server.
• If you use a local installation, you must know how to use and configure SQL Server before starting this training.
• No additional support from biGENIUS will be provided regarding your SQL Server installation and configuration.