Level: C2

This module consists of labs based on the Microsoft generator and data vault modeling (hubs, satellites and links). After following this course, you will be able to do the exam and to receive a biGENIUS Engineer badge if successful.

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:

Duration

• 2 days
• Exam: 1 hour

Goal

• Be able to participate in the development of a biGENIUS project.
• Acquire the needed knowledge to pass the certification exam biGENIUS Engineer.
• Obtain the biGENIUS Engineer badge.

Target Group

• Consultants
• Data warehouse developers
• Data warehouse project managers

Content

Practical Microsoft labs for Data Vault modeling step by step:
‍
1. Setup biGENIUS
3. Setup a project
3. Working with the biGENIUS application
4. Add source systems
5. Define Raw Data Vault Objects: Hubs
6. Define Raw Data Vault Objects: Satellites
7. Define Raw Data Vault Objects: Links
8. Add Transactional Data
9. Add a new Source
10. Configuration Options
11. Create a Reference Table and work with a Stage Composite object
12. Inspect Automatically Generated Business Vault Objects
13. Define Business Vault Objects - Hub
14. Define Business Vault Objects - Satellite
15. Define Business Vault Objects - Link

Exam for the certification: online quiz with 58 questions.

To enroll

Access to our e-Learning platform within 2 weeks after subscription.

biGENIUS Expert Guidance add-on: a biGENIUS expert can be available for online support on a specific day (with prior agreement) between 08:00-17:30 (CET) during the completion of the e-Learning module upon request during the registration process. An additional cost of 680 CHF / 680 EUR / 750 USD will be applied.

A link to a Microsoft Teams session will be provided after subscription and confirmation of the date.

Technical prerequisites

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).

Documentation

Course materials are provided in English.

This module consists of labs based on the Snowflake generator and data vault modeling (hubs, satellites and links). After following this course, you will be able to do the exam and to receive a biGENIUS Engineer badge if successful.

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:

Duration

• 2 days
• Exam: 1 hour

Goal

• Be able to participate in the development of a biGENIUS project.
• Acquire the needed knowledge to pass the certification exam biGENIUS Engineer.
• Obtain the biGENIUS Engineer badge.

Target Group

• Consultants
• Data warehouse developers
• Data warehouse project managers

Content

Practical Snowflake labs for data vault modeling step by step:

1. Understand environment
2. Setup a project
3. Working with the biGENIUS application
4. Add source systems
5. Define Raw Data Vault Objects: Hubs
6. Define Raw Data Vault Objects: Satellites
7. Define Raw Data Vault Objects: Links
8. Add Transactional Data
9. Add a new Source
10. Configuration Options
11. Create a Reference Table and work with a Stage Composite object
12. Inspect Automatically Generated Business Vault Objects
13. Define Business Vault Objects - Hub
14. Define Business Vault Objects - Satellite
15. Define Business Vault Objects - Link

Exam for the certification: online quiz with 58 questions.

To enroll

Access to our e-Learning platform within 2 weeks after subscription.

biGENIUS Expert Guidance add-on: a biGENIUS expert can be available for online support on a specific day (with prior agreement) between 08:00-17:30 (CET) during the completion of the e-Learning module upon request during the registration process. An additional cost of 680 CHF / 680 EUR / 750 USD will be applied.

A link to a Microsoft Teams session will be provided after subscription and confirmation of the date.

Technical prerequisites

The training environment in the AWS Cloud is provided for this training.

The access to this environment involved costs according to the usage. 2 dedicated days (16 hours) should be reserved to do the 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.

Documentation

Course materials are provided in English.

This module consists of labs based on the Amazon Redshift generator and data vault modeling (hubs, satellites and links). After following this course, you will be able to do the exam and to receive a biGENIUS Engineer badge if successful.

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:

Duration

• 2 days
• Exam: 1 hour

Goal

• Be able to participate in the development of a biGENIUS project.
• Acquire the needed knowledge to pass the certification exam biGENIUS Engineer.
• Obtain the biGENIUS Engineer badge.

Target Group

• Consultants
• Data warehouse developers
• Data warehouse project managers

Content

Practical Redshift labs step by step:

1. Understand environment
2. Setup a project
3. Working with the biGENIUS application
4. Add source systems
5. Define Raw Data Vault Objects: Hubs
6. Define Raw Data Vault Objects: Satellites
7. Define Raw Data Vault Objects: Links
8. Add Transactional Data
9. Add a new Source
10. Configuration Options
11. Create a Reference Table and work with a Stage Composite object
12. Inspect Automatically Generated Business Vault Objects
13. Define Business Vault Objects - Hub
14. Define Business Vault Objects - Satellite
15. Define Business Vault Objects - Link

