ibi vs Pentaho

Last Updated:

Our analysts compared ibi vs Pentaho based on data from our 400+ point analysis of Business Analytics Tools, user reviews and our own crowdsourced data from our free software selection platform.

Pentaho Software Tool

Product Basics

Ibi by Information Builders offers cloud-based data and analytics platforms that empower users to turn their information into insights through robust visualization, reporting and data management. WebFOCUS is its primary offering. Flexible, configurable and scalable, it integrates data from many sources, simplifies data workflows and enables fast, easy organization and analysis of data. It allows users to make more confident data-driven decisions that drive business results.

As of 2020, the vendor has announced that it will be acquired by TIBCO.
read more...
Pentaho is a data integration and analytics platform that helps businesses extract, transform, analyze, and visualize data from diverse sources. It caters to organizations navigating growing data volumes and seeking insights for informed decision-making. Users praise Pentaho's open-source, free core version, making it a budget-friendly option for beginners or small teams. Its wide range of tools tackles various data challenges, from basic reporting to advanced analytics. Scalability shines for larger datasets, handling complex processing effectively. Additionally, an active community offers valuable support. However, prepare for a steeper learning curve compared to more user-friendly options. Limited documentation can occasionally leave users struggling. Users report encountering bugs and glitches, potentially requiring technical expertise. Be mindful of resource intensiveness, as large-scale operations might demand powerful hardware. While customization options exist, some users crave more flexibility. Overall, Pentaho offers a powerful, free data platform, with trade-offs between its extensive capabilities and ease of use. Consider its strengths and limitations in the context of your specific needs and technical expertise.

Pros
  • Open-source and free
  • Wide range of tools
  • Scalable for large datasets
  • Active community support
  • Integration with various platforms
Cons
  • Steeper learning curve
  • Limited documentation
  • Occasional bugs and glitches
  • Can be resource-intensive
  • Limited customization options
read more...
$1,500/User, Annually
Get a free price quote
Tailored to your specific needs
$100 Monthly, Freemium
Get a free price quote
Tailored to your specific needs
Small
Medium
Large
Small
Medium
Large
Windows
Mac
Linux
Android
Chromebook
Windows
Mac
Linux
Android
Chromebook
Cloud
On-Premise
Mobile
Cloud
On-Premise
Mobile

Product Assistance

Documentation
In Person
Live Online
Videos
Webinars
Documentation
In Person
Live Online
Videos
Webinars
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support

Product Insights

  • Improve Data Literacy: Make data accessible to all, turning everyone into a decision-maker with a holistic overview of data. View the business as a whole through a comprehensive analytics dashboard, or drill down deeper to examine key components and drivers.
  • Highly Adaptable: Built for businesses of any size, it adapts to a broad range of skill levels, needs and expectations with ease. Choose from various plug-and-play options, which include industry-specific solutions.
  • Innovative Insights: Operationalize artificial intelligence, machine learning, natural language processing and advanced analytics to uncover significant discoveries hidden in enterprise data.
  • Embeddable: Enable teams or customers to efficiently make use of data through analytics embedded directly into their existing applications. 
  • Cloud-Based: Scale flexibly and stay current with updates through an all-in-one secure platform for the cloud.
  • Open Framework: Seamlessly connect to any database, data ecosystem or enterprise data source through the tool’s open, ubiquitous framework.
  • Free Trial: Try the cloud analytics platform for free for 14 days.
read more...
  • 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. 
read more...
  • Data Preparation: Connect to, join, blend and cleanse data through streamlined, automated processes. Improve data through quality indicators, data enrichment, built-in cleansing tools and more.
  • Data Integration: Integrate information from all kinds of data sources — real-time, batch, streaming, big data, social media, mainframes and more. Retrieve structured and unstructured data from multiple sources, including databases, cloud and on-premises applications, files and spreadsheets.
  • Data Management: Easily manage information with out-of-the-box components that give a more complete, holistic perspective of an organization’s data.
  • Data Governance: Instill an organization-wide trust in data that leads to better understanding overall. Establish references and standardize processes with centralized data collaboration, data lineage support and a formalized glossary of accepted terms.
