fbpx

PENTAHO TRAINING

Pentaho training class by Mildaintrainings helps you learn Pentaho BI suite which covers Pentaho Data Integration, Pentaho Report Designer, Pentaho Mondrian Cubes and Dashboards. This Pentaho Online course you will help you prepare for Pentaho Data Integration Exam and you will work on real-life project work.

4 Days / 32 Hrs

For Classroom & Online Training

+91-8447121833
info@mildaintrainings.com

pentaho training  Reviews 

QUICK ENQUIRY

 

MODE OF TRAININGS

ONLINE CLASSROOM

Instructor-Led Training

Live Online Classroom

ONE TO ONE

Instructor-Led Training

Live Online Classroom

TEAM / CORPORATE

Train Your Team

And Up-Skill Them

DESCRIPTION

About the Penthao Course

This Mildaintrainings Pentaho Business Intelligence Training Course equips you with the knowledge of Business Intelligence and Data warehousing concepts with along with in-depth coverage of Pentaho Data Integration (aka Kettle), Pentaho Reporting, Dashboards, and Mondrian Cubes. Pentaho is an open source comprehensive BI suite and provides integration with Hadoop Distribution for handling large dataset and doing reporting on top of it. This training will also equip you to integrate Pentaho BI suite with Hadoop. 

What you will learn in this Pentaho online certification Training?

After completing this course, you will be able to:

  • Learn architecture of Pentaho BI Suite
  • Get trained in Pentaho Analytics for creating reports using Pentaho BI Server
  • Perform multiple data integration, transformation, and analytics
  • Pentaho Dashboard & Pentaho Business Analytics
  • Use PDI and ETL design pattern to populate data warehouse star schema
  • Create complex reports and dashboard for analysis
  • Develop Mondrian Cube OLAP schemas with Pentaho workbench
  • Integrate Pentaho with Big Data Stack like HDFS, Map Reduce
  • Learn how to performance tune PDI jobs and transformations
  • Use Pentaho Kettle to build and deploy the report in an automated manner

Who should take this Pentaho training Course?

  • Business Analyst, BI developer, Data Scientist, DW programmer, Solution Architect
  • Mainframe and Testing Professionals
  • Those who want to take up a career in Business Intelligence & Data Analytics

What are the prerequisites for learning Pentaho?

No prior knowledge is required to Pentaho BI suite.

Why should you go for Pentaho Online Training?

  • Poor data quality costs US businesses up to $600 billion annually – TDWI
  • Big Data Analytics to reach $13.95 Billion by 2017 – Markets and Markets
  • Average US Salary for a Pentaho Professional is $104,000 – indeed.com

CURRICULUM

 

CURRICULUM

 

Introduction to Pentaho Tool

Pentaho user console, Overview of Pentaho Business Intelligence and Analytics tools, database dimensional modelling, using Star Schema for querying large data sets, understanding fact tables and dimensions tables, Snowflake Schema, principles of Slowly Changing Dimensions, knowledge of how high availability is supported for the DI server and BA server, managing Pentaho artifacts Knowledge of big data solution architectures.

Hands-on Exercise – Schedule a report using user console, Create model using database dimensional modeling techniques, create a Star Schema for querying large data sets, Use fact tables and dimensions tables, manage Pentaho artifacts

Data Architecture

Designing data models for reporting, Pentaho support for predictive analytics, Design a Streamlined Data Refinery (SDR) solution for a client

Hands-on Exercise – Design data models for reporting, Perform predictive analytics on a data set, design a Streamlined Data Refinery (SDR) solution for a dummy client

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, moving from Excel to data grid and log.

Hands-on Exercise – Create a database connection, move a csv file input to table output and Microsoft excel output, move data from excel to data grid and log

Data Transformation

The Pentaho Data Integration Transformation steps, adding sequence, understanding calculator, Pentaho number range, string replace, selecting field value, sorting and splitting rows, string operation, unique row and value mapper, Usage of metadata injection

Hands-on Exercise – Practice various steps to perform data integration transformation, add sequence, use calculator, work on number range, selecting field value, sorting and splitting rows, string operation, unique row, and value mapper, use metadata injection.

Pentaho Flow

Working with secure socket command, Pentaho null value and error handling, Pentaho mail, row filter and priorities stream.

Hands-on Exercise – Work with secure socket command, Handle null values in the data, perform error handling, send email, get row filtered data, set stream priorities

Deploying SCD

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

Hands-on Exercise – Make ETL dynamic transformation, create folders, write scripts, load bulk data, perform file management ops, work with Pentaho file transfer, XML utility and File encryption

Talend Job Creation

Learning to create a Talend Job, working with Delimited file, working with Meta Data, schema for data integration, understanding Propagation, deploying of tFilterRow and string filter for creating Jobs, creation of CSV file.

