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 is developing reports from different data sources, making it a reliable data source."
"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."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"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."
"It is a stable product."
"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."
"We are able to generate quality reports easily which allows us to decrease response time."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"The stability is good."
"We have found the solution to be stable."
"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."
"The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."
"Microsoft BI is scalable."
"The solution is quite scalable."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"Need improvement towards Visualization."
"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."
"It would be nice to offer free online training on the tool for end-users."
"The performance is a bottleneck and something that can be improved."
"Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as straightforward. Formatting is also more challenging in the cloud than in other applications, like Power BI. Also, if you encounter an issue, it takes more time to resolve it on the formatting side."
"The smart phone application could be improved, along with better graphics and faster updating."
"There are some connector-related issues in their MSBA solution."
"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
"The cost of the solution can get high."
"I would like to see more visualization options."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
IBM Cognos is ranked 4th in Reporting with 132 reviews while Microsoft Power BI is ranked 1st in Reporting with 297 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 Oracle OBIEE, Tableau, SAP BusinessObjects Business Intelligence Platform, Oracle Hyperion and Amazon QuickSight, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and SAP BusinessObjects Business Intelligence Platform. 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.