Pentaho BI Online Training | Online Pentaho BI Certification Course in USA, UK, Canada, Australia, Dubai, India

1
A1Trainings

• Pentaho BI Online Training Online Pentaho BI
  Certification Course in USA, UK, Canada,
  Australia, Dubai, India

2
Pentaho BI Online Training Online Pentaho BI
Certification Course in USA, UK, Canada,
Australia, Dubai, India
3

• 1. Introduction to BI and Dimensional Modeling
• 2. Overview of Pentaho Architecture
• 3. Introduction to Pentaho BI suite and number of
  components in it. (PDI,Metadata Editor, Schema
  Work bench, Report Designer, Design Studio)
• 4. Various components of PDI a.k.a kettle
  (Spoon/Pan/Kitchen)Usage of spoon/pan/kitchen

4
5. 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

5
6. Dealing with Transformations

• Creating simple transformations
• Saving the transformation to the repository
• Executing the transformation
• Introduction to basic steps (various
  input,output,transformation steps)

6
7. Understanding Steps

• Various input steps
• Various output steps
• Various transformation steps
• Joins
• Flow controls available in PDI
• Lookup data at various sources
• Procedure of Data Validation
• Mappings
• Regular Expression

7
8. 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

8
9. Dealing with Variables

• Creating and using variables within
  transformation/job
• Creating and using Variables
• Where we use variables
• Main Scope of variables

9
10. Dealing with Parameters

• Creating and using parameters
• System parameters
• User defined parameters.

10

• 11. Scheduling of job/transformation
• 12. Running debugging of jobs and
  transformation,Storing Log Information into log
  tables
• 13. SCD implementation How to implement Slowly
  Changing Dimension using Pentaho kettle.
• 14. CDC Implementation How to implement Change
  Data capture logic using kettle
• 15. Best Practices , Performance Tuning and QA

11
Pentaho Reporting

• Creating data source connection(JDBC/JNDI/XML/OLAP
  /PDI)
• Templates Reporting
• Formatting Reports
• 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

12
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

13
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

14
Contact Info

• Address Madhapur, Hyderabad.
• Email contact_at_a1trainings.com
• Call us 7680813158
• Web www.a1trainings.com