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

Microsoft Power BI vs Workday Prism Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
Reporting (4th)
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
Reporting (1st)
Workday Prism Analytics
Ranking in BI (Business Intelligence) Tools
14th
Average Rating
8.6
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.4% compared to the previous year. The mindshare of Microsoft Power BI is 23.0%, up from 22.8% compared to the previous year. The mindshare of Workday Prism Analytics is 1.5%, up from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
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.
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

"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"Integration with Office can enable the 'download' mode of storytelling.​"
"The dashboarding offered by this solution is very valuable to us."
"The initial setup is very straightforward."
"When it comes to decision-making, the product is very useful and used in many departments since a lot of people prefer the reports to be generated by IBM Cognos."
"Its connection to every database: Whatever and wherever it is."
"I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it."
"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."
"Our setup is very straight forward and can be done in a matter of hours."
"I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."
"The product's most valuable features are DAX functions for formulas and calculations."
"The most valuable features of Microsoft BI are the variety of possibilities to connect to various data sources. The visualizations are easily done, have useful rollover functions, and there are continuous updates being made to the system. You can benefit from the various improvements."
"Microsoft BI's most valuable feature is flexibility."
"The customer service and support are pretty good."
"The solution is stable and reliable, with minimal issues affecting its performance."
"I really like the flexibility the solution provides in terms of data transformation."
"Feature-wise, I feel that the solution's stability is good."
"The product is easier to use compared to other applications."
 

Cons

"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."
"It would be better if it is was easier to implement without extensive training for it."
"Tableau and Power BI are faster than Cognos."
"There are many problems with the product's stability part, making it an area where improvements are required."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"I need improvements, particularly with the Framework Manager, which has an outdated user interface from older versions like IBM Cognos 10 or 8. Additionally, the Event Studio, which offered great flexibility in previous versions, is no longer available in IBM Cognos Analytics 12. These are areas that could be improved to enhance the product."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"We need more predictive analytical functions, not only diagnostic or decryptic analytics."
"The initial installation is difficult."
"The solution could use a faster speed on certain interactions and a refresh of the dashboards."
"Although there are many visualizations, most of them are paid separately because they have been developed by private developers. The visualizations that come off the shelf are quite few."
"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."
"The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."
"Areas for improvement would be the construction of reports and the dashboard budget."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"The solution is somewhat costly in comparison with MSBI tools."
"There is not much flexibility in how we can add external data within Workday Prisma Analytics."
"It is not a very scalable product."
"One area for improvement in the solution is the ability to manually update individual rows or columns of data once it has been uploaded."
"When you create certain objects, a lot of the time, the fields are text. They’re not numeric, date, or any other field type"
"The visualization techniques must be upgraded."
 

Pricing and Cost Advice

"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"It's more expensive than similar solutions like Tableau and Power BI."
"Pricing should be improved."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"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."
"The price of the solution can be expensive if you want to synchronize your data more."
"The premium licensing is approximately $5,000 per month which is pretty expensive."
"We view it as an expensive product."
"Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
"Microsoft BI is not expensive. Compared to the price of other BI products, the price is very fair."
"Paid for itself in the first month."
"The solution is very expensive."
"Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool."
"I do not know of the licensing cost, but there are additional costs like 5,00,000 for recruitment modules."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
816,192 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Computer Software Company
9%
Financial Services Firm
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
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
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 wou...
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 info...
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 ...
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 o...
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 with...
 

Also Known As

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

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
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: October 2024.
816,192 professionals have used our research since 2012.