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.
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"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."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"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."
"We use the account statement report. When you use an account in HSBC, you receive various types of accounts, such as the stock market, fixed accounts, credit cards, and business accounts. We can create one consolidated report called CCS support, which includes all these accounts. In that statement, we are consolidating all those accounts."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The solution's initial setup process is easy."
"It has provided customer purchase patterns and great visualization."
"The ease of integration and connectivity stands out as the most critical aspect, followed closely by the flexibility to customize reports and dashboards."
"We have found that the reporting and publishing are great."
"The most valuable feature of this solution is real-time report tracking."
"The visualization and reporting are the most valuable features of this solution."
"The stability is great and continues to get better and better."
"It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
"They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license."
"I would like to see is more easy building, movement in the reports, and dashboard functionality within reporting. Overall more simple elements within reports. If the elements are simple then you don't have to render a full page, but you can move separate parts in the page."
"They should provide improved visual reporting."
"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."
"IBM Cognos's error messages seem to be a bit ambiguous. An error will be encountered and a message will be sent out very ambiguous and after investigating the error message it could be any number of issues. There was never a direct answer to the question or a direct answer to the error messages. Sometimes it would be a generic error message for 21 different solutions. It wasn't very specific, which required a lot of digging around and trial and error trying to fix the problem. The messaging in their error messaging is something needing improvement."
"The performance is a bottleneck and something that can be improved."
"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."
"It would be good if the solution had conditional formatting."
"There are a lot of limitations with the out-of-the-box tool."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"I feel the modeling page should be simplified."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."
"BI is scalable, but there are some problems with limited online storage."
"I'm missing collaborations functionality to operate or to work connected with multiple people on a data source or on virtualization. There should be more collaborations functions, such as in Confluence. We haven't explored the solution sufficiently in this area, but at this time it doesn't look sufficient."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
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.