Pentaho Training

Clustering is used for statistical analysis in many fields. In Pentaho, multiple nodes join together to make a cluster.

Topics: 

• Basic data integrations in Pentaho
• Move CSV file input to Microsoft Excel output and table output.
• Data transfer from excel to data log and grid. 

Learning outcome: Upon the completion of this chapter you will gain hands-on experience on the above topics. 

A transformation is defined as a network of logical steps. When a transformation is created that reads a flat-file, sorts it, filters it, and moves it to a relational database table. In this section, you will be learning all the concepts related to data transformation. 

Topics: 

• Data integration steps in Pentaho 
• Understanding calculator
• Adding sequenceString replace
• Pentaho number range
• Selecting field value
• String operation
• Sorting and splitting rows
• The process to use  metadata injection
• Unique row and value mapper

Learning outcome: Upon the completion of this chapter you will gain an overall knowledge of the above-mentioned concepts and data transformation process in Pentaho. 

This section has been designed to provide you with the overall knowledge of Pentaho Flow and its associated concepts. 

Topics: 

• Introduction to secure socket command, 
• Pentaho mail, 
• Pentaho error handling and null value 
• Priorities stream and row filter. 

Learning outcome: you will gain practical exposure on concepts like  Handle null values in the data, working with socket command, error handling and gain end to end knowledge of Pentaho flow. 

This section covers overall concepts associated with the deployment SCD in Pentaho.  

Topics: 

• Knowledge of slow-changing dimensions Dynamic transformation
• Making ETL dynamic
• Scripting
• Creating folders
• File management
• Bulk loading
• Pentaho file transfer process
• Utility and File encryption
• Repository, and XML

Learning outcome: Upon the completion of this Deploying SCD concept you will gain hands-on exposure in all the concepts associated with and their contribution in Pentaho BI. 

Pentaho is an environment for ETL development and collaborative analysis. Pentaho Repository is a medium using which Pentaho shares folders and files across products and teams. It also enables you to track the modification and revert previous files by providing a version history. This section will make you knowledgeable in Pentaho repositories concept. 

Topics: 

• Creating dynamic ETL
• Parameter deployment with a transformation
• Sending values and variable from job to transformation 
• Database connection
• Role of Repository in Pentaho
• Repository import and environmental variable.  

Learning outcome:  By the completion of this chapter, you will gain a complete understanding of the Repository concept and its functionality in Pentaho. 

The Pentaho Report Designer is one of the business intelligence tools to design complex reports. Pentaho Report Designer is suites better when the reporting is complex and requires cross linkings. This section is designed to provide you with the complete knowledge of report designer and repository concepts. 

Topics: 

• Working with Pentaho report and dashboard
• Designing a report
• Effect of row bending
• Working with Pentaho Server
• Pie and bar chart in Pentaho
• Creation of line
• Achieving localization in reports.  

Learning Outcome: By the completion of this chapter you will gain an overall working knowledge of Pentaho repositories and designing various reports in Pentaho.  

Pentaho dashboard is an information management tool that is used to track departmental, individual, or enterprise performance and provides critical information that is essential for taking crucial decisions. In this section, you will be learning dashboard concepts in Pentaho and its working process. 

Topics: 

• Introduction to Pentaho dashboard concept
• Drill-down of Report
• Passing parameters in dashboard and report 
• Working with Excel sheets
• Cubes deployment for report creation 
• The data integration process in Pentaho for developing reports 

Learning Outcome: By the completion of this chapter you will gain hands-on- expertise in the above-mentioned Pentaho concepts.  

A cube is a collection of dimensional models centred on a fact table. In this section you will learn the cubes and its associative concepts. 

Topics: 

• What is a cube?
• Developing a Cube
• Benefits of Cube
• Working with cube 
• Reports and dashboard creation with cube 

Learning Outcome: Upon the completion of this module you will gain practical exposure in developing reports and dashboards using Cube. 

The Multi-Dimensional Expression (MDX) is an OLAP database query similar to SQL and also a calculation language. The MDX Language is used to retrieve the database from an OLAP database. In this section, you will learn all the concepts associated with MDX. 

Topics: 

• Introduction to Multidimensional Expression (MDX) 
• Understanding Tuple
• MDX sets, members, level
• MDX implicit dimensions
• Hierarchical navigation
• Dimensions referencing and metadata. 

Learning Outcome: Upon the completion of this chapter you will gain hands-on exposure in Work with MDX, dimensions referencing,  MDX sets, level, members, and other concepts of MDX. 

Pentaho Analyzer helps the users to analyse reports and create visualizations from the data. The analyzer provides you with an easy to use environment where you can prepare reports and visualization using drag and drop options and explore data deeply. In this chapter, you will learn Analyzer and its associated concepts.

Topics: 

• Pentaho analytics findings 
• Advanced analytics for visualizing data 
• Blending various  data sizes and types 
• Extending Analyzer functionality,
• Pentaho REST APIs
• Embedding BA server reports,

Learning Outcome: After completion of this chapter you will be learning complete knowledge of Pentaho Analyzer and its associative concepts.   

Pentaho Data integration provides the ETL capabilities to extract cleanse and store data using a unique format and can be accessed easily. 

Topics: 

• Overview of PDI
• Steps to be followed for creating an ETL job
• The process to use property files 
• Steps required to create an ETL transformation 

Learning Outcome: You will gain practical knowledge of developing ETL transformation with PDI and usage process of property files. In this section you will gain complete knowledge of PDI development concepts. 

Pentaho can be integrated with Hadoop at many levels such as Traditional ETL, Data Orchestration, Pentaho MapReduce for data transformations. In this section you will be learning how ETL connectivity works in Hadoop. 

 Topics: 

• Implementing ETL to work on Hadoop Ecosystem 
• Hadoop Integration 
• Transferring data from local files to distributed file system 
• Designing MapReduce jobs,
• Deploying Apache Hive
• Complete Hadoop integration using ETL. 

Learning Outcome: Upon the completion of this module you will learn how to complete the process associated with Hadoop integration process in Pentaho. 

Dashboards simplify the decision-making process by presenting the complex business data in an easily understandable way. In this section, you will gain overall knowledge of dashboard concepts. 

Topics:

• Developing creative and easy to understand dashboards to gain business insights and to improve business performance. 

Learning Outcome: You will gain practical knowledge in creating highly interactive dashboards for visualizing data. 

In Pentaho, performance tuning helps in finding, locating and remedy bottlenecks in system performance. Performance tuning is a way to respond to issues that arise during production.  In this section you will learn how Performance tuning works in Pentaho. 

Topics covered: 

• Managing BA server logging,Monitoring performance of a jobTuning Pentaho reportsAuditing in Pentaho

Learning outcome: you will gain hands-on expertise in Fine-tune Pentaho report, and monitoring logging in BA server. 

As data has to be integrated with various external as well as internal parties to analyze. In such cases, security issues prevail. In this section, you will be learning how to build security concerns in Pentaho.  

Topics: 

• Ensuring Security levels in external Integration
• Data security
• Extending BA server security 
• Using Kerberos with Pentaho
• Pentaho multi-tenancy support  

Learning Outcome: Upon the completion of this section you will master the process to configure high-level security. 

At HKR, we provide practice tests at the end of course along with Pentaho interview questions, community questions and answers, Sample Resumes, etc to crack the interview.

We at HKR trainings provide the learners with practice Mock Interview Sessions and excellent Job Support at the end of the course.