COURSES UPDATE:
NEW JOB ORIENTED CAREER COURSES STARTING FROM 10th Aug 2019. ANY GRADUATE CAN DO THIS. GRAB THIS OPPORTUINITY NOW. WE WILL GIVE GUARANTEE OF YOUR JOB. | OTHER WEEKEND BATCH SCHEDULES |  HADOOP  (02:00:PM)  |    APPIUM And REST ASSURED  (05:00:PM)  |  AWS AND DEVOPS  (05:00:PM)  |  ADVANCED SELENIUM, JAVA AND DEVOPS PIPELINE  (04:00:PM)  |  ANGULAR 6  (10:00:AM)  |   LINUX SHELL SCRIPTING / ADMIN  (11:00:AM)  |  More Information Click Here..  
+91 7588262721 / 9665875790 / 9923488942 info@orilent.com / orilenttap@gmail.com


Lesson 1: Introduction to Pentaho Tool
o    Oveview of Pentaho Business Intelligence and Analytics tools
o     database dimensional modelling
o     using Star Schema for querying large data sets
o    understanding fact tables and dimensions tables
o    Snowflake Schema
o    , principles of Slowly Changing Dimensions.     

Lesson 2 Clustering in Pentaho
o    Understanding the basics of clustering in Pentaho Data Integration
o     creating a database connection
o     moving a CSV file input to table output and Microsoft Excel output
o    moving from Excel to data grid and log. 

Lesson 3: Data Transformation
o    The Pentaho Data Integration Transformation steps, adding sequence
o     understanding calculator
o     Penthao number range
o    string replace
o     selecting field value
o     sorting and splitting rows
o     string operation
o    unique row and value mapper.     

Lesson 4: Pentaho Flow
o     Working with secure socket command
o     Pentaho null value and error handling
o    Pentaho mail
o    row filter and priorities stream.

Lesson 5:  Deploying SCD
o    Understanding Slowly Changing Dimensions, making ETL dynamic
o     dynamic transformation
o     creating folders, scripting
o     bulk loading, file management
o    , working with Pentaho file transfer
o    Repository, XML
o     Utility and File encryption.     

Lesson 6: Type of Repository in Pentaho
o     Creating dynamic ETL
o     passing variable and value from job to transformation
o     deploying parameter with transformation
o     importance of Repository in Pentaho
o    database connection
o     environmental variable and repository import.

Lesson 7: Pentaho Repository & Report Designing
o    Working with Pentaho dashboard and Report
o     effect of row bending, designing a report
o     working with Pentaho Server
o    creation of line
o     bar and pie chart in Pentaho.

Lesson 8: Pentaho Dashboard
o    Working with Pentaho Dashboard
o    passing parameters in Report and Dashboard
o     drill-down of Report
o     deploying Cubes for report creation
o     working with Excel sheet
o    Pentaho data integration for report creation.

Lesson 9: Understanding Cube and Multi Dimensional Expression
o    What is a Cube? Creation and benefit of Cube, working with Cube, Report and Dashboard creation with Cube.
o    Understanding the basics of Multi Dimensional Expression (MDX)
o     basics of MDX
o    understanding Tuple
o     its implicit dimensions
o     MDX sets
o    Level
o    Members
o     dimensions referencing
o    hierarchical navigation, and meta data.    

Lesson 10: Pentaho Analyzer
o    Pentaho analytics for discovering
o    blending various data types and sizes
o    including advanced analytics for visualizing data across multiple dimensions.

Lesson 11: Hadoop ETL Connectivity
o    Deploying ETL capabilities for working on the Hadoop ecosystem
o    integrating with HDFS and moving data from local file to distributed file system
o     deploying Apache Hive, designing MapReduce jobs
o    complete Hadoop integration with ETL tool.    

Lesson 12: Creating dashboards in Pentaho
o    Creating interactive dashboards for visualizing highly graphical representation of data for improving key business performance.