Type of Repository in Pentaho

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

Hands-on Exercise – Create dynamic ETL, pass variable and value from job to transformation, deploy parameter with transformation, connect to a database, set pentaho environmental variables, import a repository in the pentaho workspace

Pentaho Repository & Report Designing

Working with Pentaho dashboard and Report, effect of row bending, designing a report, working with Pentaho Server, creation of line, bar and pie chart in Pentaho, How to achieve localization in reports

Hands-on Exercise – Create Pentaho dashboard and report, check effect of row bending, design a report, work with Pentaho Server, create line, bar and pie chart in Pentaho, Implement localization in a report

Pentaho Dashboard

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

Hands-on Exercise – Pass parameters in Report and Dashboard, deploy Cubes for report creation, drill-down in report to understand the entries, import data from an excel sheet, Perform data integration for report creation

Understanding Cube

What is a Cube? Creation and benefit of Cube, working with Cube, Report and Dashboard creation with Cube.

Hands-on Exercise – Create a Cube, create report and dashboard with Cube

Multi Dimensional Expression

Understanding the basics of Multi-Dimensional Expression (MDX), basics of MDX, understanding Tuple, its implicit dimensions, MDX sets, level, members, dimensions referencing, hierarchical navigation, and metadata.

Hands-on Exercise – Work with MDX, Use MDX sets, level, members, dimensions referencing, hierarchical navigation, and metadata

Pentaho Analyzer

Pentaho analytics for discovering, blending various data types and sizes, including advanced analytics for visualizing data across multiple dimensions, extending Analyzer functionality, embedding BA server reports, Pentaho REST APIs

Hands-on Exercise – Blend various data types and sizes, Perform advanced analytics for visualizing data across multiple dimensions, Embed BA server report

Pentaho Data Integration (PDI) Development

Knowledge of the PDI steps used to create an ETL job, Describing the PDI steps to create an ETL transformation, Describing the use of property files

Hands-on Exercise – Create an ETL transformation using PDI steps, Use property files

Hadoop ETL Connectivity

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

Hands-on Exercise – Deploy ETL capabilities for working on the Hadoop ecosystem, Integrate with HDFS and move data from local file to distributed file system, deploy Apache Hive, design MapReduce jobs

Creating dashboards in Pentaho

Creating interactive dashboards for visualizing highly graphical representation of data for improving key business performance.

Hands-on Exercise – Create interactive dashboards for visualizing graphical representation of data

Performance Tuning

Managing BA server logging, tuning Pentaho reports, monitoring the performance of a job or a transformation, Auditing in Pentaho

Hands-on Exercise – Manage logging in BA server, Fine tune Pentaho report, Monitor the performance of an ETL job

Security

Integrating user security with other enterprise systems, Extending BA server content security, Securing data, Pentaho’s support for multi-tenancy, Using Kerberos with Pentaho

Hands-on Exercise – Configure security settings to implement high level security.

Certified Master Data Science Course

Online/Classroom

From December 27, 2018 09:00 until January 4 2019 18:00

  • At:: Albany,NY | Albuquerque,NM | Allentown,PA | Austin,TX | Boise,ID | Boston,MA | Cary,NC | Cary,NC |
  • Categories: Master Data Science Course
  • Tags: Classroom Training, Duration 7 Days
  • View Details and Book

 

FAQ | Penthao Training

 

Why should I take coaching from Mildaintrainings?

One must take Talend training from Mildaintrainings because our trainers are having more than 10 years of industry practical training experience & also we at Mildain Training providing six (6) months technical support and try to solve all the quarries.

 

Who will provide the certificate?

 

At Mildain Training you will be provided participation certificate after completion of blue prism course from Mildain Training.

 

 

When the classes be held?

Classes will hold in weekend & weekdays accordingly.

 

 

What if I miss the class?

If one misses the class in that case you can take backup classes by adjusting in the next live session.

 

 

What is the course duration?

Talend Training course at Mildain Training will be forty (32) hrs. Or 4 days.

 

Why Learn python From MildainTrainings

Python Course Online Training Python is an explained, object-oriented, high-level programming language with lively semantics. Its irregular state worked in data structures, joined with dynamic creating and dynamic definitive; make it amazingly engaging for Rapid...

Azure Tutorial

 Azure Tutorial: In this blog, we will learn about Microsoft Azure in the following sequence: What is Cloud Computing? Azure Job Trends What is Microsoft Azure? Azure Management Portal Azure Services Azure Pricing Azure Certifications Azure Demo: Launching Ubuntu...

GET IN TOUCH

13 + 5 =

+91-8447121833

 

Mildain Solutions

Plot no 17 C-Block,Sec 36, Noida 201301(UP)

 

GET IN TOUCH

Corporate
close slider

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Company

No Of Participant

Query