Pentaho

Reading Time: 2 minutes

Pentaho

    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