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.
"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."
"This solution allows you to input a wide range of file formats."
"The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"Dashboarding, reporting, and ad hoc reporting are the valuable features of IBM Cognos."
"Mapbox integration for geospatial analytics down to longitude/latitude layers."
"We are able to generate quality reports easily which allows us to decrease response time."
"IBM Cognos improves the effectiveness of the sales team."
"Initial setup was very straightforward. Users can get up and running reporting on databases within minutes."
"In my experience the scalability is good. You are able to increase users and add more data."
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"It is a little easier at buildings charts and graphs than Tableau."
"The product is intuitive and user-friendly."
"The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good."
"Microsoft B's beneficial features are that it is a Microsoft product and it is well known by the staff here in the company. It suited the available skills."
"When we are introducing Microsoft BI to our clients, if they're familiar with Excel, the transition phase will be much easier for them. They can easily switch from Microsoft Excel to Microsoft BI. The core foundation or the base technology is the same in both tools. There are a few limitations in Microsoft Excel, and this is where Microsoft BI comes in."
"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"The solution's support could be better."
"The charts and graphics are weak."
"It would be better if it is was easier to implement without extensive training for it."
"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"The high cost of a license makes it hard to scale up on a budget."
"The technical support team’s response time is slow and needs to be improved."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"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."
"We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."
"The on-premises version lacks some technical features that are available with the Cloud version."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"The solution struggles with large amounts of data."
IBM Cognos is ranked 7th in BI (Business Intelligence) Tools with 132 reviews while Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools 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 BI (Business Intelligence) Tools vendors and best Reporting vendors.
We monitor all BI (Business Intelligence) Tools 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.