e-Learning

Level: C3

Now that you are a certified biGENIUS Engineer, take advantage of these biGENIUS Expert certified online courses and get a closer look into the target technologies and modeling methods of your choice with practical exercises. Upon completion with this level, you can then move on to level C4 and C5 and earn your final biGENIUS Master certification.

biGENIUS-C3-MS-DIM: Advanced Hands-On Microsoft Generator (Dimensional Modeling)

980 CHF /
980 EUR / 1080 USD

This module consists of advanced hands-on exercises 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 Expert badge if successful.

You must first complete the prerequisite course: Module C2-MS.

Duration

  • 5 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 Expert.
  • Obtain the biGENIUS Expert badge.

Target Group

  • Consultants
  • Data warehouse developers

Contents

Practical Microsoft project step by step:

1. Preparation
2. Configuration & ODS Implementation
3. DWH Implementation Part 1
4. DWH Implementation Part 2
5. Deployment & Loading Part 1
6. Deployment & Loading Part 2
7. Change requests & conceptual design
8. Data Mart Implementation & dimensional design

A metaDB with the result expected is provided after each step.

Exam for the certification: online quizz with 29 questions.

To enroll

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

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 provided in English.

biGENIUS-C3-MS-DV: Advanced Hands-On Microsoft Generator (Data Vault Modeling)

980 CHF /
980 EUR / 1080 USD

This module consists of advanced hands-on exercises 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 Expert badge if successful.

You must first complete prerequisite course: Module C2-MS-DV.

Duration

  • 5 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 Expert.
  • Obtain the biGENIUS Expert badge.

Target Group

  • Consultants
  • Data warehouse developers

Contents

Practical Microsoft project in hands-on mode:

1. Preparation
2. Configuration & ODS Implementation
3. DWH Implementation Part 1
4. DWH Implementation Part 2
5. Deployment & Loading Part 1
6. Deployment & Loading Part 2
7. Change requests & conceptual design
8. Data Mart Implementation & dimensional design

A metaDB with the result expected is provided after each step.

Exam for the certification: online quiz with 29 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.

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-C3-SF-DV: Advanced Hands-On Snowflake Generator (Data Vault Modeling)

980 CHF /
980 EUR / 1080 USD

This module consists of advanced hands-on exercises 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 Expert badge if successful.

You must first complete prerequisite course: Module C2-SF-DV.

Duration

  • 5 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 Expert.
  • Obtain the biGENIUS Expert badge.

Target Group

  • Consultants
  • Data warehouse developers

Contents

Practical Snowflake project in an hands-on mode:

1. Preparation
2. Configuration & ODS Implementation
3. DWH Implementation Part 1
4. DWH Implementation Part 2
5. Deployment & Loading Part 1
6. Deployment & Loading Part 2
7. Change requests & conceptual design
8. Data Mart Implementation & dimensional design

A metaDB with the result expected is provided after each step.

Exam for the certification: online quiz with 29 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. 5 dedicated days (40 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.

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

Documentation

Course materials are provided in English.

biGENIUS-C3-ORA-RM: Advanced Hands-On Oracle Generator (Relational Modeling)

980 CHF /
980 EUR / 1080 USD

This module consists of advanced hands-on exercises 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 Expert badge if successful.

You must first complete prerequisite course: Module C2-O.

Duration

  • 5 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 Expert.
  • Obtain the biGENIUS Expert badge.

Target Group

  • Consultants
  • Data warehouse developers

Contents

Practical Microsoft project in an hands-on mode:

1. Preparation
2. Configuration & ODS Implementation
3. DWH Implementation Part 1
4. DWH Implementation Part 2
5. Deployment & Loading Part 1
6. Deployment & Loading Part 2
7. Change requests & conceptual design
8. Data Mart Implementation & dimensional design

A metaDB with the result expected is provided after each step.

Exam for the certification: online quiz with 29 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.

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.