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

Microsoft Power BI vs XLCubed comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Microsoft Power BI
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st)
XLCubed
Ranking in Reporting
27th
Average Rating
7.6
Number of Reviews
2
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Microsoft Power BI is 26.5%, up from 25.3% compared to the previous year. The mindshare of XLCubed is 0.2%, down from 0.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

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.
it_user1391316 - PeerSpot reviewer
Cost effective with great capability, performance, flexibility and visuals
In general, we're happy with the solution but we're always looking to see what else is out there. The thing we've struggled with is our partnership with Tagetik UK, the consultants, and the issue we had gaining access to consultants to develop the solution on our behalf. Thankfully we connected directly with XLCubed and now have a pretty close and good relationship with them so the earlier problem we had of actually getting resources to help us develop has now been solved. One of the things that we've been asking for and would like as an additional feature is a sort of benchmarking functionality. The ability to be able to benchmark, directly against the company digital corporate numbers. That said, there seems to be improved functionality within the latest release that could help us develop that further.

Quotes from Members

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

Pros

"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"The Report Studio that is aimed at professional report writers."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"We are able to generate quality reports easily which allows us to decrease response time."
"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"Microsoft BI allows us to connect to any database or any dataset."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"You can integrate Microsoft Power BI with various other solutions like Intune."
"It's a great tool for visualization data, and it's free for engineers."
"It has provided customer purchase patterns and great visualization."
"The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information."
"This product has a lot of features and most of them are user-friendly."
"The product is intuitive and user-friendly."
"I am looking forward to testing their full graphics that are available, as they looked very interesting in the demo."
"Great capability, performance, flexibility, visuals, and the solution is also very cost effective."
 

Cons

"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of 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."
"They should provide improved visual reporting."
"There are a lot of limitations with the out-of-the-box tool."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."
"We need more predictive analytical functions, not only diagnostic or decryptic analytics."
"There are some small features that are missing. It would be nice if the graphics were better. You can use external sources for charts, but it's quite complex to use and not easy to implement. If you want a new chart, you can download it from multiple tools and implement it into IBM Cognos."
"I feel the modeling page should be simplified."
"Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today."
"People without private emails cannot publish and, frankly, this doesn't allow for easy training."
"Microsoft is behind IBM when it comes to security features."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"The solution could be more customizable and you do not have too much freedom on the code."
"I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"There should be a better or an easier way to establish that connection to external sources."
"Would like the ability to be able to benchmark."
 

Pricing and Cost Advice

"Pricing should be improved."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"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."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"I have not had a customer suggest the solution is too expensive. There are licenses to use the solution."
"We have a professional license for Microsoft BI and the price is fair."
"The solution’s pricing is reasonable."
"The price of the solution can be expensive if you want to synchronize your data more."
"It is free."
"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."
"This solution came free, it was offered by Microsoft with our E3 license."
"All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
"I am still using the two-week trial, but at first sight, the price is reasonable."
"14,000 Pounds per year for licensing."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 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%
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
12%
Real Estate/Law Firm
6%
 

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 ...
Ask a question
Earn 20 points
 

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
No data available
 

Learn More

Video not available
 

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
Marshalls Ltd, BP Exploration and Production, Thorntons, Ted Baker, Bristol-Myers, Rank Group, ING Bank Genve, Cargill Value Investment, Chloride Power, Auchan, Erste, UEFA, Novartis, Porsche Informatik, Raiffeisen Bank International
Find out what your peers are saying about Microsoft Power BI vs. XLCubed and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.