read more...
  • 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. 
read more...

Product Ranking

#21

among all
Business Analytics Tools

#12

among all
Business Analytics Tools

Find out who the leaders are

Analyst Rating Summary

78
we're gathering data
100
we're gathering data
10
we're gathering data
77
we're gathering data
Show More Show More

Analyst Ratings for Functional Requirements Customize This Data Customize This Data

ibi
Pentaho
+ Add Product + Add Product
Advanced Analytics Augmented Analytics Dashboarding And Data Visualization Data Management Data Querying Embedded Analytics Geospatial Visualizations And Analysis Internet Of Things (IoT) Analytics Mobile BI Platform Functions Reporting 100 10 77 100 79 100 86 50 90 100 93 0 25 50 75 100
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
8%
0%
92%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
75%
0%
25%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
78%
0%
22%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
71%
0%
29%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
0%
0%
100%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
88%
0%
12%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
90%
0%
10%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A

Analyst Ratings for Technical Requirements Customize This Data Customize This Data

ibi
Pentaho
+ Add Product + Add Product
Availability & Scalability Data Sources Connectivity Deployment Options Extensibility OS Support Security 75 79 100 100 67 87 0 25 50 75 100
75%
0%
25%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
62%
0%
38%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
67%
0%
33%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
89%
0%
11%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A

User Sentiment Summary

Great User Sentiment 420 reviews
Great User Sentiment 307 reviews
87%
of users recommend this product

ibi has a 'great' User Satisfaction Rating of 87% when considering 420 user reviews from 4 recognized software review sites.

81%
of users recommend this product

Pentaho has a 'great' User Satisfaction Rating of 81% when considering 307 user reviews from 4 recognized software review sites.

4.4 (156)
4.0 (47)
4.5 (170)
4.2 (39)
4.3 (63)
4.0 (100)
3.2 (31)
4.1 (121)

Awards

SelectHub research analysts have evaluated ibi and concluded it earns best-in-class honors for Advanced Analytics and Embedded Analytics.

Advanced Analytics Award
Embedded Analytics Award

No awards.

Synopsis of User Ratings and Reviews

Support: All of the users who mentioned the vendor’s support praised their responsive, helpful support team and dedication to customer success.
Reporting: Around 96% of users who mentioned reporting said that this tool works well for report creation and scheduled distribution.
Data Visualization: About 90% of users who reviewed the tool for data visualization said that it excels in dashboard and chart creation.
Functionality: This is a robust, feature-rich tool with a great degree of flexibility and frequent updates, according to around 76% of users who reviewed the tool’s functionality.
Ease of Use: According to about 63% of users who reviewed the platform’s ease of use, its intuitive drop-and-drop interface simplifies data analysis and visualization.
Show more
Open-source and free core version: Makes Pentaho accessible to individuals and small teams, reducing initial investment costs.
Wide range of tools: Covers various data analysis needs, from basic reporting to advanced analytics, eliminating the need for multiple tools.
Scalable for large datasets: Handles growing data volumes efficiently, ensuring smooth performance for complex analyses.
Active community support: Provides valuable resources and troubleshooting assistance, especially for the open-source version.
Integration with various platforms: Connects seamlessly with existing data sources and BI tools, simplifying data workflows.
Show more
User Interface: Of the users who mentioned this solution’s UI, approximately 87% said that it looks outdated, especially compared to those of competitors.
Cost: About 83% of users who reviewed it for price said that this solution is expensive, especially when considering add-on modules.
Performance: All of the users who reviewed the platform’s performance and speed mentioned bugs, lag and crashes, among other issues.
Learning Curve: It takes some time to learn this platform, according to about 60% of users who reviewed its learning curve.
Show more
Steeper learning curve: Compared to user-friendly options, Pentaho's interface and features might require more technical expertise to master.
Limited documentation: While resources exist, some users find the documentation incomplete or outdated, hindering troubleshooting and advanced usage.
Occasional bugs and glitches: Users report encountering bugs and glitches, especially in the open-source version, potentially impacting data analysis workflows.
Resource-intensive: Large-scale data processing and complex analyses can demand powerful hardware, increasing infrastructure costs.
Limited customization options: While customization is possible, some users crave more flexibility and control over the platform's look and feel.
Show more

Information Builders Inc. (ibi) offers a feature-rich business intelligence data and analytics platform that unlocks actionable insights and the power of decision-making for users throughout an organization. Rated highly for ease of use by most reviewers, it empowers self-service data discovery with a user-friendly UI that enables drag-and-drop data analysis and visualization; some users noted that this UI looks outdated, especially compared to those of competitors. The platform offers a wide range of prebuilt data visualizations that users can further customize if necessary. This platform excels at creating and designing reports, then distributing them either at-will or through the automated scheduling tool, as noted by a majority of users who reviewed reporting. Most notably, the platform has an outstanding support team — all of the users who reviewed its support expressed satisfaction with their proactive, responsive assistance, citing the vendor’s dedication to the success of their customers as notably apparent. Customers can tailor the platform to their needs, as its flexibility allows for customized solutions. Frequent updates add value over time, though some users remarked that these sometimes break features from older versions. Other performance issues noted in reviews include lags when performing complex queries, infrequent crashes, slow load times and issues when accessing the platform from specific devices or browsers. While easy to pick up and use, especially for the end-user, some reviewers said that there is a learning curve to master the many features of this tool — a few users noted that this learning curve lasted a few months for some team members in their organizations. Overall, ibi data and analytics is a worthy pick for self-service data visualization and reporting, especially in the hands of an organization willing to invest the resources and time to make it shine.

Show more

Reviews of Pentaho paint a picture of a powerful, open-source data platform with both promise and pitfalls. Many users cite its wide range of tools and impressive scalability as major strengths, allowing them to tackle diverse tasks without needing multiple products. "It's a Swiss Army knife for data," one reviewer enthusiastically declared. But this power comes with a caveat – a steeper learning curve compared to more user-friendly options like Tableau. "It's not drag-and-drop intuitive," another user cautioned. Documentation is another point of contention. While some praise the available resources, others lament it as incomplete or outdated, often requiring community forums for troubleshooting. This is where the strong, active community becomes a saving grace – a true differentiator for Pentaho compared to pricier competitors. "The community is like having a built-in support team," a user noted, highlighting the value of shared knowledge and collaboration. However, users also report occasional bugs and glitches, especially in the free Community Edition. This can be a frustration for those seeking enterprise-level stability. And while Pentaho handles large datasets admirably, its resource-intensive nature can demand costly hardware upgrades, a factor to consider against competitors with built-in cloud options. Overall, Pentaho emerges as a versatile platform for those willing to invest time in learning its intricacies. Its open-source nature and powerful toolset make it a budget-friendly choice for startups and data-savvy teams. But for those prioritizing user-friendliness and seamless workflows, alternatives might be more appealing. Ultimately, the choice boils down to balancing Pentaho's strengths and weaknesses against your specific needs and technical expertise.

Show more

Screenshots

Top Alternatives in Business Analytics Tools


ClicData

Cognos Analytics

Domo

Dundas BI

Entrinsik Informer

Grow

Halo BI

Infor Birst

InfoZoom

JReport

Klipfolio

Looker

MicroStrategy

Oracle Analytics Cloud

Orbit Analytics

Power BI

Pyramid Analytics

Qlik Sense

Reveal BI

SAP Analytics Cloud

Related Categories

Head-to-Head Comparison

WE DISTILL IT INTO REAL REQUIREMENTS, COMPARISON REPORTS, PRICE GUIDES and more...

Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
Table settings