Data Management Training in Waterloo

This instructor-led, live training in Waterloo (online or onsite) is aimed at intermediate-level data professionals who wish to implement a lakehouse solution using Microsoft Fabric.By the end of this training, participants will be able to:

• Understand the architecture and components of Microsoft Fabric.
• Configure and manage a Lakehouse using Microsoft Fabric.
• Ingest and transform data using Apache Spark.
• Utilize Delta Lake tables for versioning and managing data.
• Implement data ingestion pipelines with Dataflows Gen2.
• Orchestrate data pipelines using Data Factory.

This instructor-led, live training in Waterloo (online or onsite) is aimed at beginner to intermediate-level IT professionals who wish to gain the knowledge and practical skills required to effectively prepare data for analysis, ensuring accuracy, consistency, and reliability in diverse datasets. By the end of this training, participants will be able to:

• Gain a thorough understanding of data preparation's significance in ensuring high-quality, reliable data for analysis and modeling purposes.
• Acquire hands-on proficiency in data collection, cleaning, transformation, and integration techniques using real-world datasets.
• Develop the ability to identify and address data-related challenges, discrepancies, and inconsistencies effectively.

This instructor-led, live training in Waterloo (online or onsite) is aimed at beginner to intermediate-level IT professionals who wish to gain in-depth knowledge and practical skills necessary for understanding, implementing, and leveraging the power of data catalogs within organizational settings. By the end of this training, participants will be able to:

• Learn to implement and manage data catalogs effectively within an organization.
• Utilize data catalogs for effective data governance and compliance.
• Develop skills for effective data discovery and search capabilities using data catalogs.
• Integrate data catalogs with existing data systems for seamless functionality.

Purpose 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

This instructor-led, live training in Waterloo (online or onsite) is aimed at developers who wish to learn how to implement queues on the data structure. By the end of this training, participants will be able to:

• Learn about the algorithms that are commonly used in the data structure.
• Understand the applications of queue data structure.

