We performed a comparison between IBM Cognos and Microsoft BI based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Microsoft BI has a slight edge in this comparison. According to its reviewers, it is a more lightweight solution than IBM Cognos.
"The most valuable feature of IBM Cognos is security. The solution has updated features that other competitors' solutions come out with long after IBM Cognos has had them."
"If they want dashboarding, storytelling, and analyzing why KPIs are met or not, then Cognos is a better candidate than Qlik Sense."
"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."
"The Report Studio that is aimed at professional report writers."
"Security administration tools are powerful and flexible."
"We use IBM Cognos for enterprise analytics and reporting."
"One of the strong suits of Cognos is its robust corporate reporting capability."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"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."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making. It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training."
"The visualization part and its inclusion in a cloud-based application are valuable features."
"The reports are easy to create."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"There are some great automation elements in the product."
"Very intuitive and easy to use."
"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."
"Tableau and Power BI are faster than Cognos."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"The AI-based features could be further enhanced by the solution."
"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."
"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."
"The performance is a bottleneck and something that can be improved."
"The data source definition is all over the place."
"The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."
"Needs single sign-on."
"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."
"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."
"Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution."
"I would like to see more visualization options."
"In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."
IBM Cognos is ranked 4th in Reporting with 129 reviews while Microsoft Power BI is ranked 1st in Reporting with 293 reviews. IBM Cognos is rated 8.0, while Microsoft Power BI is rated 8.0. The top reviewer of IBM Cognos writes "Improved the quality of our KPIs, while reducing calls to the IT department". On the other hand, the top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". IBM Cognos is most compared with Tableau, Oracle OBIEE, SAP BusinessObjects Business Intelligence Platform, Oracle Hyperion and Amazon QuickSight, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Databricks. See our IBM Cognos vs. Microsoft Power BI report.
See our list of best Reporting vendors and best BI (Business Intelligence) Tools vendors.
We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.