KNIME vs Dundas BI

Last Updated:

Our analysts compared KNIME vs Dundas BI based on data from our 400+ point analysis of Business Intelligence Tools, user reviews and our own crowdsourced data from our free software selection platform.

KNIME Software Tool
Dundas BI Software Tool

Product Basics

KNIME is an open-source end-to-end data analytics solution. It utilizes visual workflows with drag-and-drop functionality and thousands of nodes to lessen the data analytics learning curve data, with more than 1,800 prebuilt default workflows for streamlined setup.

It allows for data ingestion, preparing, cleansing, analyzing and visualizing. It can be scaled for deeper analytics through integrations with sophisticated data modeling capabilities. It can be hosted on-premise or in the cloud through Microsoft Azure.
read more...

Dundas BI is a self-service analytics solution with a keen focus on embeddability. With an eye on the end-user experience, the vendor provides options to design and embed dashboards into applications. Ranked five on our leaderboard, Dundas BI is a user favorite. The platform supports standard file formats and connects to cloud storage and enterprise systems.

Report templates and interactive visualizations make data accessible to all users. Some available graphics include bar and line graphs, scattergrams, pie charts, scorecards and maps. The system also suggests visualizations that fit the analyzed data.

Besides a long list of connectors, the platform has built-in ETL. You can switch from a data warehouse to live sources with the click of a button and write back to the warehouse from the interface.

The vendor, insightsoftware, offers it under the Logi Symphony umbrella, but Dundas BI remains a distinct product, and support is available. It supports multi-tenancy, and you can manage multiple clients with assured data security.

Roles include developers, power users and report consumers. The vendor provides shared concurrent licenses to keep pricing within reach. Unlimited data refreshes at no extra cost make it an attractive option.

Reviews praise its visual capabilities and ease of use, though most users say there’s a steep learning curve and performance can lag sometimes. Pricing starts from $2,500 monthly.

read more...
$0 Open-Source
Get a free price quote
Tailored to your specific needs
$2,500 Monthly, Quote-based
Get a free price quote
Tailored to your specific needs
Small 
i
Medium 
i
Large 
i
Small 
i
Medium 
i
Large 
i
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

  • Open-Source: Join a network of thousands of users, enabling collaboration and support. The source code is free to download and access.  
  • Free To Use: Save money by getting access to all of the platform’s features for free. Licensed productivity and collaboration extensions are available at a cost. 
  • Increased Business Intelligence: Get digestible, actionable data to make informed business decisions. Aggregating large datasets into predictive and prescriptive models via comprehensive visualizations and summary statistics gives users projections for the best course of action.  
  • Scalable: Obtain access to big data by scaling up the project in-platform. Integrations to distributed and multi-threaded data processing allow projects to grow. 
  • End-To-End Analytics:  It is capable of handling some tasks from start to finish without integrations. Additional integrations may be required for increasing scale and completing more sophisticated analytics. 
read more...
  • Gain Insight: Dundas BI wins our top honors for advanced analytics with a score of 92. You can write Python scripts within the platform and build clusters for customer segmentation. Forecast trends using regression and extract sentiment from buyer reviews.
  • Visualize Data: Dundas BI excels at dashboarding and visualization, earning our top award and a score of 100 in our JumpStart App. Its polished visuals embed perfectly into websites, apps and mobile devices. The vendor provides a lot of control over data displays. You can remove overwhelming menus and place navigation and selection options on dashboards. Animate icons to show data changes or display dashboards on a large screen in your office — the vendor has thought of it all. Though it can't compare with Qlik's associative power, Dundas BI remains an outstanding choice for professional dashboards.
  • Build Reports: Create paginated and pixel-perfect reports or design scorecards — the vendor offers many options to present data. Paginated reports have fixed page layouts for printed output, while pixel-perfect reports focus on precise design for a polished look. Version control lets you go back to the previous report and avoids the need to create local copies. The vendor’s focus on reporting UX and customization earns Dundas BI a top score of 100 in our rankings.
  • Manage Data: Define how datasets relate and apply joins during ETL. Explore new datasets without building a data model or generate data models with one click. Profile, correct and enrich data with simple selections. Analyze data from OLAP sources, such as Microsoft SSAS, Azure Analysis Services and Microsoft PowerPivot. Our analysts give it a 100 score for data management.
  • Embed Insight: Apply transformations, design dashboards and mashups, and analyze reports where you work. Embed the entire application or a screen into your business systems. Dundas BI is API-enabled and embeds without iframes. The vendor provides server and client APIs, SSO and authentication methods. It scores 100 in our rankings along with Power BI. But Power BI Embedded is priced separately from Premium and doesn't have the same customization levels.
