Pentaho BI Training

 >>  Pentaho BI Training

Pentaho BI Training


 (4.9) | 750 Ratings


Introduction


Pentaho BI Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Introduction to Pentaho Tool & Introduction to Pentaho BI Suite

  • Business Intelligence and Data Warehousing Introduction
  • Pentaho Introduction
  • Dashboard Content Linking
  • Data-less Design Mode for Analyzer Reports
  • Simplified Hadoop MapReduce Job Design
  • Features of Pentaho version 8.0 -
  • Improve connectivity to streaming data sources
  • Optimize processing resources
  • Boost Team Productivity, etc..

Business Analytics User Console

  • Pentaho Business Analytics
  • Introducing Pentaho Business Analytics
  • Navigating the User Console
  • Creating Reports With Interactive Reports
  • Creating Analysis Reports With Analyzer
  • Craeting Pentaho Dashboards

Petanho Business Analytics Report Designer

  • Introducing Pentaho Business Analytics
  • Connecting to a Data Source and Writing a Query
  • Adding Data Elements and Creating Report Groups
  • Create Group and Report Totals
  • Formatting the Report & Applying Conditional Formatting
  • Adding Report Parameters
  • Creating Hyperlinks
  • Creating Charts and Sub-Reports

Business Analytics Report Designer - Advanced Reporting Topics

  • Working with Charts in Report Designer
  • Creating Report Templates
  • Using the Report Wizard
  • Create a Drillable Chart

Business Analytics Data Modeling

  • Working with Data Sources in Pentaho
  • How to Use Metadata Editor & Metadata Concepts
  • Metadata Editor's Query Editor
  • Introduction to OLAP and ROLAP
  • Dimensional Modeling: Cubes and Stars
  • Introduction to Mondrian
  • Introduction to Schema Workbench
  • How to Access Control with Schema Workbench
  • CTools Fundamentals

 CTools Advanced Cocepts

  • Review the Dashboard Design Process
  • Advanced Layout Concepts
  • CDF Lifecycle and Components Lifecycle
  • Add the Technology and Year Parameter Components
  • Developer Tools
  • Custom Add-ins
  • Map Components
  • Template Components
  • Role-based Dashboard Behavior
  • Embedding Dashboards in an HTML Page

Pentaho Data Integration Fundamentals

  • Introduction
  • Objectives & Class Logistics
  • Learning the PDI User Interface
  • Introduction to Repositories
  • Working with Pentaho dashboard and Report
  • Working with Pentaho Server
  • How to achieve localization in reports
  • Serializing Multiple Text Files & De-serialize a File
  • Connecting to & Exploring a Database
  • Data Flows & LookUps
  • Calculating & Aggregating Order Quantity
  • JOB ORCHESTRATION
  • Setting up & Monitoring the Scheduler
  • Explore Data Integration Repository
  • Detailed Logging throughout Execution

Pentaho and Hadoop Framework Fundamentals

  • Overview of Pentaho & BigData
  • Batch Processing Architecture
  • Hadoop Data Ingestion Tools
  • Hadoop ETL Connectivity
  • How to Process Data in Hadoop Using MapReduce
  • MapReduce with Pentaho Data Integration
  • Data Processing in Hadoop Using Carte/ Yarn
  • Pentaho Data Integration (PDI) Development

Predictive Analytics with PDI and Weka

  • Data Mining Concepts
  • Data Preparation with PDI
  • Basics of Predective Modeling
  • Basic Evaluation Metrics
  • Creating Visualizations for Viewing Predictive Results

Clustering in Pentaho

  • Understanding the basics of clustering in Pentaho Data Integration
  • Creating a database connection
  • Moving a CSV file input to table output and Microsoft Excel output
  • M from Excel to data grid and log.

]How to Embed Pentaho

  • What are the embedding approaches
  • How to Craete Pentaho Theme
  • Blending various data types and sizes
  • Integrating Pentaho BA Content (Mashup Embedding) & Extending
  • Unified Embedding

Hands-On Overview of the Processes for iInstalling & Configuring

  • Pentaho Architectural Overview
  • How to Install the Pentaho BI Suite
  • Introducing the Pentaho User Console and Analysis Tools
  • Installing JDBC Drivers
  • KETTLE_HOME & KETTLE.PROPERTIES
  • Deploying SCD
  • Understanding Cube & Deploying Cubes for report creation
  • Working with Excel sheet
  • Pentaho data integration for report creation.
  • Configuring Pentaho Security
  • Configuring the Java Virtual Machine

Support and Troubleshooting

  • Basic Troubleshooting Review
  • Logging Best Practices
  • Performance Tuning PDF
  • Cocnepts of JVM
  • Upgrading to latest Version of Pentaho

 Practice Test & Interview Questions

