Try our new research platform with insights from 80,000+ expert users

Dundas BI vs Microsoft Power BI comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Dundas BI
Average Rating
8.6
Number of Reviews
21
Ranking in other categories
Data Visualization (25th), Embedded BI (11th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. Dundas BI is designed for Data Visualization and holds a mindshare of 0.5%, down 0.6% compared to last year.
Microsoft Power BI, on the other hand, focuses on BI (Business Intelligence) Tools, holds 22.4% mindshare, up 22.4% since last year.
Data Visualization
BI (Business Intelligence) Tools
 

Featured Reviews

Ishwar Saswade - PeerSpot reviewer
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
With Dundas BI, we do not have end-users apart from the developers. End-users do not find it easy to create their own reports. Most of the implementations I have seen require a developer team for creating the visuals, and they then give them to end-users. A self-serve part where end-users or business users can create their own reports would help in terms of the adoption of Dundas BI. Currently, business users find it difficult to work with Dundas BI because there are so many settings that they don't know what they need to do. Even when a developer starts working on Dundas BI, he needs to spend at least one month or so getting used to the functionalities of Dundas BI. Even then, it is not easy to remember where or how they made a certain property change. It takes at least one month for a developer to get acquainted with it. 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. Dundas can further reduce the number of settings they have. When you create any chart in Dundas, you get a lot of features to control each setting, which is pretty useful for BI, but for end-users, it is difficult to identify the exact settings to change a property. I would love it if some of the options come pre-selected. If some of the settings are set to best practices by default, it will be helpful. Whenever we have any issues, the error messages that we get in Dundas BI are not very helpful in identifying the root cause. Making these changes will bring a lot of change to the end-user experience.
Amol Rane - PeerSpot reviewer
Supports AI initiatives in terms of predictive analytics
The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We have now the ability to create interactive and complex reports without the need for software developers and code."
"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."
"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."
"The solution has a good drag-and-drop feature for creating dashboards."
"We use Dundas to report on machine sensor data and create dashboards."
"The Layers feature organizes my work and makes it easier, instead of having to use scripting to show and hide when drilling down."
"The one feature most of our customers like is data visualization. When we were doing BI directly from SQL, most users found it challenging to create their own reports. Power BI has self-serve analytics that the end-users can do themselves. On most projects, people are primarily using data visualization and self-serve analytics."
"The tool's most valuable features are slicer and Microsoft Copilot integration. It also allows users to see reports on mobile devices. The solution can also integrate with various data sources."
"Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data."
"It is a powerful tool that helps our data analysis processes."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
"The Microsoft Power BI app is very good. It's also very flexible."
"It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
 

Cons

"Lacks sufficient online support."
"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."
"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."
"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."
"I cannot select a visualization and see what filters are connected to it."
"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."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"Whenever you work on the same dashboard or on the same code, Microsoft Power BI doesn't have a good architecture that allows multiple people to work on the same project."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in."
"Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product."
"Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"When there are large amounts of data being processed there are additional tools needed to handle it."
 

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."
"The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users."
"It is part of our Office 365 license."
"The solution is priced well for what they offer. However, the premium version is very expensive."
"I would rate them 4 out of 5 for their current pricing. There are no additional costs to the standard licensing fees."
"They have a free Power BI Desktop version, but it has limitations."
"Power BI is cheaper for smaller groups when comparing to competitors. It requires a monthly per-user subscription."
"From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money."
"I used a two months free trial to see if it had what I needed."
report
Use our free recommendation engine to learn which Data Visualization solutions are best for your needs.
824,067 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Government
16%
Financial Services Firm
13%
Computer Software Company
13%
Educational Organization
8%
Educational Organization
42%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with Dundas BI?
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.
What is your primary use case for Dundas BI?
We use Dundas to report on machine sensor data and create dashboards.
What advice do you have for others considering Dundas BI?
I rate Dundas BI seven out of 10. It should be simpler to use. I'm sure there are lots of knowledge-base articles that might help, but the process is still complex. you need to build cubes and thin...
Seeking lightweight open source BI software
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...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance po...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
 

Also Known As

No data available
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Learn More

 

Overview

 

Sample Customers

Coca Cola, Siemens, Verizon, Microsoft, Pitney Bowes, Scotiabank, Pepperidge Farm, Shutterstock, Norwegian Government, Boeing, Guess Inc., BP, Bayer
Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Find out what your peers are saying about Dundas BI vs. Microsoft Power BI and other solutions. Updated: October 2024.
824,067 professionals have used our research since 2012.