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.
"Security administration tools are powerful and flexible."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"IBM Cognos improves the effectiveness of the sales team."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"A positive feature is Report Studio, where we create beautiful, complex reports."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"MS SQL & SQL Server Analysis Services."
"The solution's initial setup isn't too complicated."
"I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
"We find the solution offers good stability."
"Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
"I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
"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."
"Reports, dashboards, and visualizations are most valuable."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"The charts and graphics are weak."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"Extending dynamic cubes aggregate awareness with calculated measures."
"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."
"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."
"Tableau and Power BI are faster than Cognos."
"Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"They can improve it in terms of rule-based security. Currently, it has very limited rules."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"Sluggish performance when handling large amounts of data."
"Power BI shows reports on actual data, not metadata."
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.