read more...
  • Sharing and Collaboration: KNIME Hub is an online repository for existing workflows, nodes and extensions that can be easily installed into a user’s workflow. Upload workflows and search for the components needed for projects. 
  • In-database or Distributed Processing: Process data in-database or through a distributed cluster like Apache Spark for increasing scale. It has prebuilt workflows for in-database processing, like SQL Servers. 
  • Model Predictions and Validation: Using machine learning and AI, produce predictive and prescriptive models. Use performance metrics such as AUC and R2 to verify models.  
  • Visual Workflows: Using a drag-and-drop interface, compose a workflow with little to no coding. Prebuilt generic workflows and components can be downloaded from KNIME Hub. 
  • Data Management: Handles all steps of the extract, transform and load processes. It can ingest, blend, prepare, cleanse and store structured and unstructured data. It can combine data types, including PDF, JSON, CSV and unstructured types like documents and images. 
  • Data Visualizations: Compile analyses into reports with heat graphs, bar charts, scatter plots and more. Visualizations can be exported as PDFs, PowerPoints or other formats.  
  • Tool Blending: Tools with unique domains can be combined within a workflow via native nodes. These include Python or R scripting, processing connectors, machine learning and AI. 
read more...
  • Data Visualization Sandbox: Create and test data visualizations before using them in dashboards. Experiment with different chart types, color schemes and data combinations without risk. It's an excellent learning tool for teams that want to start using data for decisions.
  • Pattern Identification: The Identify Clusters button is a tool within Dundas BI that examines your dataset. It helps you find patterns in your data by clicking a button rather than manually sorting it. The tool puts similar data into groups that can help spot trends or unusual patterns.
  • Small Multiples: They allow you to compare values on the same scale and axes but in separate charts and graphs. One example is comparing the prices of hotels on an aggregator site.
  • Mobile Insight: Collaborate with your teams through an HTML5 browser, whatever the device. Leave comments and annotations for colleagues on visualizations and share them as a PDF or link. Double-tap to zoom into views, and pinch in and out to see maps and charts.
  • Content Scheduling: Share content by setting a schedule or trigger. Dundas BI offers scheduled sharing via the notifications option. Select the content type from among Excel, CSV, PDF, PowerPoint and PNG formats. Choose from email or file delivery. More distribution methods are available if you install Dundas BI extensions.
  • Administrator Privileges: Create, edit and delete projects and configure security settings. Share projects among tenants and assign or revoke permissions as required. Set up and manage user accounts and view login history. Monitor system and warehouse performance and keep tabs on memory storage with application logs.
  • DundasScript: Do more with your data. Write custom formulas and expressions that aren’t possible with standard connectors or visualization tools. Apply conditional formatting and define how users should interact with visual elements, such as setting up drill downs and tooltips.
  • Contextual Views: View only the information that matters to your role. Dundas BI has a data connector override function that switches to a different data source or schema based on who’s viewing the content.
  • Architecture: Dundas BI has JavaScript, HTML and CSS on the back end with a patented in-memory engine. It’s a C#, Asp.NET application hosted on Microsoft IIS for Windows, systemd for Linux or a Docker or Kubernetes container. The platform is available in hosted and managed versions. Supported databases include Microsoft SQL or PostgreSQL. All screens, including dashboards and report designers, are built on a public API with JavaScript or a REST interface. It makes it easy to customize and embed. Tiers include the user, application and data layers. End users get a smooth user experience with drag-and-drop and select actions. It's open to plugins for adding new functions, formulas, controls, and security and tenant and export providers.
read more...

Product Ranking

#89

among all
Business Intelligence Tools

#21

among all
Business Intelligence Tools

Find out who the leaders are

User Sentiment Summary

Great User Sentiment 236 reviews
Great User Sentiment 467 reviews
89%
of users recommend this product

KNIME has a 'great' User Satisfaction Rating of 89% when considering 236 user reviews from 4 recognized software review sites.

89%
of users recommend this product

Dundas BI has a 'great' User Satisfaction Rating of 89% when considering 467 user reviews from 5 recognized software review sites.

n/a
4.2 (14)
4.3 (41)
4.4 (137)
4.6 (18)
4.5 (122)
4.6 (139)
4.5 (118)
3.9 (38)
4.4 (76)