Exam for the certification: online quiz with 58 questions.

To enroll

Access to our e-Learning platform within 2 weeks after subscription.

biGENIUS Expert Guidance add-on: a biGENIUS expert can be available for online support on a specific day (with prior agreement) between 08:00-17:30 (CET) during the completion of the e-Learning module upon request during the registration process. An additional cost of 680 CHF / 680 EUR / 750 USD will be applied.

A link to a Microsoft Teams session will be provided after subscription and confirmation of the date.

Technical prerequisites

The training environment in the AWS Cloud is provided for this training.

The access to this environment involved costs according to the usage. 2 dedicated days (16 hours) should be reserved to do the 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.

Documentation

Course materials provided in English.

This module consists of labs based on the Oracle generator and relational modeling (dimensions and facts with header/version generation). After following this course, you will be able to do the exam and to received a biGENIUS Engineer badge if successful.

Duration

• 2 days
• Exam: 1 hour

Goal

• Be able to participate in the development of a biGENIUS project.
• Acquire the needed knowledge to pass the certification exam biGENIUS Engineer.
• Obtain the biGENIUS Engineer badge.

Target Group

• Consultants
• Data warehouse developers
• Data warehouse project managers

Content

Practical Oracle labs step by step:

1. Setup biGENIUS
3. Setup a project
3. Working with the biGENIUS application
4. Add source systems
5. Define dimensional core objects
6. Define fact based objects
7. Additional Dimensions, Stage Composites, Copy Object and using Union in a DataFlowSet
8. Historization (SCD), Customized Template
9. Dimension Date, Role playing dimensions
10. Cleansing
11. Configuration options
12. Mart Composites, Aggregation

Exam for the certification: online quiz with 58 questions.

To enroll

Access to our e-Learning platform within 2 weeks after subscription.

biGENIUS Expert Guidance add-on: a biGENIUS expert can be available for online support on a specific day (with prior agreement) between 08:00-17:30 (CET) during the completion of the e-Learning module upon request during the registration process. An additional cost of 680 CHF / 680 EUR / 750 USD will be applied.

A link to a Microsoft Teams session will be available for this purpose and sending after the subscription and the validation of the date.

Technical prerequisites

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 and Oracle before starting this training. No support will be provided regarding SQL Server and Oracle installation and configuration.

Please prepare before your training environment with:
- SQL Server 2014 at least
- SQL Server Management Studio
- Oracle 12.2 at least

The installation of biGENIUS® will be part of the beginning of the training (you need to install it locally).

Documentation

Course materials are provided in English.

This module consists of labs based on the Oracle generator and data vault modeling (hubs, satellites and links). After following this course, you will be able to do the exam and to receive a biGENIUS Engineer badge if successful.‍

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:‍

Duration

• 2 days
• Exam: 1 hour

Goal

• Be able to participate in the development of a biGENIUS project.
• Acquire the needed knowledge to pass the certification exam biGENIUS Engineer.
• Obtain the biGENIUS Engineer badge.

Target Group

• Consultants
• Data warehouse developers
• Data warehouse project managers

Content

Practical Oracle labs for Data Vault modeling step by step:
‍
1. Setup biGENIUS
3. Setup a project
3. Working with the biGENIUS application
4. Add source systems
5. Define Raw Data Vault Objects: Hubs
6. Define Raw Data Vault Objects: Satellites
7. Define Raw Data Vault Objects: Links
8. Add Transactional Data
9. Add a new Source
10. Configuration Options
11. Create a Reference Table and work with a Stage Composite object
12. Inspect Automatically Generated Business Vault Objects
13. Define Business Vault Objects - Hub
14. Define Business Vault Objects - Satellite
15. Define Business Vault Objects - LinkExam for the certification: online quiz with 58 questions.

Exam for the certification: online quiz with 58 questions.

To enroll

Access to our e-Learning platform within 2 weeks after subscription.

biGENIUS Expert Guidance add-on: a biGENIUS expert can be available for online support on a specific day (with prior agreement) between 08:00-17:30 (CET) during the completion of the e-Learning module upon request during the registration process. An additional cost of 680 CHF / 680 EUR / 750 USD will be applied.

A link to a Microsoft Teams session will be provided after subscription and confirmation of the date.

Technical prerequisites

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 and Oracle before starting this training. No support will be provided regarding SQL Server and Oracle installation and configuration.

Please prepare before your training environment with:
- SQL Server 2014 at least
- SQL Server Management Studio
- Oracle 12.2 at least

The installation of biGENIUS will be part of the beginning of the training (you need to install it locally).

Documentation

Course materials are provided in English.