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 features of IBM Cognos are governance and enterprise reporting."
"The most valuable feature of IBM Cognos is security. The solution has updated features that other competitors' solutions come out with long after IBM Cognos has had them."
"We are able to generate quality reports easily which allows us to decrease response time."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"The solution's initial setup process is easy."
"Comparing IBM Cognos to other applications, once a person is trained on it or they have developed a skill set to operate the application, it is best in its category."
"It is a stable product."
"If they want dashboarding, storytelling, and analyzing why KPIs are met or not, then Cognos is a better candidate than Qlik Sense."
"It provides good visibility."
"I've seen no issues with BI's stability."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"There are some great automation elements in the product."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"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."
"The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation."
"Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support."
"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."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"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."
"There are a lot of limitations with the out-of-the-box tool."
"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."
"It could have more options for themes."
"It would be good if the solution had conditional formatting."
"BI is scalable, but there are some problems with limited online storage."
"Things can slow down if you create too many pages."
"One area for improvement in Microsoft Power BI is serviceability. Compared to one of its competitors: Tableau, there are a lot of things which you cannot do in this tool, that can be done in Tableau."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"here are still better UI designs they can go through. I'm assuming they are focusing more on capabilities rather than look-and-feel designs."
"The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."
"The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script."
"The reporting needs to be improved."
IBM Cognos Business Intelligence provides a wide range of tools to help you analyze your organization's data. IBM Cognos BI allows businesses to monitor events and metrics, create and view business reports, and analyze data to help them make effective business decisions.
IBM Cognos applies techniques to describe, summarize, and compare data, and draw conclusions. This allows users to see trends and discover anomalies or variances that may not be evident by simply reading data. Data sources that contain information from different areas of a business can be stored in separate packages. Users can see only information that they have been granted access to, based on their group or role.
IBM Cognos BI consolidates the following business intelligence functions into a single web-based solution:
Reviews from Real Users
IBM Cognos stands out among its competitors for a number of reasons. Two major ones are its powerful analysis tool and its reporting capabilities.
Prasad B., a senior software engineer at a financial services firm, notes, “The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report. We can receive automated reports as well. They are easy to schedule on a weekly or monthly basis. It is very fast. I mean in means of report output, it's very fast compared to the actual clients involved.”
Microsoft BI is a business intelligence solution that connects to all your data sources and turns your data into insightful and useful business information that is relevant to all levels of the business, ensuring data accuracy, consistency, and security.
Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server - with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end users to better analyze their data, collaborate, and better present their data.
The BI platform empowers members of your organization to make data-driven decisions that drive strategic actions quickly by allowing them to work together easily on the same data, share insights, and collaborate on reports using other Microsoft Office applications.
Microsoft BI Benefits
Some of the benefits of using Microsoft BI include:
Reviews from Real Users
Microsoft BI stands out among its competitors for a number of reasons. Two major ones are its integration options and its data analytics capabilities.
Tariq R., an operations & BI analyst at American Hospital Dubai, writes, “Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. 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. ”
IBM Cognos is ranked 4th in Reporting with 16 reviews while Microsoft BI is ranked 1st in Reporting with 83 reviews. IBM Cognos is rated 8.2, while Microsoft BI is rated 8.0. The top reviewer of IBM Cognos writes "Helpful online community, highly reliable, and secure". On the other hand, the top reviewer of Microsoft BI writes "User friendly, easy to set up and great for analyzing data". IBM Cognos is most compared with Tableau, Oracle OBIEE, SAP BusinessObjects Business Intelligence Platform, Oracle Hyperion and MicroStrategy, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, KNIME, Domo and SAS Visual Analytics. See our IBM Cognos vs. Microsoft BI report.
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.