Pentaho Online Training | Pentaho Training | Pentaho Course online

Pentaho Online Training 

• Introduction to BI and Dimensional Modeling
• 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 repository1>Importance of repository and its usage2>Creating a repository3>3 Types of repositories and their specific usage4> Taking the backup of repositoryRestoring the repository
• Dealing with Transformations1>Creating simple transformations2>Saving the transformation to the repository3> Executing the transformation4> Introduction to basic steps (various input,output,transformation steps)
• Understanding Steps In Detail1> Use of various input steps2> Use of various output steps3> Use of various transformation steps4> Use of Joins5>Flow controls available in PDI6> Lookup data at various sources7> Data Validation8> Mappings9> Regular Expression
• Dealing with Jobs1> Creating jobs2> Executing transformation using jobs3> Passing and retrieving data to/from the transformations.4>Conditional execution of jobs5> Pre-execution Validation with job.6> File management through Jobs
• Dealing with Variables1. Creating and using variables within transformation/job2. How to create variables and how to use them in transformations3. Where to use variables4. Scope of variables
• Dealing with Parameters1. Creating and using parameters2. System parameters3. 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

Pentaho Reporting

• 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

Pentaho Dashboards

• 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

Pentaho Cubes

• 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