This instructor-led, live training in Waterloo (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.

This instructor-led, live training in Waterloo (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.

Purpose 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

Audience

• Programmers
• Beginner IT professionals

Format of the course

•     Part lecture, part discussion, heavy hands-on practice

This instructor-led, live training in Waterloo (online or onsite) is aimed at repository managers, SysAdmins, and developers who wish to install, configure, and monitor the DSpace platform to manage their content assets. By the end of this training, participants will be able to:

• Set up DSpace to manage and preserve various types of digital content.
• Manage the DSpace platform to store, preserve, and share document libraries online.
• Configure DSpace user interface, metadata, and database to suit organizational needs.
• Use analytics services to monitor user traffic and metrics and generate useful statistics for the organization.

This instructor-led, live training in Waterloo (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Data Hub to organize and manage their data from various silos. By the end of this training, participants will be able to customize, secure, track, and manage their enterprise data using MarkLogic Data Hub capabilities and tools.

This instructor-led, live training in Waterloo (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize their database systems. By the end of this training, participants will be able to implement, develop, manage, and secure their enterprise data and database systems using MarkLogic Server.

KNIME Analytics Platform is a leading open source option for data-driven innovation, helping you discover the potential hidden in your data, mine for fresh insights, or predict new futures. With more than 1000 modules, hundreds of ready-to-run examples, a comprehensive range of integrated tools, and the widest choice of advanced algorithms available, KNIME Analytics Platform is the perfect toolbox for any data scientist and business analyst. This course for KNIME Analytics Platform is an ideal opportunity for beginners, advanced users and KNIME experts to be introduced to KNIME, to learn how to use it more effectively, and how to create clear, comprehensive reports based on KNIME workflows

The "KNIME Analytics Platform" training offers a comprehensive overview of this free data analytics platform. The program includes an introduction to data processing and analysis, KNIME installation and configuration, workflow building, methodology for creating business models and data modeling. The course also covers advanced data analysis tools, workflow import and export, tool integration, ETL processes, data mining, visualization, extensions and integrations with tools such as R, Java, Python, Gephi, Neo4j. The conclusion includes an overview of reporting, integration with BIRT and KNIME WebPortal.

Pentaho Open Source BI Suite Community Edition (CE) is a business intelligence package that provides data integration, reporting, dashboards, and load capabilities. In this instructor-led, live training, participants will learn how to maximize the features of Pentaho Open Source BI Suite Community Edition (CE). By the end of this training, participants will be able to:

• Install and configure Pentaho Open Source BI Suite Community Edition (CE)
• Understand the fundamentals of Pentaho CE tools and their features
• Build reports using Pentaho CE
• Integrate third party data into Pentaho CE
• Work with big data and analytics in Pentaho CE

Audience

• Programmers
• BI Developers

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

• To request a customized training for this course, please contact us to arrange.

Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations. In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle and maximize the value of data within their organization. By the end of this training, participants will be able to:

• Create, preview, and run basic data transformations containing steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format.
• Provide results to third-part applications for further processing

Audience

• Data Analyst
• ETL developers

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

There is a need to provide adequate training on the Data Protection Act 1998 "the Act" and its implications for both organisations and individuals. There are important differences between the Act and its predecessor, the Data Protection Act 1984. In particular, the Act contains important new obligations in relation to manual records and transborder data flows, a new notification system and amended principles. It is important to understand the Act in the European context. Those experienced in data protection issues, as well as those new to the subject, need to be trained so that their organisations are confident that legal compliance is continually addressed. It is necessary to identify issues requiring expert data protection advice in good time in order that organisational reputation and credibility are enhanced through relevant data protection policies and procedures. Objectives The aim of the syllabus is to promote an understanding of how the data protection principles work rather than simply focusing on the mechanics of regulation. The syllabus places the Act in the context of human rights and promotes good practice within organisations. On attaining the certificate, award holders will possess:

• appreciation of the broader context of the Act
• understanding of the way in which the Act and the Privacy and Electronic Communications (EC Directive) Regulations 2003 work a broad understanding of the way associated legislation relates to the Act an understanding of what has to be done to achieve compliance a recognised qualification in data protection

Course Synopsis The syllabus comprises three main parts, each with many sub-sections! Context - this will address the origins of and reasons for the Act together with consideration of privacy in general. Law – Data Protection Act - this will address the main concepts and elements of the Act and subordinate legislation. Application - this will consider how compliance is achieved and how the Act works in practice.

This instructor-led, live training in Waterloo (online or onsite) is aimed at engineers who wish to use Pimcore to manage product, customer, vendor, etc. data across multiple domains. By the end of this training, participants will be able to:

• Consolidate complex master data across heterogeneous systems.
• Configure complex multi-domain data models from multiple sources and formats.
• Model, store and manage the hierarchy and structure of data within an organization.
• Cleanse, match, verify, and standardize master data.
• Integrate PIM data with digital asset management (DAM), content management (CMS), and user experience / customer experience design (UX / CX).

This instructor-led, live training in Waterloo (online or onsite) is aimed at computer engineers, data analysts, and project managers who wish to design, manage and evaluate organizational data systems. By the end of this training, participants will be able to:

• Design data systems that fit an organization's needs.
• Evaluate data assets to craft an effective data processing system.
• Implement risk mitigation methods to build a solid enterprise data architecture.

Sensor Fusion is the combination and integration of data from multiple sensors to provide a more accurate, reliable and contextual view of data. Sensor Fusion implementations require algorithms to filter and integrate different data sources.    Audience This course is targeted at engineers, programmers and architects who deal with multi-sensor implementations.    

This instructor-led, live training in Waterloo (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.

This instructor-led, live training in Waterloo (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.

This instructor-led, live training in Waterloo (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.

In this instructor-led, live training in Waterloo, 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.

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

This 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 subjects rights,
data controllers and processors obligations, 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.

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

This instructor-led, live training in Waterloo (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.