e-Learning

Level: C2

Take advantage of these biGENIUS Engineer certified online course and get started with the target technologies and modeling methods of your choice using biGENIUS. Upon completion with this level, you can then move on to level C3 and earn your biGENIUS Expert certifications.

biGENIUS-C2-MS-DIM: Beginner course Microsoft Generator (Dimensional Modeling)

420 CHF / 420 EUR / 460 USD

This module consists of labs based on the Microsoft generator and dimensional modeling (dimensions and facts). After following this course, you will be able to do the exam and to received a biGENIUS Engineer badge if successful.

Prerequisite course: Module C1 - Introduction to biGENIUS

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

Contents

Practical Microsoft 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 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.

biGENIUS-C2-MS-DV: Beginner course Microsoft Generator (Data Vault Modeling)

420 CHF / 420 EUR / 460 USD

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 received a biGENIUS Engineer badge if successful.

Prerequisite course: Module C1 - Introduction to biGENIUS

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
Data vault modeling wiki

Official Data Vault Certified Data Modeler and Certification course

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

Contents

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

biGENIUS-C2-SF-DV: Beginner course Snowflake Generator (Data Vault Modeling)

420 CHF / 420 EUR / 460 USD

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 received a biGENIUS Engineer badge if successful.

Prerequisite course: Module C1 - Introduction to biGENIUS

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
Data vault modeling wiki

Official Data Vault Certified Data Modeler and Certification course

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

Contents

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 available for this purpose and sending after the subscription and the validation 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.

biGENIUS-C2-RS-DV: Beginner course Redshift Generator (Data Vault Modeling)

420 CHF / 420 EUR / 460 USD

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 received a biGENIUS Engineer badge if successful.

Prerequisite course: Module C1 - Introduction to biGENIUS

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
Data vault modeling wiki
Official Data Vault Certified Data Modeler and Certification course

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

Contents

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 available for this purpose and sending after the subscription and the validation 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.

biGENIUS-C2-ORA-RM: Beginner course Oracle Generator (Relational Modeling)

420 CHF / 420 EUR / 460 USD


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.

Prerequisite course: Module C1 - Introduction to biGENIUS

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

Contents

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.