Pentaho BI Online Training
Attend Expert level online Pentaho BI training with certification material pdf Learn Pentaho BI Training record Tutorial Videos Enroll today for free demo class best online training Institute within reasonable cost Pentaho BI Dumps Top 10 20 50 100 Interview Questions and Answers 2019-2020 Australia Bangalore Canada Chennai Chicago Dubai England France Germany Hyderabad Houston Kuwait London Los Angeles Malaysia New York Mexico Noida Pune Singapore South Africa Texas Qatar USA
Best Institute for learn exert level Online Pentaho BI Training By Experts, Learn Pentaho BI Certification Training with Course Material, Tutorial Videos, Attend Demo for free & you will find Winsomesoft is the best institute within reasonable fee, Job Support
Winsomesoft is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies.The Training in is every thing we explained based on real time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Pentaho BI Course Content
Introduction to BI and Dimensional Modeling
- Basic Architecture of PentahoIntroduction to Pentaho BI suite and number of components in it.( PDI,Metadata Editor, Schema Work bench, Report Designer, Design Studio)
- 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
- 3 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 Join
- 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
- 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
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
Ready to Begin?
Find subjects you're passionate about by browsing our online course categories.Start learning with top courses Built With Industry Experts