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

Microsoft Power BI vs Workday Prism Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

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

Categories and Ranking

Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
321
Ranking in other categories
Reporting (1st)
Workday Prism Analytics
Ranking in BI (Business Intelligence) Tools
13th
Average Rating
8.6
Reviews Sentiment
7.6
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.4%, down from 22.2% compared to the previous year. The mindshare of Workday Prism Analytics is 1.9%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.
Sarvesh Kumar Jha - PeerSpot reviewer
Provides great flexibility in terms of data transformation
I really like the flexibility the solution provides in terms of data transformation. Workday introduced Prism Analytics mainly because many clients wanted to merge data from different systems and then work with it to get some insights out of it. For that, they previously used tools like Power BI. Workday Prism Analytics gives you the power to do all the data transformations within Workday itself without taking out crucial data to a third system. I really like the way Workday has enabled Prism Analytics to be that one solution where you can bring everything. It also provides you the flexibility that things like the security model of Workday are still in place. You don't have to redo your security configuration if you do the data transformation outside Workday.

Quotes from Members

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

Pros

"Provides good data flow related to the container and control flow."
"My favorite feature is the power query editor, where it can do the data transformations."
"There is continual improvement year-over-year."
"The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
"We are able to collaborate on things and get insightful data visualizations."
"The standard BI visualization capabilities are great."
"Provides a full platform (database, ETL, reporting, analysis, and so on)"
"The most valuable feature of this solution is real-time report tracking."
"The solution is stable and reliable, with minimal issues affecting its performance."
"Feature-wise, I feel that the solution's stability is good."
"The customer service and support are pretty good."
"I really like the flexibility the solution provides in terms of data transformation."
"The product is easier to use compared to other applications."
 

Cons

"I am a SAP user and I would like this tool to have more connectors - and to more easily connect to - the ERP or SAP environment."
"Technical support could be a bit better."
"Microsoft BI can improve some of the visual level filters or visual functionality, that are available in other BI tools, such as Tableau or Qlik Sense."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"I have to write scripts to query data for analyzing performance."
"I would suggest improvements in visualization standards, particularly in customization and appearance."
"In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."
"It is not a very scalable product."
"The visualization techniques must be upgraded."
"When you create certain objects, a lot of the time, the fields are text. They’re not numeric, date, or any other field type"
"There is not much flexibility in how we can add external data within Workday Prisma Analytics."
"One area for improvement in the solution is the ability to manually update individual rows or columns of data once it has been uploaded."
 

Pricing and Cost Advice

"I rate the product pricing a ten."
"I think it's a good price, from what I've heard. I know it's competitive with other Power BI tools."
"I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
"Its licensing cost is very high. It is $20 per user, which is very high, but it is a good product, so you pay for it."
"The price of the solution can be expensive if you want to synchronize your data more."
"If it has to be applied on the cloud, then it costs around $10 per month per user. For a pro license and for a premium license it's around $20 per month per user. If it has to be applied on-premises then, depending on the course of your server, you have to buy a software assurance version of the database."
"No comment on pricing."
"We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."
"The solution is very expensive."
"I do not know of the licensing cost, but there are additional costs like 5,00,000 for recruitment modules."
"Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
849,686 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
Educational Organization
40%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
Financial Services Firm
10%
Computer Software Company
9%
Insurance Company
8%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

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 ...
What do you like most about Workday Prism Analytics?
Feature-wise, I feel that the solution's stability is good.
What is your experience regarding pricing and costs for Workday Prism Analytics?
Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool. In fact, that has been one of the hindrance factors for Workday in making Prism Analytics more sellable.
What needs improvement with Workday Prism Analytics?
I think there are still some gaps in the solution. There is not much flexibility in how we can add external data within Workday Prisma Analytics. For now, Workday has enabled the SFTP server and Am...
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
Prism Analytics
 

Overview

 

Sample Customers

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
Denny's
Find out what your peers are saying about Microsoft Power BI vs. Workday Prism Analytics and other solutions. Updated: April 2025.
849,686 professionals have used our research since 2012.