Synopsis of User Ratings and Reviews

Functionality: It provides a comprehensive set of nodes and functions to process large quantities of data, as noted by 69% of users who referred to functionality.
User Friendly: It is intuitive and easy to use, as noted by 79% of reviewers who refer to ease of use.
Connectivity: Around 77% of users who talked about connectivity mentioned its ability to seamlessly connect and integrate with multiple sources.
Cost: All users were happy that the solution is available free of charge, with no data limits.
Show more
Cost: Around 88% of reviewers mentioning pricing said the platform offered value for money.
Data Analysis and Visualization: Around 86% of users reviewing dashboards said they helped in decision-making.
Service and Support: Almost 83% of users praised support services for being prompt and said they got the help they needed.
Functionality: Around 75% of users praised the solution's rich feature set for helping them accomplish their tasks.
Ease of Use: Around 72% of users citing user friendliness said they could use it without much difficulty.
Show more
Performance: Nearly 95% of reviewers who mentioned performance said that the solution runs slowly and uses too much CPU and memory.
Visualization: Approximately 67% of users who specified visualization talked about its lack of proper visualization options.
Support: About 67% of users who reviewed support mentioned how hard it is to get proper documentation or support.
Learning Curve: KNIME has a steep learning curve, according to about 64% of users who mentioned the learning curve.
Show more
Training: Around 86% of users citing learning said there was a steep learning curve and documentation was inadequate.
Speed: Around 75% of users who reviewed performance said it lagged when handling large data volumes.
Show more

KNIME is a robust open-source solution with cross-platform interoperability. It integrates with a range of software, such as JS, R, Python and Spark. With a variety of nodes and functions, it can process large datasets with a decent level of control in each step. Workflows are displayed as connected nodes, making it easy to isolate and fix specific steps. It also contains built-in tools to create and test supervised and unsupervised machine learning models. Users found the UI very intuitive and flexible. On the flip side, they found the tool visually lacking and primitive. The system also has performance and stability issues. Processing big data is very time consuming since the platform isn’t cloud-based. Users reported excessive memory usage as well. It also lacks reporting or monitoring features. Decent technical knowledge is required to fully leverage its capabilities.

Show more

Dundas BI is a web application that stands out for placing the buyer first with built-in ETL, shared licenses and unlimited refreshes. It surpasses market leaders like Power BI and Qlik Sense in native functionality. It’s feature-rich, with 77% of capabilities available out of the box.About 72% of users reviewing the interface praised the platform, whereas others felt it was confusing. An open API architecture might be one reason for the UI's clutter, but the vendor offers a way out. You can make onboarding easier by removing components that seem complex.Usually, reporting is a loose term for dashboards and static reports and not much else. However, the vendor packs these tools into a neat package at no extra cost. Dashboards are usually static, single-screen views, but Dundas allows embedding reports in them to complement your KPIs. The support team is responsive with clear SOPs and quick responses, and the documentation is detailed.On the downside, many users felt it slowed when handling heavy workloads. Performance is critical in business, but every data tool has accompanying tradeoffs, and sadly, it’s often speed. That said, keep in mind that many factors are at play here — the hardware, internet speed, data complexity and database efficiency. Consider them for your use cases when evaluating performance, as they significantly impact how a program responds to user interactions.Ultimately, it boils down to this — how much lag can you accept before it impacts your business? A proof-of-concept or, even better, a trial would be your best bet to assess how the platform fares.Due to its rich scripting options, the learning curve can be steep. Users felt the feature documentation should cover more information on Javascript and APIs. Most reviewers were satisfied with the pricing, saying it offers value for money.In summary, Dundas BI is a powerful tool if you need a high degree of customization, scalability and flexibility. It can handle complex data environments and supports many users concurrently. It would be a good fit for mid to large-sized enterprises as they have diverse data needs and are open to investing in training.Organizations with simple data requirements may find the tool a bit over the top and the cost excessive. In such a case, opting for a tool with basic functionality might be a good start. One non-negotiable would be frequent, stable updates. It'll ensure the tool grows with your business over time.

Show more

Screenshots

Top Alternatives in Business Intelligence Tools


Cognos Analytics

Domo

GoodData

Grow

Logi Symphony

Looker Studio

MicroStrategy

Oracle Analytics Cloud

Power BI

Qlik Sense

QuickSight

SAP Analytics Cloud

SAS Visual Analytics

Sisense

Spotfire

Tableau

Related Categories

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