Session : 1 – Introduction to BI and Dimensional Modeling
Session : 2 – Basic Architecture of PentahoIntroduction to Pentaho BI suite and number of components in it.(PDI,Metadata Editor, Schema Work bench, Report Designer, Design Studio)
Session 3: – Various component of PDI a.k.a kettle (Spoon/Pan/Kitchen)Usage of spoon/pan/kitchen
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
Session : 5 – 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
Session : 5 – 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
Session : 6 – 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
Session : 7 – Dealing with Parameters
- Creating and using parameters
- System parameters
- User defined parameters
Session : 8 – Scheduling of job/transformation
Session : 9 – Running & debugging of jobs and transformation,Storing Log Information into log tables
Session : 10 – SCD implementation How to implement Slowly Changing Dimension using Pentaho kettle.
Session : 11 – CDC Implementation How to implement Change Data capture logic using kettle
Session : 12 – Best Practices , Performance Tuning and QA
Session : 13 – 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
Session : 14 – 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
Session : 15 – 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
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.