KNIME Analytics Platform for BI Training Course

This instructor-led, live training in Macao (online or onsite) is aimed at intermediate-level participants who wish to master advanced data integration and visualization techniques in Looker Studio, and learn how to connect diverse data sources, design compelling dashboards, and automate reporting workflows to drive better business decisions.

By the end of this training, participants will be able to:

• Connect and integrate multiple data sources into Looker Studio.
• Create custom metrics and calculated fields for tailored analysis.
• Design advanced visualizations, including interactive filters and charts.
• Automate reporting workflows for real-time data updates.
• Apply best practices for visual storytelling and report customization.

This instructor-led, live training in Macao (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 Macao (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Macao (online or onsite) is aimed at data analysts who wish to use Google Sheets for data analysis.

By the end of this training, participants will be able to:

• Build spreadsheets with Google Sheets.
• Use formulas that work both in Google Sheets and Excel.
• Format and analyze any data.
• Create data visualizations with charts and graphs.

Google Sheets is a powerful cloud-based spreadsheet tool that supports real-time collaboration, data organization, and analysis.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to maximize their efficiency and collaboration using Google Sheets’ advanced features.

By the end of this training, participants will be able to:

• Navigate and utilize the key features of Google Sheets.
• Manage and organize data efficiently using filters, sorting, and formatting tools.
• Apply essential and advanced formulas for business scenarios.
• Create charts, dashboards, and reusable templates for reporting and collaboration.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and practice in Google Sheets.
• Real-world examples and collaborative activities.

Course Customization Options

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

This instructor-led, live training in Macao (online or onsite) is aimed at beginner-level to intermediate-level participants who wish to build foundational skills for data visualization and reporting using Looker Studio, and learn how to connect data sources, visualize information effectively, and gain actionable insights.

By the end of this training, participants will be able to:

• Understand the core features of Looker Studio and its use cases.
• Set up Looker Studio and connect to various data sources.
• Create engaging dashboards with charts, graphs, and filters.
• Customize reports for specific audiences and business needs.
• Collaborate on and share dashboards effectively.

This instructor-led, live training in Macao (online or onsite) is aimed at data analysts and data scientists who wish to use Metabase to collect, query, and visualize data for business intelligence analysis and reporting.

By the end of this training, participants will be able to:

• Set up and install Metabase to start building data visualizations and dashboards.
• Learn how to query, aggregate, and visualize data in Metabase.
• Use the features and tools in Metabase to write SQL queries.
• Build analytics charts and dashboards to get business insights.
• Know the best practices and tips on using Metabase and resolving common issues.

Microsoft Fabric is a unified analytics platform that brings together data engineering, data integration, data warehousing, data science, real-time analytics, and business intelligence under one umbrella.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals who wish to leverage Microsoft Fabric to build modern data solutions with integrated analytics, governance, and visualization tools.

By the end of this training, participants will be able to:

• Understand the components of Microsoft Fabric and how they integrate with the Microsoft ecosystem.
• Create and manage Fabric Workspaces with proper access control.
• Build and manage Lakehouses to centralize and analyze data.
• Use notebooks for exploratory analysis and transformation using Python and SQL.
• Create and automate data flows using visual pipelines.
• Model and manage data using the Data Warehouse and Semantic Model layers.
• Design and publish interactive dashboards with Power BI in Fabric.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

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

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 Macao (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 Macao (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 Macao (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.

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

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