![Pentaho Pentaho Software Tool](https://cdn.selecthub.com/products/d827f12e35eae370ba9c65b7f6026695-e902b80898b9b336eb0f574301475ce1/resources/normal/logo.png?1693316739)
Pentaho
by Pentaho Corporation | Founded 2004, Orlando, FL
Categories:
What is Pentaho?
Industry Specialties: Serves all industries
Pentaho Business Analytics helps users gain insights to drive decisions and manage their data. Notable features include data visualization, dashboards, data modeling, reporting, role-based security, mobile access and a host of analytics capabilities.
It serves customers of any size in all industries and can be delivered in the cloud or as an embedded implementation. It’s built on open-source principles to leverage existing data against future data and has enough to offer users of any skill level.
PRICE
$
$
$
$
$
COMPANY SIZE
DEPLOYMENT
PLATFORM
Try Before You Buy.
Request a Free Demo Today!
Request Demo
It's completely free!
Product Screenshots and Videos
Pentaho Pricing
Based on our most recent analysis, Pentaho pricing and cost details are described here:
- Price
- $$$$$
- Starting From
- Still gathering data
- Pricing Model
- Still gathering data
- Free Trial
- Still gathering data
Pentaho Benefits and Insights
Why use Pentaho?
Key differentiators & advantages of Pentaho
- High-Level Overviews: Track KPI progress, capitalize on wins or improve upon stagnant growth.
- Enhanced Productivity: A code-free design produces a 15x boost in productivity. Execution of Spark or Hadoop jobs in clusters leads to high-performance output.
- Big Data Analytics: Integrate with Hadoop and Spark to ensure big data aggregation, preparation and integration, interactive visualization, analysis, and prediction. Blend multiple sources and process data at scale in a visual design environment.
- Efficient Data Management: Improve pipeline management for structured and unstructured data using flow orchestration, managed from a single console. Data engineers and analysts can perform automated data integration tasks for onboarding and data prep using templates.
- Predictive Analytics: Monitor, evaluate, compare and rebuild predictive models to perform predictive analysis using machine learning algorithms. Maximize model accuracy while in production and choose from a broad selection of evaluation statistics to identify degraded models. Analyze model performance and uncover inadequacies using rich visualizations.
- Community-Driven Tools: Use external components or plugins to extend standard functions. Installed on top of the platform, the plugins aid customizations.
- Metadata Editor: Automate data ingestion and onboarding, and cleanse and blend to create analytics-ready data models.
- Embedded Analytics: Embed real-time reports and dashboards into existing applications, web-based user interfaces and web APIs. Leverage multiple options to embed the application into clients’ systems. Supports multi-tenant deployment with single sign-on and security integration.
- Multi-Cloud Support: Deploy in a multi, hybrid or private cloud environment, with a single tool to simplify architecture management. Ensures connectivity to cloud storage and computing in AWS, Google Cloud and Microsoft Azure. Supports bulk loading of cloud data warehouses, including Amazon Redshift, Snowflake and Google BigQuery.
- Streaming Analytics: Get constant statistical analysis from data streams, collected from sources such as log files, social media, IoT platforms, telemetry and more. Manage, monitor and record real-time analytics of live streaming data to quickly extract the necessary information.
Industry Expertise
Serves marketing, finance, manufacturing and more since 2004.
Pentaho Reviews
Average customer reviews & user sentiment summary for Pentaho:
Synopsis of User Ratings and Reviews
Based on an aggregate of Pentaho reviews taken from the sources above, the following pros & cons have been curated by a SelectHub Market Analyst.
Pros
Cons
Researcher's Summary:
Pentaho Business Analytics helps businesses of any size in any industry achieve end-to-end data analysis. It can be delivered in the cloud or as an embedded implementation. Its user-friendly ETL tool is highly regarded by users, as is the ability to aggregate and manipulate data. Most reviewers feel it’s a complete BI platform, with strong integration and reporting. However, it suffers from certain glitches and its help resources need to be more useful for users to get the most out of the system. In summary, it has a lot to offer for organizations looking for a wealth of data analysis features. For those on a tight budget, there’s also a less robust free version.
Key Features
- Data Visualizations: Includes built-in tools and panel configurations. In-memory data caching aids speed-of-thought analysis on large data volumes. Understand and exclude outliers and drill down into supporting reports using visual lasso filtering and zooming.
- Data Source: Build interactive analysis reports by using data from CSV files as well as relational and multidimensional data models.
- Data Integration: Flexible data ingestion ensures no limitation in terms of data type or source that’s accessible. Provides Extract, Transform, and Load (ETL) capabilities to capture, cleanse and store data using a uniform and consistent format.
- Reporting: View interactive reports in dashboards, with different capabilities such as column resizing and sorting, drag-and-drop report design, font selection, unlimited undo and redo functionality, and more. Export formats include HTML, PDF, CSV, Excel and Excel 93-2003.
- OLAP Analytics: Mondrian, an open-source business analytics engine, enables interactive data analysis in real time. Build business intelligence solutions as an Online Analytical Processing (OLAP) engine, enabling multidimensional queries against business data using the MDX query language.
- Data Modeling: Maps the physical structure of the database into a logical business model and Streamlined Data Refinery (SDR) using a relational data model. Helps augment and blend raw data through a request form to then be published.
- Data Transformation: Design transformations and jobs to run with a graphical user interface, executed in XML or in a database repository. A data transformation engine reads, writes and manipulates data to and from various sources.
- Role-Based Security: Restricts access to certain portions of a metadata model that are used as a data source. Offers table, column and row-level authorization control.
- Mobility: Get immediate access to business analysis at any time using a mobile app for iPad that uses touch navigation technology.
- Big Data Sources: Supports more than 15 big data sources such as Microsoft, Google Cloud, Apache Hive, MAPR and more.
- Data Model Integration: Integrate third-party models like R, Python, Scala with Spark MLlib and Weka into data flows.
- Integrations with Data Processing Distributions: Integrates Hadoop (and its distributions), NoSQL stores, log files, and JSON and XML data formats.
- Customization: A highly-customizable, web-based UI and its API integrations ensure complete control over look, feel and function.
- Tailored Training: Access architect-level staff with a proven track record of success with hundreds of customers.
Limitations
These limitations, based on user feedback, are accurate at the time of this review:
- Unclear error codes. Detailed explanations needed for quick resolution.
- Scheduling ETL packages through the Windows Task Scheduler is difficult.
- Database connection information times out after a certain period of time.
Suite Support
Three tiers of support available: Standard, Premium and Enterprise.
mail_outlineEmail: Not listed.
phonePhone: Enterprise support offers customized, one-on-one single point phone support. Support agents can create a virtual replica of a business analytics environment for better troubleshooting.
schoolTraining: Free and paid options available, as well as a certification program. Along with in-person and digital training, a robust library of user docs, forum answers, video tutorials and much more are available.
local_offerTickets:Submit through the support portal. Turnaround times depend on support tier.