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 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.