Pentaho Online Training

 >>  Pentaho Online Training

Pentaho Online Training


 (4.8) | 350 Ratings


Introduction


Pentaho Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Module 1 :  Pentaho Platform Concepts

Topics : Discusses the concepts of Business Intelligence and architecture of the Pentaho BI platform. A brief demonstration and discussion of the different BI tools, and when to use each.2

Module 2 :  Installation of the Pentaho BI Suite

Topics : Provides experience installing the Pentaho BI Suite including adding a Data Source to the Enterprise console.

Module 3 :  Analysis Solutions Overview

Topics : Presents an overview of the concepts and typical architecture of analysis solutions, including star schemas, fact tables and dimensions.

Module 4 :  Dimensional Modeling

Topics :  Describes and provides hands-on experience with dimensional modeling and building star schemas.

Module 5 :  ETL and Pentaho Data Integration Overview

Topics : Explores the concepts and basics of extract, transform, load tools and Pentaho Data Integration. Using the Database Explorer, the automatic creation of SQL to create or alter a relational table. Using the Copy Table Wizard to easily create a new table and load it with data.

Module 6 :  Pentaho Data Integration

Topics : Provides hands on experience with the techniques to pull data from a data source (flatfile, relational table, excel files, etc) and move the data to another source. Labs will load relational from the source OLTP schema to a Star Schema.

Module 7 :  Look-ups and Field Transformations

Topics : Provides experience with the techniques for performing look-ups, joining various sources of data, and transforming individual fields during transformations.

Module 8 : Set and Pivot Transformations

Topics : Builds on the Look-ups and Field Transformations module by exploring for sorting and manipulating sets of data.

Module 9 : Jobs and Transformations

Topics : Explores techniques for arranging transformations into jobs including the scheduling of jobs. Steps discussed include, FTP, SFTP, file creation, waiting for a file, sending email at the success of a job and others.

Module 10 : Pentaho Analysis

Topics : Introduces the tools, concepts, and architecture of Pentaho Analysis. Students create a Mondrian cube against the star schema created on Day 2, then drill and pivot the data using the Pentaho Analysis Tools.

Module 11 :  Schema Workbench

Topics :  Students will learn how to use Schema Workbench to create a basic Analysis cube containing Measures, Dimensions and Hierarchies’.

Module 12 :  Advanced Concepts

Topics :  The importance of Time Dimensions, Calculated Measures, Higher Level Calculations and a brief introduction to the power of MDX.

Module 13 :  Introduction to the Reporting Concepts

Topics : Introduction of the Report Designer to produce high fidelity reports, including SubReport, Charts, Parameter Screens, Calculations and Expressions.

Module 14 : Report Wizard

Topics : Explores techniques for creating and publishing a report using the Report Wizard, and using the Query Designer to visually create the SQL for the report.

Module 15 : Report Designer

Topics :  Provides hands on experience with connecting to a Dataset, Design Elements, and the use of Hyperlinks to drill from one report to another, Charts, Groupings, andSubBands.

Module 16 : Parameterized Reports

Topics :  Use Expressions to add styles to your report like Traffic Lights and the conditional display of objects, creating report parameter screens, Report Functions for creating row and summary calculations, Sub Reports, and creating a report that display multiple report objects for a “Dashboard Feel”.

Module 17 : Dashboard Designer

 Topics : Detailed demonstration and lab using the new Dashboard Designer. A discussion of the Community Dashboard Framework.

Module 18 : The Pentaho Metadata Layer

Topics :  A brief discussion and demonstration of the MetaData Editor and the Ad-Hoc Reporting Wizard.

Exam & Certification

0

Course Review

(4.8)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Module 1 :  Pentaho Platform Concepts

Topics : Discusses the concepts of Business Intelligence and architecture of the Pentaho BI platform. A brief demonstration and discussion of the different BI tools, and when to use each.2

Module 2 :  Installation of the Pentaho BI Suite

Topics : Provides experience installing the Pentaho BI Suite including adding a Data Source to the Enterprise console.

Module 3 :  Analysis Solutions Overview

Topics : Presents an overview of the concepts and typical architecture of analysis solutions, including star schemas, fact tables and dimensions.

Module 4 :  Dimensional Modeling

Topics :  Describes and provides hands-on experience with dimensional modeling and building star schemas.

Module 5 :  ETL and Pentaho Data Integration Overview

Topics : Explores the concepts and basics of extract, transform, load tools and Pentaho Data Integration. Using the Database Explorer, the automatic creation of SQL to create or alter a relational table. Using the Copy Table Wizard to easily create a new table and load it with data.

Module 6 :  Pentaho Data Integration

Topics : Provides hands on experience with the techniques to pull data from a data source (flatfile, relational table, excel files, etc) and move the data to another source. Labs will load relational from the source OLTP schema to a Star Schema.

Module 7 :  Look-ups and Field Transformations

Topics : Provides experience with the techniques for performing look-ups, joining various sources of data, and transforming individual fields during transformations.

Module 8 : Set and Pivot Transformations

Topics : Builds on the Look-ups and Field Transformations module by exploring for sorting and manipulating sets of data.

Module 9 : Jobs and Transformations

Topics : Explores techniques for arranging transformations into jobs including the scheduling of jobs. Steps discussed include, FTP, SFTP, file creation, waiting for a file, sending email at the success of a job and others.

Module 10 : Pentaho Analysis

Topics : Introduces the tools, concepts, and architecture of Pentaho Analysis. Students create a Mondrian cube against the star schema created on Day 2, then drill and pivot the data using the Pentaho Analysis Tools.

Module 11 :  Schema Workbench

Topics :  Students will learn how to use Schema Workbench to create a basic Analysis cube containing Measures, Dimensions and Hierarchies’.

Module 12 :  Advanced Concepts

Topics :  The importance of Time Dimensions, Calculated Measures, Higher Level Calculations and a brief introduction to the power of MDX.

Module 13 :  Introduction to the Reporting Concepts

Topics : Introduction of the Report Designer to produce high fidelity reports, including SubReport, Charts, Parameter Screens, Calculations and Expressions.

Module 14 : Report Wizard

Topics : Explores techniques for creating and publishing a report using the Report Wizard, and using the Query Designer to visually create the SQL for the report.

Module 15 : Report Designer

Topics :  Provides hands on experience with connecting to a Dataset, Design Elements, and the use of Hyperlinks to drill from one report to another, Charts, Groupings, andSubBands.

Module 16 : Parameterized Reports

Topics :  Use Expressions to add styles to your report like Traffic Lights and the conditional display of objects, creating report parameter screens, Report Functions for creating row and summary calculations, Sub Reports, and creating a report that display multiple report objects for a “Dashboard Feel”.

Module 17 : Dashboard Designer

 Topics : Detailed demonstration and lab using the new Dashboard Designer. A discussion of the Community Dashboard Framework.

Module 18 : The Pentaho Metadata Layer

Topics :  A brief discussion and demonstration of the MetaData Editor and the Ad-Hoc Reporting Wizard.

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry