IICT provides 100% real-time, practical and placement focused Pentaho training in kovur. Our Pentaho course concentrates from basic level training to advanced level training. Our Pentaho training in completely focused to get placement in MNC in kovur and certification on Pentaho after completion of our course. Our team of Pentaho trainers are Pentaho certified professionals with more real-time experience in live projects. Our Pentaho Course syllabus is enough for anyone who wants to get Pentaho certification which meets industry expectations. In our course plan, you will learn Pentaho Course Overview, Introduction to BI and Dimensional Modeling, Dealing with repository, Dealing with Transformations, Dealing with Jobs, Dealing with Variables, Dealing with Parameters, Pentaho Reporting, Pentaho Dashboards, Pentaho Cubes along with live examples.
Our Pentaho training center is equipped with lab facilities and excellent infrastructure. We also provide Pentaho certification training path for our students in kovur. Through our associated Pentaho training center, we have trained more than 500+ Pentaho students and provided 90 percent placement. Our Pentaho Training course fee is value for money and tailor-made course fee based on the each student's training requirements. Pentaho training in kovur conducted on day time classes, weekend training classes, evening batch classes and fast track training classes
Basic Architecture of PentahoIntroduction to Pentaho BI suite and number of components in it.(PDI,Metadata Editor, Schema Work bench, Report Designer, Design Studio)
Various component of PDI a.k.a kettle (Spoon/Pan/Kitchen)Usage of spoon/pan/kitchen
Dealing with repository
Importance of repository and its usage
Creating a repository
Types of repositories and their specific usage
Taking the backup of repositoryRestoring the repository
Dealing with Transformations
Creating simple transformations
Saving the transformation to the repository
Executing the transformation
Introduction to basic steps (various input,output,transformation steps) ï‚· Understanding Steps In Detail
Use of various input steps
Use of various output steps
Use of various transformation steps
Use of Joins
Flow controls available in PDI
Lookup data at various sources
Data Validation
Mappings
Regular Expression
Dealing with Jobs
Creating jobs
Executing transformation using jobs
Passing and retrieving data to/from the transformations.
Conditional execution of jobs
Pre-execution Validation with job.
File management through Jobs
Dealing with Variables
Creating and using variables within transformation/job
How to create variables and how to use them in transformations
Where to use variables
Scope of variables
Dealing with Parameters
Creating and using parameters
System parameters
User defined parameters
Scheduling of job/transformation
Running & debugging of jobs and transformation,Storing Log Information into log tables
SCD implementation How to implement Slowly Changing Dimension using Pentaho kettle.
CDC Implementation How to implement Change Data capture logic using kettle
Best Practices , Performance Tuning and QA
Creating data source connection(JDBC/JNDI/XML/OLAP/PDI) ï‚· Report Template(Headers etc) ï‚· Report Formatting
Create a report using different types of database connection
Create a report using Pentaho OLAP Cube
Charts
Use of formula
Conditional Formatting of Row
Conditional Formatting
Parameter Creation
Use of sub-reports
Publish the Reports to BI Server
User Level Security
Hyperlinking Reports
Introduction to Pentaho BI Server and Pentaho Enterprise Server
Create a DATASOURCE at BI Serer
Create Simple Pentaho Dashboard using Pentaho Dashboard Designer
Create a drill down dashboard
Best Practices
Introduction to Pentaho BI Server and Pentaho Enterprise Server
Create a DATASOURCE at BI Server
Create Simple Pentaho Dashboard using Pentaho Dashboard Designer.
Create a drill down dashboard
Best Practices