Pentaho Open Source BI Suite Community Edition (CE) Training Course

This instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level participants who wish to master advanced data integration and visualisation 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 visualisations, including interactive filters and charts.
• Automate reporting workflows for real-time data updates.
• Apply best practices for visual storytelling and report customisation.

This instructor-led, live training in New Zealand (online or on-site) 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.
• Utilise 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 New Zealand (online or onsite) is designed for beginner to intermediate-level professionals seeking to boost their productivity and efficiency by harnessing the advanced features of Excel and Google Sheets for data organisation, analysis, and teamwork.

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

• Navigate and make the most of the core features of Excel and Google Sheets.
• Conduct data analysis and derive 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 New Zealand (online or on-site) is designed for data analysts who wish to use Google Sheets for data analysis.

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

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

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

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

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

• Navigate and utilise the key features of Google Sheets.
• Manage and organise 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 Customisation Options

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

This instructor-led, live training in New Zealand (online or on-site) is designed for beginner to intermediate-level participants who wish to build foundational skills in data visualisation and reporting using Looker Studio, learn how to connect data sources, visualise 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.
• Customise reports for specific audiences and business needs.
• Collaborate on and share dashboards effectively.

This instructor-led, live training in New Zealand (online or on-site) is designed for data analysts and data scientists who want to use Metabase to collect, query, and visualise data for business intelligence analysis and reporting.

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

• Set up and install Metabase to begin building data visualisations and dashboards.
• Learn how to query, aggregate, and visualise data using Metabase.
• Use Metabase features and tools to write SQL queries.
• Build analytics charts and dashboards to gain business insights.
• Understand best practices and tips for 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 visualisation 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 centralise and analyse 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 Customisation Options

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

This instructor-led, live training in New Zealand (online or on-site) is tailored for system administrators and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation purposes.

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

• Install and configure Oracle GoldenGate.
• Gain an understanding of Oracle database replication using the Oracle GoldenGate tool.
• Comprehend the Oracle GoldenGate architecture.
• Configure and execute database replication and migration tasks.
• Optimise Oracle GoldenGate performance and troubleshoot any issues that arise.

Sensor Fusion is the combination and integration of data from multiple sensors to deliver a more accurate, reliable, and contextually rich view of information.

Implementing Sensor Fusion requires algorithms to filter and integrate diverse data sources.

Audience

This course is designed for engineers, programmers, and architects working with multi-sensor systems.

This instructor-led, live training in New Zealand (online or on-site) is designed for system administrators, data scientists, and business analysts seeking to establish and manage Talend Administration Center for deploying and overseeing organisational roles and tasks.

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

• Install and configure Talend Administration Center.
• Understand and implement the fundamentals of Talend management.
• Build, deploy, and execute business projects or tasks within Talend.
• Monitor dataset security and develop business routines leveraging the TAC framework.
• Gain a broader understanding of big data applications.

This instructor-led, live training in New Zealand (online or on-site) is intended for technical professionals who wish to deploy Talend Open Studio for Big Data to streamline the process of reading and analysing big data.

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

• Install and configure Talend Open Studio for Big Data.
• Connect to big data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
• Understand and configure Open Studio's big data components and connectors.
• Set 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 New Zealand (delivered online or on-site) is designed for 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 within the platform.
• Evaluate data to identify and understand relevant datasets.
• Create pipelines to process and monitor data whether at rest or in motion.
• Prepare data for analysis to generate insights that are relevant to the business.

This instructor-led, live training in New Zealand (delivered either online or on-site) is designed for beginner to intermediate-level data analysts who wish to deepen their understanding and enhance their 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 high-quality data.
• Use Talend Data Stewardship to effectively manage data quality tasks.
• Create, assign, and manage tasks within Talend Data Stewardship, including customising workflows.
• Leverage the tool's reporting and monitoring capabilities to track data quality and stewardship initiatives.

In this instructor-led, live training in New Zealand, participants will learn how to use Talend Open Studio for ESB to create, connect, mediate, and manage services along with their interactions.

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

• Integrate, enhance, and deliver ESB technologies as unified packages across various deployment environments.
• Understand and effectively utilise Talend Open Studio's most commonly used components.
• Integrate any application, database, API, or web service.
• Seamlessly connect heterogeneous systems and applications.
• Embed existing Java code libraries to extend project capabilities.
• Leverage community-driven components and code to expand project functionality.
• Rapidly integrate systems, applications, and data sources within a drag-and-drop Eclipse environment.
• Reduce development time and maintenance costs by generating optimised, reusable code.