Curriculam

Module 1: 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
Module 2: 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
Module 3: 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
Module 4: 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
Module 5: Dealing with Parameters
• Creating and using parameters
• System parameters
• User defined parameters
Module 6: 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
Module 7: 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
Module 8: 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
Module 9: Pentaho Cubes
• 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