Pentaho Training in OMR Chennai
We are the best providers of Pentaho Training in Chennai with expert guidance and fully interactive classes. Our training program is very much mixed both practical and interview point of questions.
With powerful data extract, transform and load (ETL) capabilities, an intuitive and rich graphical design environment, and an open and standards-based architecture, Pentaho Data Integration is increasingly the choice over proprietary and homegrown data integration tools.
Course Description
Pentaho® is the open source software for Business Intelligence. It provides end to end business analytics solution with help of interactive information driven visualizations, reports, cubes and data integration techniques. Pentaho Data Integration prepares and blends powerful data that drives actionable insights.
Why Pentaho?
Pentaho helps today’s leading businesses to make faster and better business decisions. So coping ourselves with the growing trends helps to survive for a long term in this competitive IT market. It helps to increase your retension and career opportunities by driving transformation and growth in your organization.
What we do at Greens Technologies for Pentaho?
Our practical instructor led training programmes with career driven syllabus helps young enthusiasts to achieve theire career goals in their respective fields
Who should go for this course?
This course is a foundation to all those enthusiasts who aspires career in Business Intelligence (BI). This course is recommeded for Business Analyst, BI developer, Data Scientist, DW programmer, Solution Architect who could gain mileage out of this course in their respective fields as Pentaho can make them aware of its potential in building a integrated solution.
This course introduces the Pentaho® Business Analytics suite of products to non-technical users who rely on business intelligence solutions to make informed business decisions.
Pentaho Course Overview
Introduction to Pentaho 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
- 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 Joins
- 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 Server
- Create Simple Pentaho Dashboard using Pentaho Dashboard Designer.
- Create a drill down dashboard
- Best Practices.
Course Benefits
- Improve productivity by giving your data integration team the skills they need to succeed with Pentaho Data Integration
- Learn to deliver data to a wide variety of applications using Pentaho’s out-of-the-box data standardization, enrichment and quality capabilities
- Interactive, hands-on training materials significantly improve skill development and maximize retention
Skills Achieved
At the completion of this course, you should be able to:
- Create, preview, and run basic transformations containing steps and hops
- View transformation results in the Step Metrics view and the Log view
- Configure the Pentaho Enterprise Repository, including basic security
- Use the Pentaho Enterprise Repository to: create folders, store transformations and jobs, move, lock, revise, delete, and restore artifacts.
- Configure error handling for transformation steps
- Create a database connection and use Database Explorer to interact with data sources
- Create transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, Add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, JavaScript, Database Lookup, Set Environment Variables
- Learn how to use transformation steps to perform complex calculations on the data stream
- Create reusable transformations using parameterized values and environment variables
- Use Pentaho Data Integration to cleanse and correct data
- Load data from and write data to different data sources
- Create Pentaho Data Integration jobs that: run multiple transformations, use variables, contain sub-jobs, provide built-in error notification, load and process multiple text files, and convert files into Microsoft Excel format
- Configure logging for transformation steps and for job entries and examine the logged data
- Schedule and monitor the execution of a transformation in Pentaho Data Integration and in the Pentaho Enterprise Console
Course Curriculum
Learning Objectives – In this module, you will understand Pentaho’s journey till date and get familiar with their various product offerings.
Topics – About Pentaho, Pentaho BI(CE vs. EE), Pentaho Data Integration(PDI), Pentaho Report Designer(PRD), Pentaho Metadata Editor(PME), Mondrian, Pentaho Schema Workbench(PSW), Dashboard Capabilities
Learning Objectives – In this module, you will design, build and publish custom reports using Pentaho Report Designer.
Topics – PRD Layout, Understanding it’s Basic Features, Designing Basic Report Containing Graphical Chart, Conditional Formatting, Studying the PRPT File Format, Building a Basic Report in PDF Report, Example
Learning Objectives – In this module, you will get acquainted with advance features of reporting and getting hands on with features like sub-report, cross tabs.
Topics – Data Source Connection, Query Designer, Working with Group(Group Header, Group Footer), Passing Parameter, Using Formula, Designing Report with Subreport, API Based Reporting, Example
Learning Objectives – In this module, you will Understand ETL (Data Extract, Transform and Load) and learn PDI features.
Topics – ETL Concepts, PDI GUI Layout, Repository, Supported Data Types for Connectivity, Wizard, Marketplace
Learning Objectives – In this module, you will understand transformation and various steps.
Topics – What is Transformation, Step, Hop, Variable, Various Input Steps, Various Output Steps, Transformation Steps, Big Data Steps, Scripting, Integration with Hadoop HDFS and NOSQL MongoDB, PDI and Map Reduce, Example
Learning Objectives – In this module, you will understand PDI – Job and various entries, file formats for KTR (Kettle Transformation) and KJB (Kettle Job).
Topics – What is PDI-job, Entries, Job Orchestration, Integrating Report, Logging, Understanding Repository, File Based Repository, Database Repository, Example with Job Containing Multiple Entries
Learning Objectives – In this module, you will understand Pentaho BA Server and its administration through user console.
Topics – Getting Started with Pentaho Business Analytics, User Console Navigation, Analysis Tools, Using Data Sources, JPivot, Integrating Report on BI
