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.
"IBM Cognos improves the effectiveness of the sales team."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"We are able to generate quality reports easily which allows us to decrease response time."
"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"In terms of stability, I think that Cognos is more stable than Tableau and Power Bi because of its framework manager concept that allows us to import metadata and store it in the framework manager."
"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."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"Its connection to every database: Whatever and wherever it is."
"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."
"There is also a chart store where we can download charts, which is extremely useful."
"Microsoft BI's initial setup is very straightforward."
"It's similar to Excel, but it's much more powerful than Excel."
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"With Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools."
"My primary use is for view of the dashboard."
"The solution seems to slow down the servers."
"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."
"It would be good if the solution had conditional formatting."
"The performance is a bottleneck and something that can be improved."
"Need improvement towards Visualization."
"The technical support team’s response time is slow and needs to be improved."
"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."
"It should have more integrations."
"I would like to see more visualization options."
"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."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it."
"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."
"I believe the price should be degressive, and we should have a lower, or better unit price if we have more users."
"The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
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.