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 Report Studio that is aimed at professional report writers."
"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."
"The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."
"Security administration tools are powerful and flexible."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
"We are able to generate quality reports easily which allows us to decrease response time."
"Stability-wise, I rate the solution a ten out of ten."
"If you are not very technical this tool could be very useful."
"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."
"Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
"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."
"I think the visualization part is valuable."
"The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"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."
"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."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"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."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"Tableau and Power BI are faster than Cognos."
"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."
"The on-premises version lacks some technical features that are available with the Cloud version."
"The solution struggles with large amounts of data."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"The solution could be more customizable and you do not have too much freedom on the code."
"The solution's documentation needs improvement."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"The formatting template could be improved."
"Integrating it with the physics build model or the engineering model should be included."
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.