Wednesday, 23 November 2016

Pentaho BI Online Training

PENTAHO BI ONLINE TRAINING @ VIVANTA IT LABS

An online course designed to make you an expert in using Pentaho and learn all that is required to work with the customers and learn how to set the environment to deploy actual customer premises to identify solutions.
Pentaho Business Analytics is a suite of open source Business Intelligence hosts content created both in the server itself through plug-ins or files published to the server. It provide data integration, OLAP services, reporting, dashboard, data mining and ETL capabilities. Commercial plug-ins from Pentaho expand out-of-the-box features. It uses an innovative metadata driven approach. It enable Streaming engine architecture, enterprise-class performance and scalability with a broad range of deployment options. Pentaho BI Online Training teaches students to become top level developer in Pentaho, how to work with the customers and learn how to set the environment to deploy actual customer premises to identify solutions.

Pentaho BI Online Training Overview

Vivanta IT Labs is the fastest transpire in Pentaho BI Online Training emphasis on high quality training. The course is delivered in a deep and clear, articulate with complete knowledge on structured information and data integration in a step by step pattern for solid foundation with hands-on. The case study consists of several concepts of Pentaho as per industry requirements customized by real-time working IT Professionals.

Pentaho BI Training Curriculum

Pentaho BI Concepts

  • Introduction to BI and Dimensional Modeling
  • Basic Architecture of Pentaho Introduction 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
  • Three 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 BI 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 BI 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 BI 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

FEEL FREE TO CONTACT US

Your feedback is valuable to us. Please send us your suggestions.

USA OFFICE

INDIA OFFICE

Posted by at No comments:
Subscribe to: Comments (Atom)