1 / 14

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

Learn Pentaho Course with Our Online Training Real Time Experts over 10 years on IT and Software Projects Try Demo Classes from Hyderabad, Bangalore, Chennai, and Dubai, India. A1Trainings provides Corporate and Classroom Trainings for students @ 91 768-081-3158

PriyankaCH
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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,StoringLog 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 • HyperlinkingReports

  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@a1trainings.com • Call us: 7680813158 • Web: www.a1trainings.com

More Related