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.
[category_overview] =>
[outline] =>
Introduction to Pentaho Open Source BI Suite Community Edition (CE)
Overview of CE Features and Architecture
Pentaho Community Edition vs. Enterprise Edition
Pentaho CE Tools
Installing and Configuring Pentaho CE
Using the Pentaho CE Business Analytics User Console
Creating Reports with the Pentaho CE Business Analytics Report Designer
Performing Data Integration in Pentaho CE
Working with Databases in Pentaho CE
Relational Databases
NoSQL Sources
Analytic Databases
Working with the Analysis View in Pentaho CE
Predictive Analytics
Working with Big Data in Pentaho CE
Graphical Designer for Big Data
Maximizing the Community Online Forums of Pentaho CE
Understanding of database architecture and virtual machines
Basic knowledge of Oracle databases
Audience
Database Administrators
Data Architects
Developers
[overview] =>
Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Oracle GoldenGate features and architecture
Understanding Oracle GoldenGate processing methods and databases
Basic knowledge of systems architecture and networking
Understanding of ETL (Extract, Transform, Load) fundamentals
Experience with query and scripting languages (SQL, JavaScript, etc.)
Comprehension of the IAM (Identity Access Management) framework
Basic knowledge of cloud services
Audience
System Administrators
Data Scientists
Data Analysts
[overview] =>
Talend Administration Center (TAC) is the centralized commanding application of the Talend software suite. It is implemented by Talend solutions as a web application and integrates other Talend tools to efficiently administer information processes. Talend Administration Center allows its users to manage their business systems and convert data sets into insights that are useful to the enterprise.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Administration Center Features and Architecture
Setting Up and Configuring Talend Administration Center
Other TAC Modules and GIT Repository Configuration
Making Use of the TAC Management Console for User Creation
Overview of Talend Administration Center Groups for Different User Roles
Integrating Talent Studio with Talend Administration Center
Utilizing the Talend Administration Center Panes
The Main Browser Pane and Principal Browser Views
Navigating and Accessing User Tasks Based on User Roles
Managing User Roles, Authorizations, Projects, and References
Monitoring Servers and Activities During Runtime
Creating, Deploying, and Running Plans, Projects, and Jobs
Recovering and Restarting User Activities
Executing Administrative Tasks from Remote Engines
Connecting to the Talend Cloud
Building and Executing Business Routines
Encrypting Logging Events in Talend Administration Center
Administering Metadata and Product Documentation
SQL Templates in the TAC Database
Securing the Talend System with Hashing Technology
Managing the Lifecycle and Status of the Talend Environment
An understanding of ETL (Extract, Transform, Load) concepts
Audience
Business intelligence professionals
Database professionals
SQL Developers
ETL Developers
Solution architects
Data architects
Data warehousing professionals
System administrators and integrators
[overview] =>
Talend Open Studio for Big Data is an open source ETL tool for processing big data. It includes a development environment to interact with Big Data sources and targets, and run jobs without having to write code.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of "Open Studio for Big Data" Features and Architecture
Talend Cloud is an open-source platform that provides end-to-end data integration and management solutions. Talend Cloud specializes in big data, data quality, master data management, and application integration for businesses.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Cloud Features and Architecture
Basic knowledge of database systems and data processing
Audience
Data analysts
Data managers
IT professionals
[overview] =>
Talend Data Stewardship is a tool that provides a framework for managing, monitoring, and resolving data quality issues in an organization.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Understanding data stewardship
The role of data stewards
Overview of Talend Data Stewardship
Getting Started
Navigating the interface
Setting up your environment
Integration with other Talend products
Data Quality Management
Principles of data quality
Identifying data quality issues
Cleansing data in Talend Data Stewardship
Task Management
Creating and managing tasks
Assigning tasks to data stewards
Workflow management
Collaboration and Workflow Customization
Collaborative features in Talend Data Stewardship
Customizing workflows
Best practices for effective collaboration
Advanced Features and Techniques
Advanced data cleansing techniques
Handling complex data quality scenarios
Automating data stewardship processes
Monitoring and Reporting
Monitoring data quality
Reporting in Talend Data Stewardship
Analyzing data stewardship metrics
Case Studies and Real-world Applications
Case study analysis
Applying Talend Data Stewardship in different industries
Problem-solving in data stewardship scenarios
Best Practices and Governance
Establishing data governance policies
Best practices for data stewards
Ensuring compliance and data security
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700038008
[source_title] => Talend Data Stewardship
[source_language] => en
[cert_code] =>
[weight] => -1001
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => talenddatastewardship
)
[talendesb] => stdClass Object
(
[course_code] => talendesb
[hr_nid] => 209048
[title] => Talend Open Studio for ESB
[requirements] =>
An understanding of Service-Oriented Architectures (SOA)
An understanding of Enterprise Service Bus (ESB)
A good understanding of Java
Audience
ESB developers
Java application developers
Software architects
[overview] =>
Talend Open Studio for ESB is an open-source, real-time application integration tool for service mediation and routing. It simplifies the integration of enterprise-class systems, services and applications. By service-enabling applications and legacy systems, it enables the creation of Service-Oriented Architectures (SOA).
In this instructor-led, live training, 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.
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
[category_overview] =>
In this instructor-led, live training in <loc>, 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.
[outline] =>
Introduction
Integrating applications and data management in complex, heterogeneous environments
An understanding of data analytics and database concepts
Experience in SQL
Audience
Data scientists
Developers
[overview] =>
Redash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc.
This instructor-led, live training (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
[outline] =>
Introduction
Redash vs Metabase vs Superset
Overview of Redash features and advantages
Getting Started
Installing Redash
Supported data sources
Connecting to different data sources
Configuring users and groups
Querying Data
Creating, editing, and publishing queries
Running queries from QRDS
Adding query parameters
Scheduling queries
Using favorites and tagging
Downloading query results
Using query filters and snippets
Creating Visualizations and Dashboards
Adding, editing, and embedding visualizations
Setting up chart visualizations
Other visualization types
Combining visualizations in a dashboard
Managing dashboard permissions
Sharing and embedding dashboards
Setting Up Alerts
Creating an alert
Adding an alert destination
Customizing notification messages
Configuring multiple column alerts
Working with Integrations and APIs
Accessing APIs with Python
Connecting Redash to Zapier
Importing query results into Google Spreadsheets
Configuring an SSH tunnel using API
Best Practices and Troubleshooting
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037800
[source_title] => Data Analysis with Redash
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => redash
)
[metabase] => stdClass Object
(
[course_code] => metabase
[hr_nid] => 379119
[title] => Business Intelligence and Data Analysis with Metabase
[requirements] =>
An understanding of data analytics and database concepts
Audience
Data analysts
Data scientists
[overview] =>
Metabase is an open source business intelligence (BI) tool. It provides a simple and user-friendly interface for creating and configuring data visualizations and dashboards.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037799
[source_title] => Business Intelligence and Data Analysis with Metabase
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => metabase
)
[qlikviewforbusiness] => stdClass Object
(
[course_code] => qlikviewforbusiness
[hr_nid] => 282606
[title] => QlikView for Business Users
[requirements] =>
No programming experience required
Audience
Managers
Business users
[overview] =>
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
[outline] =>
Introduction to QlikView
Overview of QlikView Features
Installing and Configuring QlikView
Setting User Preferences
Configuring Document Properties
Creating Visualizations in QlikView
Managing Data Sources
Creating and Modifying Objects
Managing QlikView Sheets and Files
Working with Sheets in QlikView
Exporting QlikView Data to Excel
Creating Summaries and Charts in QlikView
Sorting and Filtering QlikView Data
Creating and Modifying Charts
Building and Manipulating Pivot Tables in QlikView
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Build data models with QlikView.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Google Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
Understanding of business intelligence (BI) principles and practices
Basic experience in data analysis, report generation, and dashboard creation
Audience
Data analysts
IT professionals
[overview] =>
IBM Cognos Analytics 11 is a comprehensive, web-based business intelligence suite that offers an integrated platform for reporting, analytics, scorecarding, and monitoring of events and metrics.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
[outline] =>
Introduction
Overview of Cognos 11
Key differences between Cognos 10 and Cognos 11
Benefits of upgrading
Navigating the Cognos 11 Environment
User Interface changes
Overview dashboard and report interface
Customization and personalization features
Data Modules and Management
Introduction to data Modules
Differences in data Management between Cognos 10 and 11
IBM Cognos Analytics is a business intelligence suite by IBM. IBM Cognos Analytics provides a flexible analytical and reporting environment for medium and large enterprises.
This instructor-led, live training (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
Alteryx is a self-service data analytics platform. It provides tools for users to quickly prepare, conform, and analyze data from any source.
This instructor-led, live training (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Pentaho Open Source BI Suite Community Edition (CE)
Overview of CE Features and Architecture
Pentaho Community Edition vs. Enterprise Edition
Pentaho CE Tools
Installing and Configuring Pentaho CE
Using the Pentaho CE Business Analytics User Console
Creating Reports with the Pentaho CE Business Analytics Report Designer
Performing Data Integration in Pentaho CE
Working with Databases in Pentaho CE
Relational Databases
NoSQL Sources
Analytic Databases
Working with the Analysis View in Pentaho CE
Predictive Analytics
Working with Big Data in Pentaho CE
Graphical Designer for Big Data
Maximizing the Community Online Forums of Pentaho CE
Deploying or Embedding Your Pentaho CE Project
Licensing
Troubleshooting
Summary and Conclusion
Requirements
Programming experience
28 Hours
Pentaho Open Source BI Suite Community Edition (CE) Training Course - Booking
Pentaho Open Source BI Suite Community Edition (CE) Training Course - Enquiry
Pentaho Open Source BI Suite Community Edition (CE) - Consultancy Enquiry
This instructor-led, live training in Venezuela (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.
This instructor-led, live training in Venezuela (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 Venezuela (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.
This instructor-led, live training in Venezuela (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 Venezuela (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 Venezuela, 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 instructor-led, live training in Venezuela (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
This instructor-led, live training in Venezuela (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.
In this instructor-led, live training in Venezuela (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
This instructor-led, live training in Venezuela (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
This instructor-led, live training in Venezuela (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
This instructor-led, live training in Venezuela (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
[outline] =>
Introduction to Pentaho Open Source BI Suite Community Edition (CE)
Overview of CE Features and Architecture
Pentaho Community Edition vs. Enterprise Edition
Pentaho CE Tools
Installing and Configuring Pentaho CE
Using the Pentaho CE Business Analytics User Console
Creating Reports with the Pentaho CE Business Analytics Report Designer
Performing Data Integration in Pentaho CE
Working with Databases in Pentaho CE
Relational Databases
NoSQL Sources
Analytic Databases
Working with the Analysis View in Pentaho CE
Predictive Analytics
Working with Big Data in Pentaho CE
Graphical Designer for Big Data
Maximizing the Community Online Forums of Pentaho CE
Understanding of database architecture and virtual machines
Basic knowledge of Oracle databases
Audience
Database Administrators
Data Architects
Developers
[overview] =>
Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Oracle GoldenGate features and architecture
Understanding Oracle GoldenGate processing methods and databases
Basic knowledge of systems architecture and networking
Understanding of ETL (Extract, Transform, Load) fundamentals
Experience with query and scripting languages (SQL, JavaScript, etc.)
Comprehension of the IAM (Identity Access Management) framework
Basic knowledge of cloud services
Audience
System Administrators
Data Scientists
Data Analysts
[overview] =>
Talend Administration Center (TAC) is the centralized commanding application of the Talend software suite. It is implemented by Talend solutions as a web application and integrates other Talend tools to efficiently administer information processes. Talend Administration Center allows its users to manage their business systems and convert data sets into insights that are useful to the enterprise.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Administration Center Features and Architecture
Setting Up and Configuring Talend Administration Center
Other TAC Modules and GIT Repository Configuration
Making Use of the TAC Management Console for User Creation
Overview of Talend Administration Center Groups for Different User Roles
Integrating Talent Studio with Talend Administration Center
Utilizing the Talend Administration Center Panes
The Main Browser Pane and Principal Browser Views
Navigating and Accessing User Tasks Based on User Roles
Managing User Roles, Authorizations, Projects, and References
Monitoring Servers and Activities During Runtime
Creating, Deploying, and Running Plans, Projects, and Jobs
Recovering and Restarting User Activities
Executing Administrative Tasks from Remote Engines
Connecting to the Talend Cloud
Building and Executing Business Routines
Encrypting Logging Events in Talend Administration Center
Administering Metadata and Product Documentation
SQL Templates in the TAC Database
Securing the Talend System with Hashing Technology
Managing the Lifecycle and Status of the Talend Environment
An understanding of ETL (Extract, Transform, Load) concepts
Audience
Business intelligence professionals
Database professionals
SQL Developers
ETL Developers
Solution architects
Data architects
Data warehousing professionals
System administrators and integrators
[overview] =>
Talend Open Studio for Big Data is an open source ETL tool for processing big data. It includes a development environment to interact with Big Data sources and targets, and run jobs without having to write code.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of "Open Studio for Big Data" Features and Architecture
Talend Cloud is an open-source platform that provides end-to-end data integration and management solutions. Talend Cloud specializes in big data, data quality, master data management, and application integration for businesses.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Cloud Features and Architecture
Basic knowledge of database systems and data processing
Audience
Data analysts
Data managers
IT professionals
[overview] =>
Talend Data Stewardship is a tool that provides a framework for managing, monitoring, and resolving data quality issues in an organization.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Understanding data stewardship
The role of data stewards
Overview of Talend Data Stewardship
Getting Started
Navigating the interface
Setting up your environment
Integration with other Talend products
Data Quality Management
Principles of data quality
Identifying data quality issues
Cleansing data in Talend Data Stewardship
Task Management
Creating and managing tasks
Assigning tasks to data stewards
Workflow management
Collaboration and Workflow Customization
Collaborative features in Talend Data Stewardship
Customizing workflows
Best practices for effective collaboration
Advanced Features and Techniques
Advanced data cleansing techniques
Handling complex data quality scenarios
Automating data stewardship processes
Monitoring and Reporting
Monitoring data quality
Reporting in Talend Data Stewardship
Analyzing data stewardship metrics
Case Studies and Real-world Applications
Case study analysis
Applying Talend Data Stewardship in different industries
Problem-solving in data stewardship scenarios
Best Practices and Governance
Establishing data governance policies
Best practices for data stewards
Ensuring compliance and data security
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700038008
[source_title] => Talend Data Stewardship
[source_language] => en
[cert_code] =>
[weight] => -1001
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => talenddatastewardship
)
[talendesb] => stdClass Object
(
[course_code] => talendesb
[hr_nid] => 209048
[title] => Talend Open Studio for ESB
[requirements] =>
An understanding of Service-Oriented Architectures (SOA)
An understanding of Enterprise Service Bus (ESB)
A good understanding of Java
Audience
ESB developers
Java application developers
Software architects
[overview] =>
Talend Open Studio for ESB is an open-source, real-time application integration tool for service mediation and routing. It simplifies the integration of enterprise-class systems, services and applications. By service-enabling applications and legacy systems, it enables the creation of Service-Oriented Architectures (SOA).
In this instructor-led, live training, 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.
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
[category_overview] =>
In this instructor-led, live training in <loc>, 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.
[outline] =>
Introduction
Integrating applications and data management in complex, heterogeneous environments
An understanding of data analytics and database concepts
Experience in SQL
Audience
Data scientists
Developers
[overview] =>
Redash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc.
This instructor-led, live training (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
[outline] =>
Introduction
Redash vs Metabase vs Superset
Overview of Redash features and advantages
Getting Started
Installing Redash
Supported data sources
Connecting to different data sources
Configuring users and groups
Querying Data
Creating, editing, and publishing queries
Running queries from QRDS
Adding query parameters
Scheduling queries
Using favorites and tagging
Downloading query results
Using query filters and snippets
Creating Visualizations and Dashboards
Adding, editing, and embedding visualizations
Setting up chart visualizations
Other visualization types
Combining visualizations in a dashboard
Managing dashboard permissions
Sharing and embedding dashboards
Setting Up Alerts
Creating an alert
Adding an alert destination
Customizing notification messages
Configuring multiple column alerts
Working with Integrations and APIs
Accessing APIs with Python
Connecting Redash to Zapier
Importing query results into Google Spreadsheets
Configuring an SSH tunnel using API
Best Practices and Troubleshooting
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037800
[source_title] => Data Analysis with Redash
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => redash
)
[metabase] => stdClass Object
(
[course_code] => metabase
[hr_nid] => 379119
[title] => Business Intelligence and Data Analysis with Metabase
[requirements] =>
An understanding of data analytics and database concepts
Audience
Data analysts
Data scientists
[overview] =>
Metabase is an open source business intelligence (BI) tool. It provides a simple and user-friendly interface for creating and configuring data visualizations and dashboards.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037799
[source_title] => Business Intelligence and Data Analysis with Metabase
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => metabase
)
[qlikviewforbusiness] => stdClass Object
(
[course_code] => qlikviewforbusiness
[hr_nid] => 282606
[title] => QlikView for Business Users
[requirements] =>
No programming experience required
Audience
Managers
Business users
[overview] =>
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
[outline] =>
Introduction to QlikView
Overview of QlikView Features
Installing and Configuring QlikView
Setting User Preferences
Configuring Document Properties
Creating Visualizations in QlikView
Managing Data Sources
Creating and Modifying Objects
Managing QlikView Sheets and Files
Working with Sheets in QlikView
Exporting QlikView Data to Excel
Creating Summaries and Charts in QlikView
Sorting and Filtering QlikView Data
Creating and Modifying Charts
Building and Manipulating Pivot Tables in QlikView
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Build data models with QlikView.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Google Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
Understanding of business intelligence (BI) principles and practices
Basic experience in data analysis, report generation, and dashboard creation
Audience
Data analysts
IT professionals
[overview] =>
IBM Cognos Analytics 11 is a comprehensive, web-based business intelligence suite that offers an integrated platform for reporting, analytics, scorecarding, and monitoring of events and metrics.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
[outline] =>
Introduction
Overview of Cognos 11
Key differences between Cognos 10 and Cognos 11
Benefits of upgrading
Navigating the Cognos 11 Environment
User Interface changes
Overview dashboard and report interface
Customization and personalization features
Data Modules and Management
Introduction to data Modules
Differences in data Management between Cognos 10 and 11
IBM Cognos Analytics is a business intelligence suite by IBM. IBM Cognos Analytics provides a flexible analytical and reporting environment for medium and large enterprises.
This instructor-led, live training (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
Alteryx is a self-service data analytics platform. It provides tools for users to quickly prepare, conform, and analyze data from any source.
This instructor-led, live training (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
[outline] =>
Introduction to Pentaho Open Source BI Suite Community Edition (CE)
Overview of CE Features and Architecture
Pentaho Community Edition vs. Enterprise Edition
Pentaho CE Tools
Installing and Configuring Pentaho CE
Using the Pentaho CE Business Analytics User Console
Creating Reports with the Pentaho CE Business Analytics Report Designer
Performing Data Integration in Pentaho CE
Working with Databases in Pentaho CE
Relational Databases
NoSQL Sources
Analytic Databases
Working with the Analysis View in Pentaho CE
Predictive Analytics
Working with Big Data in Pentaho CE
Graphical Designer for Big Data
Maximizing the Community Online Forums of Pentaho CE
Understanding of database architecture and virtual machines
Basic knowledge of Oracle databases
Audience
Database Administrators
Data Architects
Developers
[overview] =>
Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Oracle GoldenGate features and architecture
Understanding Oracle GoldenGate processing methods and databases
Basic knowledge of systems architecture and networking
Understanding of ETL (Extract, Transform, Load) fundamentals
Experience with query and scripting languages (SQL, JavaScript, etc.)
Comprehension of the IAM (Identity Access Management) framework
Basic knowledge of cloud services
Audience
System Administrators
Data Scientists
Data Analysts
[overview] =>
Talend Administration Center (TAC) is the centralized commanding application of the Talend software suite. It is implemented by Talend solutions as a web application and integrates other Talend tools to efficiently administer information processes. Talend Administration Center allows its users to manage their business systems and convert data sets into insights that are useful to the enterprise.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Administration Center Features and Architecture
Setting Up and Configuring Talend Administration Center
Other TAC Modules and GIT Repository Configuration
Making Use of the TAC Management Console for User Creation
Overview of Talend Administration Center Groups for Different User Roles
Integrating Talent Studio with Talend Administration Center
Utilizing the Talend Administration Center Panes
The Main Browser Pane and Principal Browser Views
Navigating and Accessing User Tasks Based on User Roles
Managing User Roles, Authorizations, Projects, and References
Monitoring Servers and Activities During Runtime
Creating, Deploying, and Running Plans, Projects, and Jobs
Recovering and Restarting User Activities
Executing Administrative Tasks from Remote Engines
Connecting to the Talend Cloud
Building and Executing Business Routines
Encrypting Logging Events in Talend Administration Center
Administering Metadata and Product Documentation
SQL Templates in the TAC Database
Securing the Talend System with Hashing Technology
Managing the Lifecycle and Status of the Talend Environment
An understanding of ETL (Extract, Transform, Load) concepts
Audience
Business intelligence professionals
Database professionals
SQL Developers
ETL Developers
Solution architects
Data architects
Data warehousing professionals
System administrators and integrators
[overview] =>
Talend Open Studio for Big Data is an open source ETL tool for processing big data. It includes a development environment to interact with Big Data sources and targets, and run jobs without having to write code.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of "Open Studio for Big Data" Features and Architecture
Talend Cloud is an open-source platform that provides end-to-end data integration and management solutions. Talend Cloud specializes in big data, data quality, master data management, and application integration for businesses.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Cloud Features and Architecture
Basic knowledge of database systems and data processing
Audience
Data analysts
Data managers
IT professionals
[overview] =>
Talend Data Stewardship is a tool that provides a framework for managing, monitoring, and resolving data quality issues in an organization.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Understanding data stewardship
The role of data stewards
Overview of Talend Data Stewardship
Getting Started
Navigating the interface
Setting up your environment
Integration with other Talend products
Data Quality Management
Principles of data quality
Identifying data quality issues
Cleansing data in Talend Data Stewardship
Task Management
Creating and managing tasks
Assigning tasks to data stewards
Workflow management
Collaboration and Workflow Customization
Collaborative features in Talend Data Stewardship
Customizing workflows
Best practices for effective collaboration
Advanced Features and Techniques
Advanced data cleansing techniques
Handling complex data quality scenarios
Automating data stewardship processes
Monitoring and Reporting
Monitoring data quality
Reporting in Talend Data Stewardship
Analyzing data stewardship metrics
Case Studies and Real-world Applications
Case study analysis
Applying Talend Data Stewardship in different industries
Problem-solving in data stewardship scenarios
Best Practices and Governance
Establishing data governance policies
Best practices for data stewards
Ensuring compliance and data security
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700038008
[source_title] => Talend Data Stewardship
[source_language] => en
[cert_code] =>
[weight] => -1001
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => talenddatastewardship
)
[talendesb] => stdClass Object
(
[course_code] => talendesb
[hr_nid] => 209048
[title] => Talend Open Studio for ESB
[requirements] =>
An understanding of Service-Oriented Architectures (SOA)
An understanding of Enterprise Service Bus (ESB)
A good understanding of Java
Audience
ESB developers
Java application developers
Software architects
[overview] =>
Talend Open Studio for ESB is an open-source, real-time application integration tool for service mediation and routing. It simplifies the integration of enterprise-class systems, services and applications. By service-enabling applications and legacy systems, it enables the creation of Service-Oriented Architectures (SOA).
In this instructor-led, live training, 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.
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
[category_overview] =>
In this instructor-led, live training in <loc>, 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.
[outline] =>
Introduction
Integrating applications and data management in complex, heterogeneous environments
An understanding of data analytics and database concepts
Experience in SQL
Audience
Data scientists
Developers
[overview] =>
Redash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc.
This instructor-led, live training (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
[outline] =>
Introduction
Redash vs Metabase vs Superset
Overview of Redash features and advantages
Getting Started
Installing Redash
Supported data sources
Connecting to different data sources
Configuring users and groups
Querying Data
Creating, editing, and publishing queries
Running queries from QRDS
Adding query parameters
Scheduling queries
Using favorites and tagging
Downloading query results
Using query filters and snippets
Creating Visualizations and Dashboards
Adding, editing, and embedding visualizations
Setting up chart visualizations
Other visualization types
Combining visualizations in a dashboard
Managing dashboard permissions
Sharing and embedding dashboards
Setting Up Alerts
Creating an alert
Adding an alert destination
Customizing notification messages
Configuring multiple column alerts
Working with Integrations and APIs
Accessing APIs with Python
Connecting Redash to Zapier
Importing query results into Google Spreadsheets
Configuring an SSH tunnel using API
Best Practices and Troubleshooting
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037800
[source_title] => Data Analysis with Redash
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => redash
)
[metabase] => stdClass Object
(
[course_code] => metabase
[hr_nid] => 379119
[title] => Business Intelligence and Data Analysis with Metabase
[requirements] =>
An understanding of data analytics and database concepts
Audience
Data analysts
Data scientists
[overview] =>
Metabase is an open source business intelligence (BI) tool. It provides a simple and user-friendly interface for creating and configuring data visualizations and dashboards.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037799
[source_title] => Business Intelligence and Data Analysis with Metabase
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => metabase
)
[qlikviewforbusiness] => stdClass Object
(
[course_code] => qlikviewforbusiness
[hr_nid] => 282606
[title] => QlikView for Business Users
[requirements] =>
No programming experience required
Audience
Managers
Business users
[overview] =>
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
[outline] =>
Introduction to QlikView
Overview of QlikView Features
Installing and Configuring QlikView
Setting User Preferences
Configuring Document Properties
Creating Visualizations in QlikView
Managing Data Sources
Creating and Modifying Objects
Managing QlikView Sheets and Files
Working with Sheets in QlikView
Exporting QlikView Data to Excel
Creating Summaries and Charts in QlikView
Sorting and Filtering QlikView Data
Creating and Modifying Charts
Building and Manipulating Pivot Tables in QlikView
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Build data models with QlikView.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Google Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
Understanding of business intelligence (BI) principles and practices
Basic experience in data analysis, report generation, and dashboard creation
Audience
Data analysts
IT professionals
[overview] =>
IBM Cognos Analytics 11 is a comprehensive, web-based business intelligence suite that offers an integrated platform for reporting, analytics, scorecarding, and monitoring of events and metrics.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
[outline] =>
Introduction
Overview of Cognos 11
Key differences between Cognos 10 and Cognos 11
Benefits of upgrading
Navigating the Cognos 11 Environment
User Interface changes
Overview dashboard and report interface
Customization and personalization features
Data Modules and Management
Introduction to data Modules
Differences in data Management between Cognos 10 and 11
IBM Cognos Analytics is a business intelligence suite by IBM. IBM Cognos Analytics provides a flexible analytical and reporting environment for medium and large enterprises.
This instructor-led, live training (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
Alteryx is a self-service data analytics platform. It provides tools for users to quickly prepare, conform, and analyze data from any source.
This instructor-led, live training (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
[outline] =>
Introduction to Pentaho Open Source BI Suite Community Edition (CE)
Overview of CE Features and Architecture
Pentaho Community Edition vs. Enterprise Edition
Pentaho CE Tools
Installing and Configuring Pentaho CE
Using the Pentaho CE Business Analytics User Console
Creating Reports with the Pentaho CE Business Analytics Report Designer
Performing Data Integration in Pentaho CE
Working with Databases in Pentaho CE
Relational Databases
NoSQL Sources
Analytic Databases
Working with the Analysis View in Pentaho CE
Predictive Analytics
Working with Big Data in Pentaho CE
Graphical Designer for Big Data
Maximizing the Community Online Forums of Pentaho CE
Understanding of database architecture and virtual machines
Basic knowledge of Oracle databases
Audience
Database Administrators
Data Architects
Developers
[overview] =>
Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Oracle GoldenGate features and architecture
Understanding Oracle GoldenGate processing methods and databases
Basic knowledge of systems architecture and networking
Understanding of ETL (Extract, Transform, Load) fundamentals
Experience with query and scripting languages (SQL, JavaScript, etc.)
Comprehension of the IAM (Identity Access Management) framework
Basic knowledge of cloud services
Audience
System Administrators
Data Scientists
Data Analysts
[overview] =>
Talend Administration Center (TAC) is the centralized commanding application of the Talend software suite. It is implemented by Talend solutions as a web application and integrates other Talend tools to efficiently administer information processes. Talend Administration Center allows its users to manage their business systems and convert data sets into insights that are useful to the enterprise.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Administration Center Features and Architecture
Setting Up and Configuring Talend Administration Center
Other TAC Modules and GIT Repository Configuration
Making Use of the TAC Management Console for User Creation
Overview of Talend Administration Center Groups for Different User Roles
Integrating Talent Studio with Talend Administration Center
Utilizing the Talend Administration Center Panes
The Main Browser Pane and Principal Browser Views
Navigating and Accessing User Tasks Based on User Roles
Managing User Roles, Authorizations, Projects, and References
Monitoring Servers and Activities During Runtime
Creating, Deploying, and Running Plans, Projects, and Jobs
Recovering and Restarting User Activities
Executing Administrative Tasks from Remote Engines
Connecting to the Talend Cloud
Building and Executing Business Routines
Encrypting Logging Events in Talend Administration Center
Administering Metadata and Product Documentation
SQL Templates in the TAC Database
Securing the Talend System with Hashing Technology
Managing the Lifecycle and Status of the Talend Environment
An understanding of ETL (Extract, Transform, Load) concepts
Audience
Business intelligence professionals
Database professionals
SQL Developers
ETL Developers
Solution architects
Data architects
Data warehousing professionals
System administrators and integrators
[overview] =>
Talend Open Studio for Big Data is an open source ETL tool for processing big data. It includes a development environment to interact with Big Data sources and targets, and run jobs without having to write code.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of "Open Studio for Big Data" Features and Architecture
Talend Cloud is an open-source platform that provides end-to-end data integration and management solutions. Talend Cloud specializes in big data, data quality, master data management, and application integration for businesses.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Overview of Talend Cloud Features and Architecture
Basic knowledge of database systems and data processing
Audience
Data analysts
Data managers
IT professionals
[overview] =>
Talend Data Stewardship is a tool that provides a framework for managing, monitoring, and resolving data quality issues in an organization.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[outline] =>
Introduction
Understanding data stewardship
The role of data stewards
Overview of Talend Data Stewardship
Getting Started
Navigating the interface
Setting up your environment
Integration with other Talend products
Data Quality Management
Principles of data quality
Identifying data quality issues
Cleansing data in Talend Data Stewardship
Task Management
Creating and managing tasks
Assigning tasks to data stewards
Workflow management
Collaboration and Workflow Customization
Collaborative features in Talend Data Stewardship
Customizing workflows
Best practices for effective collaboration
Advanced Features and Techniques
Advanced data cleansing techniques
Handling complex data quality scenarios
Automating data stewardship processes
Monitoring and Reporting
Monitoring data quality
Reporting in Talend Data Stewardship
Analyzing data stewardship metrics
Case Studies and Real-world Applications
Case study analysis
Applying Talend Data Stewardship in different industries
Problem-solving in data stewardship scenarios
Best Practices and Governance
Establishing data governance policies
Best practices for data stewards
Ensuring compliance and data security
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700038008
[source_title] => Talend Data Stewardship
[source_language] => en
[cert_code] =>
[weight] => -1001
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => talenddatastewardship
)
[talendesb] => stdClass Object
(
[course_code] => talendesb
[hr_nid] => 209048
[title] => Talend Open Studio for ESB
[requirements] =>
An understanding of Service-Oriented Architectures (SOA)
An understanding of Enterprise Service Bus (ESB)
A good understanding of Java
Audience
ESB developers
Java application developers
Software architects
[overview] =>
Talend Open Studio for ESB is an open-source, real-time application integration tool for service mediation and routing. It simplifies the integration of enterprise-class systems, services and applications. By service-enabling applications and legacy systems, it enables the creation of Service-Oriented Architectures (SOA).
In this instructor-led, live training, 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.
Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice
[category_overview] =>
In this instructor-led, live training in <loc>, 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.
[outline] =>
Introduction
Integrating applications and data management in complex, heterogeneous environments
An understanding of data analytics and database concepts
Experience in SQL
Audience
Data scientists
Developers
[overview] =>
Redash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc.
This instructor-led, live training (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and developers who wish to use Redash to run SQL-based queries and visualize data from multiple sources.
By the end of this training, participants will be able to:
Set up and install Redash to start creating data visualizations and dashboards.
Connect Redash to different data sources such as Postgres, MongoDB, Databricks, etc.
Learn how to query and combine complex data from multiple database sources.
Write and execute SQL queries and build collaborative data visualizations and dashboards.
Use Redash's API endpoints to enable integrations with other web applications.
[outline] =>
Introduction
Redash vs Metabase vs Superset
Overview of Redash features and advantages
Getting Started
Installing Redash
Supported data sources
Connecting to different data sources
Configuring users and groups
Querying Data
Creating, editing, and publishing queries
Running queries from QRDS
Adding query parameters
Scheduling queries
Using favorites and tagging
Downloading query results
Using query filters and snippets
Creating Visualizations and Dashboards
Adding, editing, and embedding visualizations
Setting up chart visualizations
Other visualization types
Combining visualizations in a dashboard
Managing dashboard permissions
Sharing and embedding dashboards
Setting Up Alerts
Creating an alert
Adding an alert destination
Customizing notification messages
Configuring multiple column alerts
Working with Integrations and APIs
Accessing APIs with Python
Connecting Redash to Zapier
Importing query results into Google Spreadsheets
Configuring an SSH tunnel using API
Best Practices and Troubleshooting
Summary and Next Steps
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037800
[source_title] => Data Analysis with Redash
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => redash
)
[metabase] => stdClass Object
(
[course_code] => metabase
[hr_nid] => 379119
[title] => Business Intelligence and Data Analysis with Metabase
[requirements] =>
An understanding of data analytics and database concepts
Audience
Data analysts
Data scientists
[overview] =>
Metabase is an open source business intelligence (BI) tool. It provides a simple and user-friendly interface for creating and configuring data visualizations and dashboards.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
[language] => en
[duration] => 14
[status] => published
[changed] => 1700037799
[source_title] => Business Intelligence and Data Analysis with Metabase
[source_language] => en
[cert_code] =>
[weight] => 0
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => metabase
)
[qlikviewforbusiness] => stdClass Object
(
[course_code] => qlikviewforbusiness
[hr_nid] => 282606
[title] => QlikView for Business Users
[requirements] =>
No programming experience required
Audience
Managers
Business users
[overview] =>
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to use QlikView to support decision making in their organization.
By the end of this training, participants will be able to:
Install and configure QlikView.
Analyze and display data using QliKView.
Use data discoveries from QlikView to support decision making.
[outline] =>
Introduction to QlikView
Overview of QlikView Features
Installing and Configuring QlikView
Setting User Preferences
Configuring Document Properties
Creating Visualizations in QlikView
Managing Data Sources
Creating and Modifying Objects
Managing QlikView Sheets and Files
Working with Sheets in QlikView
Exporting QlikView Data to Excel
Creating Summaries and Charts in QlikView
Sorting and Filtering QlikView Data
Creating and Modifying Charts
Building and Manipulating Pivot Tables in QlikView
QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.
In this instructor-led, live training (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Build data models with QlikView.
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.
[category_overview] =>
In this instructor-led, live training in <loc> (online or onsite), participants will learn how to start developing with QlikView.
By the end of this training, participants will be able to:
Install and configure QlikView.
Transform data from various sources through QlikView scripting.
Google Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more.
This instructor-led, live training (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.
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.
[category_overview] =>
This instructor-led, live training in <loc> (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.
Understanding of business intelligence (BI) principles and practices
Basic experience in data analysis, report generation, and dashboard creation
Audience
Data analysts
IT professionals
[overview] =>
IBM Cognos Analytics 11 is a comprehensive, web-based business intelligence suite that offers an integrated platform for reporting, analytics, scorecarding, and monitoring of events and metrics.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.
By the end of this training, participants will be able to:
Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
Utilize the improved data module and data management features for more efficient data handling.
Implement best practices for a smooth transition and optimal use of Cognos 11.
[outline] =>
Introduction
Overview of Cognos 11
Key differences between Cognos 10 and Cognos 11
Benefits of upgrading
Navigating the Cognos 11 Environment
User Interface changes
Overview dashboard and report interface
Customization and personalization features
Data Modules and Management
Introduction to data Modules
Differences in data Management between Cognos 10 and 11
IBM Cognos Analytics is a business intelligence suite by IBM. IBM Cognos Analytics provides a flexible analytical and reporting environment for medium and large enterprises.
This instructor-led, live training (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.
By the end of this training, participants will be able to:
Analyze and share insights about data.
Visualize business performance.
Use AI-assisted preparation to cleanse and combine data sources.
Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.
Alteryx is a self-service data analytics platform. It provides tools for users to quickly prepare, conform, and analyze data from any source.
This instructor-led, live training (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.
By the end of this training, participants will be able to:
Learn to use and configure all the tools in the developer tab.
Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
Learn how to use API tools to download and parse web data.
Use Alteryx scripting tools, including Python and R.