COURSE SUMMARY

HIGHLIGHTS OF PENTAHO Online Training AT KEEN TECH

• Covers core understanding about Data Warehouse and Business Intelligence environment with industry’s best rated tools
• Focuses on Pentaho in Live Environment
• Provides thorough insights on Data Integration with Pentaho
• Emphasizes on core features
• Includes exclusive coverage of reports and dashboards
• Offers a practical and industry perspective

CORE BENEFITS OF LEARNING PENTAHO

Pentaho is a suite of product offerings in the area of Business Intelligence, with a key focus on Data Integration, OLAP Analysis, Reporting, Dashboards, and ETL. Pentaho leverages on its power of value based decision making available to it through unlimited sources and volumes of multidimensional data. This feature is aided with visualized reports for predictive analysis and decision making. Pentaho plays a critical role in the analytics space enabling IT companies to understand client-behavior and design as per the service offerings. Pentaho is a very in-demand specialization with a galore of new openings.

Pentaho is a BI Platform, having capabilities of OLAP Analysis, Data Repositories, Transformation Management, Job Scheduling, Reporting, Dashboards, Cubes, PDI, Data Validation, Mapping, Regular Expression. This Online course highlights these features in its curriculum.

COURSE CONTENT :

ELEMENTARY KNOWLEDGE

• Business Intelligence practice in real time
• Dealing with Multidimensional Data
• Architecture, Component, work flow with Schema Functioning
• Data Repositories : Create, define, leverage repositories, guidelines to repository usage, backup and restore repositories
• Transformation Flow : Create, Save and Execute and Step by Step in-out Transformation with flow controls in PDI.
• Job execution for Transformation : Pass and retrieve data, Data Validation, Pre –execute and scheduling new job execution for Transformation, Run and Debug Job, Transformation
• Variable Management in Transformation : process flow for Create and use variables within Transformation
• Parameters : Detailed aspects with types and their usage
• Procedure for Data Validation, Mapping and Generic Expression
• Handle LOG Tables by storing updated Log Information
• Implementation Procedure of SCD and CDC using Kettle

REPORTING

• Create UI & Data Source Connections
• Design Report Template
• Format Reports
• Creating Report with different Data sources connected
• OLAP Cube to create Report
• Charts
• Formulae working mechanism
• Define Parameter
• Conditional Formatting
• Sub-Reports concept and how to use
• distribute the reports to BI server
• Ink-in user level security
• Create Hyperlinked Reports

PENTAHO DASHBOARD

• Working Knowledge of Pentaho Environment with focus on BI Server and Enterprise server side functionality
• Initiate Data source at BI Server
• Dashboard Designer Menu and creating a simple Dashboard
• Work on Drill Down Dashboard
• Industry’s best Practices

PENTAHO CUBES

• BI Server and Enterprise server functionality
• Initiate Data Source at BI Server
• Dashboard designing with simple mechanisms