Pentaho Online Training

Pentaho Reporting is a suite (collection of tools) for creating relational and analytical reports. It can be used to transform data into meaningful information. Pentaho allows generating reports in HTML, Excel, PDF, Text, CSV, and xml. This tutorial provides a basic understanding of how to generate professional reports using Pentaho Report Designer.

Pentaho can accept data from different data sources including SQL databases, OLAP data sources, and even the Pentaho Data Integration ETL tool.

Pentaho Online Training Course Content
  • Introduction to BI and Dimensional Modeling
    • Basic Architecture of Pentaho
    • Pentaho BI Suite introduction and it's Components
    • PDI
    • Design Studio
    • Metadata Editor
    • Report Designer
    • Schema Work Bench.
  • Dealing with repository
    • Importance of repository and its usage
    • Creating a repository
    • Three 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
  • 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

Please Register with us