e-Learning + Online Exam
Place
On Demand
Date
English
Language
400 CHF / 380 EUR
Price
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 Redshift 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.
BIGENIUS-C2-RD-DV
DURATION
- 2 days
- Exam: 1 hour
GOAL
- 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
TARGET GROUP
- Consultants
- DWH developers
- DWH project managers
CONTENTS
Practical Redshift labs for Data Vault modeling step by step:
- Understand environment
- 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
METHOD
Access to our eLearning platform for the next 2 weeks after subscription. Access to the provided training environment (in the Cloud) for 2 dedicated days - 16 hours (to choose in advance). If you need more time, additional costs will be charged. 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.
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 in English
PREREQUISITES FOR BIGENIUS® BEGINNER COURSE REDSHIFT GENERATOR (DATA VAULT MODELING)
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
REGISTRATION
Please click through the steps and enter your personal information: