Dundas BI vs Pentaho Business Analytics comparison

Cancel
You must select at least 2 products to compare!
Dundas Logo
460 views|207 comparisons
96% willing to recommend
Hitachi Vantara Logo
1,175 views|854 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Dundas BI and Pentaho Business Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Tableau, Qlik, Splunk and others in Data Visualization.
To learn more, read our detailed Data Visualization Report (Updated: April 2024).
767,847 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The Layers feature organizes my work and makes it easier, instead of having to use scripting to show and hide when drilling down.""The solution has a good drag-and-drop feature for creating dashboards.""We use Dundas to report on machine sensor data and create dashboards.""With Dundas BI, you have a lot of visualization choices, and you can also do customizations by using HTML coding and JavaScript. The ease of development was one of the main factors for going for Dundas BI. The client had different reporting tools, but they wanted something that could accommodate all requirements.""We have now the ability to create interactive and complex reports without the need for software developers and code.""It was quite easy to use. The UI was basically drag-and-drop based. So, even if you were a beginner at coding software or something else, it would be easy to catch up on Dundas BI."

More Dundas BI Pros →

"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced.""Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud.""Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it.""Easy to use components to create the job.""The initial setup is pretty straightforward.""The most valuable feature of Pentaho is the Tableau report.""We were able to install it without any assistance from tech support."

More Pentaho Business Analytics Pros →

Cons
"I cannot select a visualization and see what filters are connected to it.""For every object, references are generated, but sometimes, there was a problem with the references overlapping each other. Everything would go off. It would stop working, and then from the admin side, people had to do something to bring it up again.""I would love to see more functions built in inside the application, instead of being scripted. They already did some of that in the new release, version 5, like forecasting, trend lines, etc., and I would love to see more of these kinds of calculations, which we used to do it by scripts before.""Working with the color palette is difficult in Dundas BI. They can work on different color palettes and make them organized and user-friendly. It would help a long way. Most of the time, the users face challenges in assigning colors to the fields that they have created or to the dimensions and measures in a chart.""It would be helpful if Dundas made the UI more user-friendly like the leading tools and decreased the learning curve. It should be simpler for a beginner to build dashboards.""Lacks sufficient online support."

More Dundas BI Cons →

"The repository should be improved.""Pentaho Business Analytics' user interface is outdated.""Logging capability is needed.""Version control would be a good addition.""Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention.""We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.""Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process.""Another concern is that Pentaho is not customizable or interactive."

More Pentaho Business Analytics Cons →

Pricing and Cost Advice
  • "I'm not aware of its cost. Its licensing was probably role-wise. Most of us had reader access, editor access, or developer access. For admin, there were certain restrictions. So, I'm assuming it had role-wise licensing."
  • "I am not majorly involved in its licensing. We are not the end license purchaser of the Dundas BI. It costs somewhere around $4,000 a year for the enterprise solution, but I am not sure."
  • More Dundas BI Pricing and Cost Advice →

  • "Free and commercial versions are available."
  • "Pentaho is expensive ."
  • "We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
  • More Pentaho Business Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Visualization solutions are best for your needs.
    767,847 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same companies are caught up in an imbrogilo as to which tool to use, what are the technology/and end business user wise differences/ do i actually need to purchase commercial edition, is there any work around etc. Differences :- In the below mentioned points, I have tried to cover functionality wise the differences a. Reports :- Jaspersoft is known for its picture pixel perfect reporting. Jasper uses ireport for designing the reports. Hence, for having reports, Jaspersoft is the most ideal candidate. Pentaho uses Pentaho Report Designer. b. Dashboards :- Pentaho provides much more capabililties, interactivity in terms of dashboards. Dashboards designed in Pentaho are far more superior in functionality, aesthetically as compared to Jaspersoft. Pentaho CE uses CDE/CDF, Pentaho EE uses PDD . Dashboard functionality is present only in the Enterprise edition of Jaspersoft. c. Pentaho is having an intermediate layer known as Xactions & hence providing much more flexibility in terms of plugin designing, integration with applications, having out of box experience etc. Xactions supports scripting and scheduling of scripts execution. Jaspersoft dosent provide that much of flexibility in terms of… Read more →
    Questions from the Community
    Top Answer:I am not majorly involved in its licensing. We are not the end license purchaser of the Dundas BI. It costs somewhere around $4,000 a year for the enterprise solution, but I am not sure.
    Top Answer:It would be helpful if Dundas made the UI more user-friendly like the leading tools and decreased the learning curve. It should be simpler for a beginner to build dashboards.
    Top Answer:We use Dundas to report on machine sensor data and create dashboards.
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with references to an added number of features.
    Top Answer:The product to me is not as user-friendly as other players in the market. It also still needs improvement in the reporting module. You will need to search for deployment examples or need to have a… more »
    Ranking
    21st
    out of 70 in Data Visualization
    Views
    460
    Comparisons
    207
    Reviews
    4
    Average Words per Review
    761
    Rating
    6.3
    Views
    1,175
    Comparisons
    854
    Reviews
    4
    Average Words per Review
    526
    Rating
    7.0
    Comparisons
    Also Known As
    Pentaho, Kettle, Hitachi Pentaho Business Analytics
    Learn More
    Overview

    Dundas BI is a powerful, flexible, end-to-end business intelligence platform that simplifies the entire analytics process and empowers its users to analyze and visualize data. The solution enables organizations to create and view interactive dashboards, reports, scorecards, and more. Dundas BI can be integrated into an existing website as part of a custom BI solution or it can be deployed as the central data portal for your organization. The solution is suitable for mid-to-large sized companies.

    Dundas BI Features

    Dundas BI has many valuable key features. Some of the most useful ones include:

    • Mobile responsive dashboards
    • Smart data display
    • Calendar support for retail and manufacturing
    • Data connectivity
    • Show/hide interaction
    • Batching data builds
    • Enhanced development workflow
    • Navigation support
    • Data regulation support
    • Optimized application performance
    • Instant application portability with docker
    • Easy SaaS support with Kubernetes
    • Natural language user input
    • Enhanced application security
    • Scheduled reports with multiple export options
    • Fully open APIs

    Dundas BI Benefits

    There are many benefits to implementing Dundas BI. Some of the biggest advantages the solution offers include:

    • Limitless customization: You can fully customize the Dundas BI platform, including its dashboards, data visualizations, interactions, scorecards, labels, etc. to meet your organization’s unique design requirements.
    • Effectively visualize and analyze data: The solution provides interactive data views that help you create pixel-perfect dashboards and reports that have interactive data visualizations so you can elevate your users’ abilities to effectively communicate data insights and drive faster decision-making.
    • Greater efficiency: Dundas BI can consolidate and store data from any source, providing seamless data delivery and a consistent user experience, which leads to greater efficiency. By having all your business intelligence, reporting, and data analytics needs in one single platform, you also save your organization a lot of time and effort.
    • Tailored data discovery process: Dundas BI adapts to all user types, allowing everyone to personalize it to suit their own needs and requirements, which helps users, data analysts, and developers to analyze their data quickly. The solution’s data discovery process also allows you to run ad-hoc queries, perform visual data analytics, and quickly create relevant and actionable content.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Dundas BI solution.

    A Business Intelligence Consultant at Siemens Industry says, “The flexibility of the dashboard designer is great. You can control every single pixel and no matter what the user asks for we can deliver. It has a lot of out-of-the-box options that you can use to customize your dashboard. There is also the option to use their JavaScript API, however, in 99% of the cases, the built-in options are more than enough. I also love the control you have on what queries Dundas BI is generating against our databases. This allows us to create really fast dashboards even when running against millions of records.”

    James D., System Architect at Yulista, LLC mentions that the most valuable aspect of the solution is its “ability to warehouse query results. This is good because you do not have to have a data warehouse, you let Dundas warehouse the results of a query that runs long during off hours.”

    Another reviewer shares, “The built-in ETL functionality has allowed us to combine data sources without the need for a full SSIS package. This saves time and allows for a quicker time to market.”

    Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

    Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

    The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

    Sample Customers
    Coca Cola, Siemens, Verizon, Microsoft, Pitney Bowes, Scotiabank, Pepperidge Farm, Shutterstock, Norwegian Government, Boeing, Guess Inc., BP, Bayer
    Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
    Top Industries
    REVIEWERS
    Manufacturing Company25%
    Energy/Utilities Company13%
    Healthcare Company13%
    Aerospace/Defense Firm13%
    VISITORS READING REVIEWS
    Government13%
    Financial Services Firm13%
    Computer Software Company13%
    Manufacturing Company9%
    REVIEWERS
    Computer Software Company19%
    University13%
    Financial Services Firm13%
    Educational Organization6%
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Government12%
    Computer Software Company11%
    Educational Organization9%
    Company Size
    REVIEWERS
    Small Business44%
    Midsize Enterprise17%
    Large Enterprise39%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise14%
    Large Enterprise59%
    REVIEWERS
    Small Business50%
    Midsize Enterprise17%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise60%
    Buyer's Guide
    Data Visualization
    April 2024
    Find out what your peers are saying about Tableau, Qlik, Splunk and others in Data Visualization. Updated: April 2024.
    767,847 professionals have used our research since 2012.

    Dundas BI is ranked 21st in Data Visualization with 21 reviews while Pentaho Business Analytics is ranked 21st in BI (Business Intelligence) Tools with 42 reviews. Dundas BI is rated 8.6, while Pentaho Business Analytics is rated 8.0. The top reviewer of Dundas BI writes "Has a lot of integration and visualization options, but can't be easily used by business users, and working with the color palette is difficult". On the other hand, the top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". Dundas BI is most compared with Microsoft Power BI, Tableau, Logi Analytics, Angles Professional and Salient, whereas Pentaho Business Analytics is most compared with Microsoft Power BI, Databricks, Microsoft SQL Server Reporting Services, SAP Crystal Reports and Tableau.

    We monitor all Data Visualization reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.