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
Need help picking the right course?
Pentaho Open Source BI Suite Community Edition (CE) Training Course - Enquiry
Testimonials (1)
It's a hands-on session.
Vorraluck Sarechuer - Total Access Communication Public Company Limited (dtac)
Course - Talend Open Studio for ESB
Related Courses
Advanced Data Integration and Visualization with Looker Studio
14 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at intermediate-level participants who wish to master advanced data integration and visualization techniques in Looker Studio, and learn how to connect diverse data sources, design compelling dashboards, and automate reporting workflows to drive better business decisions.
By the end of this training, participants will be able to:
- Connect and integrate multiple data sources into Looker Studio.
- Create custom metrics and calculated fields for tailored analysis.
- Design advanced visualizations, including interactive filters and charts.
- Automate reporting workflows for real-time data updates.
- Apply best practices for visual storytelling and report customization.
Excel and Google Sheets
14 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.
By the end of this training, participants will be able to:
- Navigate and utilize the core features of Excel and Google Sheets.
- Perform data analysis and create actionable insights using advanced spreadsheet techniques.
- Collaborate in real-time using Google Sheets for seamless teamwork.
- Create reusable templates for reporting, tracking, and project management.
Google Sheets for Excel Users
14 HoursThis instructor-led, live training in Kenya (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.
Getting Started with Looker Studio
14 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at beginner-level to intermediate-level participants who wish to build foundational skills for data visualization and reporting using Looker Studio, and learn how to connect data sources, visualize information effectively, and gain actionable insights.
By the end of this training, participants will be able to:
- Understand the core features of Looker Studio and its use cases.
- Set up Looker Studio and connect to various data sources.
- Create engaging dashboards with charts, graphs, and filters.
- Customize reports for specific audiences and business needs.
- Collaborate on and share dashboards effectively.
Business Intelligence and Data Analysis with Metabase
14 HoursThis instructor-led, live training in Kenya (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.
Oracle GoldenGate
14 HoursThis instructor-led, live training in Kenya (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.
QlikView for Business Users
7 HoursIn this instructor-led, live training in Kenya (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.
QlikView for Developers
14 HoursIn this instructor-led, live training in Kenya (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.
Data Analysis with Redash
14 HoursThis instructor-led, live training in Kenya (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.
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.
Talend Administration Center (TAC)
14 HoursThis instructor-led, live training in Kenya (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 Big Data Integration
28 HoursThis instructor-led, live training in Kenya (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 Cloud
7 HoursThis instructor-led, live training in Kenya (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 Kenya (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.
Talend Open Studio for ESB
21 HoursIn this instructor-led, live training in Kenya, 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.