Data Vault - introduction Training Course
By the end of this training, participants will be able to:
- Understand the architecture and design concepts behind Data Vault 2.0,
- Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse
- Develop a consistent and repeatable ETL (Extract, Transform, Load) process
Audience
- Data modelers
- Data warehousing specialists
- Business Intelligence specialists
- Data engineers
- Database administrators
Course Outline
Fundamentals
- What is a data warehouse? A single source of truth or a single source of lies?
- Popular solutions: popular schools of implementing data warehouses and their drawbacks. What problems need to be solved and can Data Vault help with this?
- Enterprise Data Warehouse: what it is and how does Data Vault fit into this concept
- Team: Data warehouse in the organization, roles, and teams
Data Vault
- Multidimensional model: Discussion of the star schema in relation to the DV layer.
- Reporting: Ready data, or Report Marts and Flat Data.
- Business support: Self-service for consumers.
Workshops
- Test database: Configuring the environment for technical exercises
- Analysis: Initial EDW project based on the test database
- ETL: Creating loading procedures for the created structures
Automation
- Automated DV: Automating Data Vault loading
Requirements
There are no specific requirements needed to attend this course.
Open Training Courses require 5+ participants.
Data Vault - introduction Training Course - Booking
Data Vault - introduction Training Course - Enquiry
Data Vault - introduction - Consultancy Enquiry
Consultancy Enquiry
Testimonials (1)
Directness. A good introductory lecture for business people.
Zdzislaw Dec
Course - Data Vault - introduction
Machine Translated
Provisional Courses
Related Courses
Digital and Architectural Accessibility Auditor
14 HoursObjectives:
• Acquire knowledge on how to conduct a digital and architectural accessibility audit;
• Familiarize yourself with the WCAG standard in version 2.1.
EBX5 for Developers
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to use EBX5 (TIBCO EBX) to enable a Master Data Management solution within their organization.
By the end of this training, participants will be able to:
- Interpret requirements and architect an MDM solution.
- Enable the management and integration of master data.
- Integrate and transfer data across multiple systems.
- Import data into EBX5 using match and merge logic.
- Design, create and document a data model that addresses their organization's business requirements.
- Integrate EBX5 with 3rd party services.
RODO / GDPR - legal changes, theoretical introduction, practical aspects
14 HoursGDPR, i.e. the General Data Protection Regulation, is a legal regulation of the European Union introduced in May 2018, aimed at protecting the privacy and personal data of EU citizens. Here are some key points about the GDPR: The GDPR regulates how EU citizens' personal data is collected, stored, processed and transferred, giving them control over their data. Applies to all organizations that process personal data of EU persons, regardless of the location of these organizations. It provides a wide range of individual rights, such as the right to information, access to data, correction of data, deletion of data ("right to be forgotten"), data portability and objection to data processing. It imposes on organizations the obligation to ensure data security, consent to data processing, maintain data processing registers, and apply appropriate technical and organizational measures to protect data. It regulates the transfer of personal data outside the EU to third countries, requiring appropriate data protection measures. In some cases, organizations are required to appoint a Data Protection Officer to oversee compliance with GDPR regulations. GDPR aims to provide greater protection for privacy and personal data, and organizations are obliged to comply with these regulations to ensure an adequate level of protection for the personal data of their users and customers.
GDPR Workshop
7 HoursThis one-day course is for people looking for a brief outline of the GDPR – General Data Protection Regulations coming out May 25, 2018. This is ideal for managers, department heads, and employees who need to understand the basics of the GDPR.
How to Audit GDPR Compliance
14 HoursThis course is developed primarily with focus on auditors and other administrative roles who are tasked to ensure compliance of their control systems and IT environment with prevailing laws and regulations. The course will begin by giving understanding of key GDPR concepts as well as how it is going to affect the work performed by auditors. Participants will also explore data subjectsrights, data controllersand processorsobligations, and enforcement and compliance notions in the context of the Regulation. The training will also cover the audit program provided by ISACA that will enable auditors to review GDPR governance and response mechanisms as well as supporting processes which can help manage the risk associated with noncompliance.
GDPR Advanced
21 HoursThis is more in-depth and would be for those working a great deal with the GDPR and who may be appointed to the GDPR team. This would be ideal for IT, human resources and marketing employees, and they will deal extensively with the GDPR.
Oracle GoldenGate
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at sysadmins and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation.
By the end of this training, participants will be able to:
- Install and configure Oracle GoldenGate.
- Understand Oracle databases replication using the Oracle GoldenGate tool.
- Understand the Oracle GoldenGate architecture.
- Configure and perform a database replication and migration.
- Optimize Oracle GoldenGate performance and troubleshoot issues.
Personal Data Protection Officer - Basic Level
21 HoursPurpose of the Training
- Acquainting the audience with systematized, comprehensive issues of the functioning of personal data protection on the basis of Polish and European law
- Providing practical knowledge about the new rules for the processing of personal data
- Presentation of the areas of the greatest legal risks in connection with the entry into force of the GDPR
- Practical preparation for independent performance of the duties of a Personal Data Protection Officer
Personal Data Protection Officer - Advanced Level
14 HoursPurpose of the Training
- Gaining practical knowledge on how to perform the tasks of the Inspector
- Gaining practical knowledge of how to audit and how to assess risk
- Providing practical knowledge about the new rules for the processing of personal data
Talend Administration Center (TAC)
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at system administrators, data scientists, and business analysts who wish to set up Talend Administration Center to deploy and manage the organization's roles and tasks.
By the end of this training, participants will be able to:
- Install and configure Talend Administration Center.
- Understand and implement Talend management fundamentals.
- Build, deploy, and run business projects or tasks in Talend.
- Monitor the security of datasets and develop business routines based on the TAC framework.
- Obtain a broader comprehension of big data applications.
Talend Big Data Integration
28 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at technical persons who wish to deploy Talend Open Studio for Big Data to simplifying the process of reading and crunching through Big Data.
By the end of this training, participants will be able to:
- Install and configure Talend Open Studio for Big Data.
- Connect with Big Data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
- Understand and set up Open Studio's big data components and connectors.
- Configure parameters to automatically generate MapReduce code.
- Use Open Studio's drag-and-drop interface to run Hadoop jobs.
- Prototype big data pipelines.
- Automate big data integration projects.
Talend Cloud
7 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at data administrators and developers who wish to manage, monitor, and operate data integration processes using Talend Cloud services.
By the end of this training, participants will be able to:
- Navigate the Talend Management Console to manage users and roles in the platform.
- Evaluate data to find and understand relevant datasets.
- Create a pipeline to process and monitor data at rest or in action.
- Prepare data for analysis to generate insights relevant to the business.
Talend Data Stewardship
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner to intermediate-level data analysts who wish to deepen their understanding and skills in managing and improving data quality using Talend Data Stewardship.
By the end of this training, participants will be able to:
- Gain a comprehensive understanding of the role of data stewardship in maintaining data quality.
- Use Talend Data Stewardship for managing data quality tasks.
- Create, assign, and manage tasks within Talend Data Stewardship, including workflow customization.
- Use the tool's reporting and monitoring capabilities to track data quality and stewardship efforts.
Talend Open Studio for ESB
21 HoursIn this instructor-led, live training in Poland, participants will learn how to use Talend Open Studio for ESB to create, connect, mediate and manage services and their interactions.
By the end of this training, participants will be able to
- Integrate, enhance and deliver ESB technologies as single packages in a variety of deployment environments.
- Understand and utilize Talend Open Studio's most used components.
- Integrate any application, database, API, or Web services.
- Seamlessly integrate heterogeneous systems and applications.
- Embed existing Java code libraries to extend projects.
- Leverage community components and code to extend projects.
- Rapidly integrate systems, applications and data sources within a drag-and-drop Eclipse environment.
- Reduce development time and maintenance costs by generating optimized, reusable code.
WCAG 2.1. and Digital Accessibility
7 HoursObjectives:
• Familiarize with the requirements of the WCAG 2.1 standard;
• Gain knowledge about digital accessibility;
• Learn how to properly design accessible websites