Learn Pentaho Certification Course
Sun, Jan 07, 2018, 08:00 AM - Fri, Jan 31, 2020, 10:00 AM
Pentaho is a powerful BI suite. It has all of tools needed to a complete Business Intelligence procces: since ETL to a visualization dashboard layer.
In general, the most famous tool is called PDI (Pentaho Data Integration). However, Pentaho is more than that. There are also: Mondrian, Report Design, BI Server, etc
Open, embeddable and extensible, Pentaho is architected to ensure that each role -- from developers to business users -- can easily translate data into value. The platform is a great fit for the following use cases:
Data Integration: Easily access, manage and blend any data from any source
Big Data: Accelerate the time to big data value with an open, integrated solution to drive value from Hadoop, NoSQL, and other stores
Business Analytics: Turn data into insights and make information-driven decisions
Embedded Analytics: Seamlessly embed flexible analytics into your applications to drive data monetization and competitive advantage
We can sort rows and then apply “unique rows” to get duplicate fields while handling huge data.
For a beginner level extraction and data manipulation, it serves the basic platform.
It has an added advantage for “Salesforce upsert” which we generally use while working on production org as well as developers org.
The errors we do face sometimes are quite tough for correction of transformation steps.
The Pentaho community is not very active, so sometimes we just have to figure out ways to tackle our issue by hit and trial techniques.
It freezes sometimes while working on huge excel files, but that is certainly our processors’ fault.