Pentaho Training

  • (4.8)
  • 1680 Ratings
  • Learners : 1705
Try Live Demo

Trusted By Companies Worldwide & 3,50,850+ Learners

Pentaho Course Overview

By taking Pentaho training from Tekslate, you”ll gain exposure on the Pentaho Data Integration. You”ll Learn how to deliver data to various applications through out-of-the-box data standardization method. This course covers in-depth concepts in Pentaho data integration such as Pentaho Mondrian cubes, reporting, and dashboards. enrichment, and quality capabilities. You will get hands-on experience in Pentaho by working on various real-time applications.
Course Duration 30 hrs
Live Projects 2
Next Batch 28 Nov, 2019
01 Dec, 2019
05 Dec, 2019

Pentaho Course Curriculum

Business Intelligence and Data Warehousing Introduction
Pentaho Introduction
Dashboard Content Linking
Data-less Design Mode for Analyzer Reports
Simplified Hadoop MapReduce Job Design
Importance of repository and its usage
3 Types of repositories and their specific usage
Use of various transformation steps
Flow controls available in PDI
Passing and retrieving data to/from the transformations
Dealing with Variables
How to create variables and how to use them in transformations
Creating and using parameters

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

 

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
Create a report using Pentaho OLAP Cube
Use of formula
Parameter Creation
Publish the Reports to BI Server
User Level Security

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

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

 

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

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

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

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

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 the data grid and log.

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

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

Basic Troubleshooting Review
Logging Best Practices
Performance Tuning PDF
Concepts of JVM
Upgrading to latest version of Pentaho

Introduction to Pentaho BI Server and Pentaho Enterprise Server
Create a DATASOURCE at BI Serer
Create a Simple Pentaho Dashboard using Pentaho Dashboard Designer.
Create a drill down dashboard
Best Practices

Tekslate offers advanced Pentaho BI interview questions and answers along with Pentaho BI resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.

For Individuals
For Corporates

Pentaho Upcoming Batches

  • Weekday

    5 Dec - 04 Jan

    7:00 AM IST
  • Weekend

    8 Dec - 07 Jan

    7:00 AM IST
  • Weekday

    12 Dec - 11 Jan

    7:00 AM IST
  • Weekend

    15 Dec - 14 Jan

    7:00 AM IST
  • Weekday

    17 Dec - 16 Jan

    7:00 AM IST
  • Weekend

    21 Dec - 20 Jan

    12:00 AM IST
  • Schedules Doesn't Suit You ?

    Our Team can set up a batch at your convinient time.

    Let us know

    Pentaho Course Objectives

    By the end of the Pentaho training, you will be able to:

    • Understand the architecture of the Pentaho BI suite.
    • Learn Pentaho analytics for creating reports using Pentaho BI Server.

    • Perform multiple data integration, transformation, and analytics.

    • Gain knowledge of Pentaho dashboard and business analytics.

    • Use PDI and ETL design patterns to populate data warehouse star schema.

    • Create complex reports and dashboard for analysis.

     

    • There are huge employment opportunities for certified Pentaho BI around the globe
    • Top multinational companies are hiring certified Pentaho professionals worldwide
    • The average salary of a certified Pentaho professional is around $104,000 USD per annum.

    • Business analysts

    • BI developers

    • Data scientists

    • Data Warehousing programmers

    • Solution architects

    • Aspirants who are willing to build their career in the administrative field.

    There are no prerequisites for learning Pentaho course. The following job roles will get benefited by taking up this course:

    • Data analysts

    • Data Warehouse developers

    • Architects

    The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

    Have More Questions

    Contact us

    Pentaho Course FAQ's

    Have questions? We’ve got the answers. Get the details on how you can grow in this course.

    Our trainers are well experienced professionals and certified in working with front-end development technologies.

    We will record all the Live sessions you go through, and we will send the recording of the class you missed.

    For practical execution, our trainer will provide server access to the student. 

    All our training classes are live. This is to solve all the student queries directly with the trainer.

    Live online training means, our trainer will be in online with you to solve your issues.
    Pre-recorded training means, there will be no trainer available to solve your issues.

    You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.

    Yes, you can access the course material after completing course by the recorded training videos we shared with you during training.

    To avail all discounts offered by Tekslate, you need to visit the website regularly. However, there will be a group discount for 2 or more participants.

    Yes, you will get your refund by cancelling some administration fee from the course. But, you should cancel your enrolment within 48 hours of registration, and then the refund will be retained within 30 days of a request.

    Have More Questions. Reach our Support Team

    Contact us

    Join a Free Pentaho Demo Session

    See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

    Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Pentaho

    By providing us with your details, We wont spam your inbox.