RStudio vs Dundas BI

Last Updated:

Our analysts compared RStudio 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.

Dundas BI Software Tool

Product Basics

RStudio is an integrated development environment suite for the R programming language, synthesizing coding tools into one software tool for easier advanced data processing. Using in-memory processing, it is capable of parsing big data through integrations and connections.

It is available in both open-source and commercial formats, with extra features available in the paid edition includes more sophisticated collaboration and security efforts. The free version is capable of end-to-end analytics, from API connectivity and data ingestion to visualization creation and distribution. It can be deployed standalone or on a web browser through connection to RStudio Server.
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...
$4,975 Annually
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 or Commercial: Create visualizations and reports from data analysis scripts with the open-source version. Access more advanced features, including deeper security and support with the paid version.
  • Streamlined R Programming: Execute code directly from the source editor by integrating the tools being used into one interface. Supports Git and Subversion for more advanced code writing needs.  
  • Advanced Data Analysis: Investigate trends on a big data scale via integrations for distributed processing, data modeling and predictive analysis. Develop deep analytical insights through R, the premier statistics coding language. 
  • Proprietary R Packages: Get sophisticated ready-to-install R packages comparable with machine learning frameworks to ingest, store, analyze and consume data.  
  • Data Visualization: Easily digest analyzed data through out-of-the-box and integrated visualizations and data consumption deployment vessels using Shiny and ggvis. Create interactive dashboards and charts with drill-down capabilities. 
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...
  • Source Editor: Develop programs in a single console window by synthesizing and integrating all tools in use. Highlight syntax, define functions and complete code in the console.  
  • Web Applications: Publish applications, dashboards and documents to the web with the internally-developed Shiny Server R package. 
  • Flexdashboard: Develop interactive dashboards with JavaScript visualizations, with support for HTML widgets, with this R package. 
  • Launcher: Launch R and Python processes remotely or submit R scripts to compute clusters like SLURM or Kubernetes. 
  • REST API Creation: Develop web API connections with the plumber R package — with as little as a single line of code. 
  • Spark Integration: Integrate seamlessly with Apache Spark to achieve big data analytics through distributed processing and leverage its machine learning capabilities to run more advanced queries.  
  • RStudio Connect: Publish statistical data analyses in the form of visually impactful visualizations, synthesizing all the aforementioned publishing features into one interface.  
  • Data Modeling and Prediction: Powers predictive and prescriptive analytics via connectivity to TensorFlow. Improves the product’s own data modeling capabilities via Tidymodels R package. 
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

#20

among all
Business Intelligence Tools

#21

among all
Business Intelligence Tools

Find out who the leaders are

User Sentiment Summary

Excellent User Sentiment 700 reviews
Great User Sentiment 467 reviews
90%
of users recommend this product

RStudio has a 'excellent' User Satisfaction Rating of 90% when considering 700 user reviews from 5 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.

5.0 (12)
4.2 (14)
4.5 (485)
4.4 (137)
4.6 (89)
4.5 (122)
4.4 (43)
4.5 (118)
4.4 (71)
4.4 (76)

Awards

RStudio stands above the rest by achieving an ‘Excellent’ rating as a User Favorite.

User Favorite Award

we're gathering data

Synopsis of User Ratings and Reviews

Data analysis: Around 96% of users who reviewed data analysis said that the platform had strong machine learning and data analysis capabilities.
Functionality: Approximately 86% of users who mentioned functionality said that the tool had a wide range of powerful features for efficient data visualization and analysis.
Ease of Use: The interface was user-friendly and easily navigable, according to 74% of users who reviewed this feature.
Cost: About 93% of users who mentioned pricing said that the open source version of the platform was a definite plus.
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: The tool used up a lot of memory and slowed down when processing large amounts of data, around 88% of users who mentioned its performance said.
Steep Learning Curve: Approximately 73% of users said that it was challenging to work with the platform without previous knowledge of R and that the syntax was difficult to learn.
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

RStudio is a powerful web- and cloud-based BI platform with excellent statistical analysis and data science capabilities. Integrating with cloud computing technologies, the platform has good machine learning capabilities to power data analysis by providing a wide range of features for data recovery, presentation and interpretation. It provides rich built-in visualization libraries with pre-set charts and functions that drastically reduce the need to code. Many users who reviewed its UI said that the interface was user-friendly and easy to navigate, though some users said that it looked dated and could do with an upgrade. Quite a few users who reviewed the platform for data analysis said that it was easy to run statistical and regression tests with minimal coding, and coupled with an open-source server, this platform served their data needs well. On the flip side, many users who reviewed the tool for performance said that it consumes a lot of memory and lags behind its competitors in speed. Quite a lot of users mentioned that the platform could be buggy at times and was prone to crashes, possibly because some libraries were not optimized for performance with large datasets. Many users found it confusing to access the open-source version, especially since separate versions of the platform work differently with some library packages. Some users complained that the code run, once started, could not be stopped and the stop button on the interface didn’t work. A majority of users who reviewed the learning curve as a feature said that the help section was difficult to understand and previous knowledge of R was required to leverage the tool to its fullest. In summary, RStudio is a versatile and extensible BI tool powered by machine learning and is capable of insightful statistical data analysis and forecasting 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