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
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
Jul 27, 2022
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
Jul 17, 2024
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
Aug 4, 2020
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

"The tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"For planning, forecasting, in-boxing, modeling in general and for predicting numbers and doing work analysis, they are excellent."
"This solution allows you to input a wide range of file formats."
"One of the strong suits of Cognos is its robust corporate reporting capability."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"There are some great automation elements in the product."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"The initial setup is easy."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company."
"I've seen no issues with BI's stability."
"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."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"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

"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."
"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 technical support team’s response time is slow and needs to be improved."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"Extending dynamic cubes aggregate awareness with calculated measures."
"The high cost of a license makes it hard to scale up on a budget."
"It would be better if it is was easier to implement without extensive training for it."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"I would suggest improvements in visualization standards, particularly in customization and appearance."
"I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."
"There is room for improvement in terms of customization and configuration options, particularly for more advanced users."
"The accounting data needs improvement."
"The solution could improve by having more attractive graphical charts."
"I would like to be able to use more predicting data science features without having to use R."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
"Would like the ability to be able to benchmark."
"There should be a better or an easier way to establish that connection to external sources."
 

Pricing and Cost Advice

"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"It is averagely priced."
"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."
"The solution is affordable."
"It is pretty expensive."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"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."
"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."
"I used the tool's free version."
"Pricing is a big advantage that Power BI has over Tableau. Power BI is three or four times cheaper than Tableau. For my personal use, I will definitely prefer a $20 monthly fee of Power BI rather than a $70 monthly fee of Tableau. If you pay altogether for Power BI, they give you a discount, whereas, with Tableau, there is no discount. There are three versions of Power BI: Free, Pro, and Premium. The Premium version comes with a lot of things. There is no extra or hidden fee. You pay every month, and the software is with you. If you upgrade, there will be some extra charges."
"The pricing is very reasonable compared to any other tool."
"The premium licensing is approximately $5,000 per month which is pretty expensive."
"As far as I am aware you do not need a license for the solution."
"Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
"Microsoft BI is not expensive. Compared to the price of other BI products, the price is very fair."
"It is free."
"14,000 Pounds per year for licensing."
"I am still using the two-week trial, but at first sight, the price is reasonable."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
814,649 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
57%
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
16%
Computer Software Company
15%
Manufacturing Company
11%
Energy/Utilities 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 ...
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.
814,649 professionals have used our research since 2012.