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
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 receive a biGENIUS Expert badge if successful.
You must first complete the prerequisite course: Module C2-MS-DIM.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
Content
Practical Microsoft project in hands-on mode:
1. Preparation
2. Configuration & ODS Implementation
3. Data warehouse Implementation Part 1
4. Data warehouse 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 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.
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
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 receive 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
Content
Practical Microsoft project in hands-on mode:
1. Preparation
2. Configuration & ODS Implementation
3. Data warehouse Implementation Part 1
4. Data warehouse 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 provided after subscription and confirmation 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
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 receive 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
Content
Practical Snowflake project in an hands-on mode:
1. Preparation
2. Configuration & ODS Implementation
3. Data warehouse Implementation Part 1
4. Data warehouse 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 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. 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.
Documentation
Course materials are provided in English.
biGENIUS-C3-ORA-RM
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 receive a biGENIUS Expert badge if successful.
You must first complete prerequisite course: Module C2-ORA-RM.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
Content
Practical Oracle project in an hands-on mode:
1. Preparation
2. Configuration & ODS Implementation
3. Data warehouse Implementation Part 1
4. Data warehouse 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 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.