Pentaho Open Source BI Suite Community Edition (CE) Training Course
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.
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
Open Training Courses require 5+ participants.
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
Testimonials (2)
Very clearly articulated and explained
Harshit Arora - PwC South East Asia Consulting
Course - Alteryx for Developers
It's a hands-on session.
Vorraluck Sarechuer - Total Access Communication Public Company Limited (dtac)
Course - Talend Open Studio for ESB
Related Courses
Oracle GoldenGate
14 HoursThis instructor-led, live training in Denmark (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.
Talend Open Studio for ESB
21 HoursIn this instructor-led, live training in Denmark, 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.
Talend Big Data Integration
28 HoursThis instructor-led, live training in Denmark (online or onsite) is aimed at technical persons who wish to deploy Talend Open Studio for Big Data to simplifying the process of reading and crunching through Big Data.
By the end of this training, participants will be able to:
- Install and configure Talend Open Studio for Big Data.
- Connect with Big Data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
- Understand and set up Open Studio's big data components and connectors.
- Configure parameters to automatically generate MapReduce code.
- Use Open Studio's drag-and-drop interface to run Hadoop jobs.
- Prototype big data pipelines.
- Automate big data integration projects.
Talend Administration Center (TAC)
14 HoursThis instructor-led, live training in Denmark (online or onsite) is aimed at system administrators, data scientists, and business analysts who wish to set up Talend Administration Center to deploy and manage the organization's roles and tasks.
By the end of this training, participants will be able to:
- Install and configure Talend Administration Center.
- Understand and implement Talend management fundamentals.
- Build, deploy, and run business projects or tasks in Talend.
- Monitor the security of datasets and develop business routines based on the TAC framework.
- Obtain a broader comprehension of big data applications.
Talend Cloud
7 HoursThis instructor-led, live training in Denmark (online or onsite) is aimed at data administrators and developers who wish to manage, monitor, and operate data integration processes using Talend Cloud services.
By the end of this training, participants will be able to:
- Navigate the Talend Management Console to manage users and roles in the platform.
- Evaluate data to find and understand relevant datasets.
- Create a pipeline to process and monitor data at rest or in action.
- Prepare data for analysis to generate insights relevant to the business.
Talend Data Stewardship
14 HoursThis instructor-led, live training in Denmark (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.
Sensor Fusion Algorithms
14 HoursSensor Fusion is the combination and integration of data from multiple sensors to provide a more accurate, reliable and contextual view of data.
Sensor Fusion implementations require algorithms to filter and integrate different data sources.
Audience
This course is targeted at engineers, programmers and architects who deal with multi-sensor implementations.
Data Analysis with Redash
14 HoursThis instructor-led, live training in Denmark (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.
Business Intelligence and Data Analysis with Metabase
14 HoursThis instructor-led, live training in Denmark (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.
QlikView for Developers
14 HoursIn this instructor-led, live training in Denmark (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.
QlikView for Business Users
7 HoursIn this instructor-led, live training in Denmark (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.
Google Sheets for Excel Users
14 HoursThis instructor-led, live training in Denmark (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.
IBM Cognos Analytics
14 HoursThis instructor-led, live training in Denmark (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.
Cognos 11
14 HoursThis instructor-led, live training in Denmark (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.
Alteryx for Developers
14 HoursThis instructor-led, live training in Denmark (online or onsite) is aimed at data scientists who wish to use Alteryx for data analysis.
By the end of this training, participants will be able to:
- Prepare data in Alteryx to later visualize in Power BI or Excel.
- Create and Perform ETL operations with little to no code.
- Embed custom R code inside Alteryx.