Pentaho BI project

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Introduction to Pentaho Tool & Introduction to Pentaho BI Suite

  • Business Intelligence and Data Warehousing Introduction
  • Pentaho Introduction
  • Dashboard Content Linking
  • Data-less Design Mode for Analyzer Reports
  • Simplified Hadoop MapReduce Job Design
  • Features of Pentaho version 8.0 -
  • Improve connectivity to streaming data sources
  • Optimize processing resources
  • Boost Team Productivity, etc..

Business Analytics User Console

  • Pentaho Business Analytics
  • Introducing Pentaho Business Analytics
  • Navigating the User Console
  • Creating Reports With Interactive Reports
  • Creating Analysis Reports With Analyzer
  • Craeting Pentaho Dashboards

Petanho Business Analytics Report Designer

  • Introducing Pentaho Business Analytics
  • Connecting to a Data Source and Writing a Query
  • Adding Data Elements and Creating Report Groups
  • Create Group and Report Totals
  • Formatting the Report & Applying Conditional Formatting
  • Adding Report Parameters
  • Creating Hyperlinks
  • Creating Charts and Sub-Reports

Business Analytics Report Designer - Advanced Reporting Topics

  • Working with Charts in Report Designer
  • Creating Report Templates
  • Using the Report Wizard
  • Create a Drillable Chart

Business Analytics Data Modeling

  • Working with Data Sources in Pentaho
  • How to Use Metadata Editor & Metadata Concepts
  • Metadata Editor's Query Editor
  • Introduction to OLAP and ROLAP
  • Dimensional Modeling: Cubes and Stars
  • Introduction to Mondrian
  • Introduction to Schema Workbench
  • How to Access Control with Schema Workbench
  • CTools Fundamentals

 CTools Advanced Cocepts

  • Review the Dashboard Design Process
  • Advanced Layout Concepts
  • CDF Lifecycle and Components Lifecycle
  • Add the Technology and Year Parameter Components
  • Developer Tools
  • Custom Add-ins
  • Map Components
  • Template Components
  • Role-based Dashboard Behavior
  • Embedding Dashboards in an HTML Page

Pentaho Data Integration Fundamentals

  • Introduction
  • Objectives & Class Logistics
  • Learning the PDI User Interface
  • Introduction to Repositories
  • Working with Pentaho dashboard and Report
  • Working with Pentaho Server
  • How to achieve localization in reports
  • Serializing Multiple Text Files & De-serialize a File
  • Connecting to & Exploring a Database
  • Data Flows & LookUps
  • Calculating & Aggregating Order Quantity
  • JOB ORCHESTRATION
  • Setting up & Monitoring the Scheduler
  • Explore Data Integration Repository
  • Detailed Logging throughout Execution

Pentaho and Hadoop Framework Fundamentals

  • Overview of Pentaho & BigData
  • Batch Processing Architecture
  • Hadoop Data Ingestion Tools
  • Hadoop ETL Connectivity
  • How to Process Data in Hadoop Using MapReduce
  • MapReduce with Pentaho Data Integration
  • Data Processing in Hadoop Using Carte/ Yarn
  • Pentaho Data Integration (PDI) Development

Predictive Analytics with PDI and Weka

  • Data Mining Concepts
  • Data Preparation with PDI
  • Basics of Predective Modeling
  • Basic Evaluation Metrics
  • Creating Visualizations for Viewing Predictive Results

Clustering in Pentaho

  • Understanding the basics of clustering in Pentaho Data Integration
  • Creating a database connection
  • Moving a CSV file input to table output and Microsoft Excel output
  • M from Excel to data grid and log.

]How to Embed Pentaho

  • What are the embedding approaches
  • How to Craete Pentaho Theme
  • Blending various data types and sizes
  • Integrating Pentaho BA Content (Mashup Embedding) & Extending
  • Unified Embedding

Hands-On Overview of the Processes for iInstalling & Configuring

  • Pentaho Architectural Overview
  • How to Install the Pentaho BI Suite
  • Introducing the Pentaho User Console and Analysis Tools
  • Installing JDBC Drivers
  • KETTLE_HOME & KETTLE.PROPERTIES
  • Deploying SCD
  • Understanding Cube & Deploying Cubes for report creation
  • Working with Excel sheet
  • Pentaho data integration for report creation.
  • Configuring Pentaho Security
  • Configuring the Java Virtual Machine

Support and Troubleshooting

  • Basic Troubleshooting Review
  • Logging Best Practices
  • Performance Tuning PDF
  • Cocnepts of JVM
  • Upgrading to latest Version of Pentaho

 Practice Test & Interview Questions

Pentaho BI project

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry