Module C2-MS-DV - biGENIUS® Beginner course Microsoft Generator (Data Vault Modeling) with biGENIUS® Engineer
e-Learning + Online Exam
350 CHF / 330 EUR
biGENIUS® is a Data Warehouse automation tool that was developed to cover the complete life cycle of data warehousing solutions. It maps and supports documentation of business requirements, modeling and generation, data load monitoring and data quality verification. You will learn how to integrate source systems, model DWH structures, generate and deploy the DWH solution to the target environments. The training approach is composed by labs based on the Microsoft generator and a data vault modeling (hubs, satellites and links). After following this course, you will be able to do the exam and to received a biGENIUS® Engineer badge if successfull.
- 2 days
- Exam: 1 hour
- Be able to participate to the development of a biGENIUS® project
- Acquire the needed knowledge to pass the certification exam biGENIUS® Engineer
- Obtain the biGENIUS® Engineer badge
- DWH developers
- DWH project managers
Practical Microsoft labs for Data Vault modeling step by step:
- Setup biGENIUS®
- Setup a project
- Working with the biGENIUS® application
- Add source systems
- Define Raw Data Vault Objects: Hubs
- Define Raw Data Vault Objects: Satellites
- Define Raw Data Vault Objects: Links
- Add Transactional Data
- Add a new Source
- Configuration Options
- Create a Reference Table and work with a Stage Composite object
- Inspect Automatically Generated Business Vault Objects
- Define Business Vault Objects - Hub
- Define Business Vault Objects - Satellite
- Define Business Vault Objects - Link
Exam for the certification: online quizz with 58 questions
Access to our eLearning platform for the next 2 weeks after subscription. A biGENIUS® expert can be available 1 day between 8:30 and 17:30 for answering questions if you ask for it during the registration process (date planned on-demand). An additional cost of 389 CHF / 364 EUR will be applied. A link to a Teams session will be available for this purpose and sending after the subscription and the validation of the date.
The training environment preparation is not part of this training.
It is essential that you have the necessary knowledge to use and configure (in case of local installation) SQL Server before starting this training.
No support will be provided regarding SQL Server installation and configuration.
Please prepare before your training environment with:
- SQL Server 2014 at least
- SQL Server Management Studio
The installation of biGENIUS® will be part of the beginning of the training (you need to install it locally).
Course materials in English
Knowledge of Data Vault 2.0 is required to run this Lab. Here are some links that will help you better understand Data Vault modeling :
- How to create a Data-Vault-Model (https://www.youtube.com/watch?v=Q1qj_LjEawc)
- Data vault modeling (https://en.wikipedia.org/wiki/Data_vault_modeling)
- Official Data Vault Certified Data Modeler and Certification course (https://www.trivadis-training.com/en/training/official-data-vault-certified-data-modeler-and-certification-course-o-dv)
as well as the introduction of biGENIUS®
FOLLOW-UP COURSES AND WORKSHOPS
Please click through the steps and enter your personal information: