Try our new research platform with insights from 80,000+ expert users

Microsoft Power BI vs QlikView comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Microsoft Power BI
Ranking in Reporting
1st
Average Rating
8.0
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st)
QlikView
Ranking in Reporting
5th
Average Rating
8.2
Number of Reviews
160
Ranking in other categories
Embedded BI (4th)
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Microsoft Power BI is 26.5%, up from 25.3% compared to the previous year. The mindshare of QlikView is 3.2%, up from 3.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Jul 27, 2022
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Amol Rane - PeerSpot reviewer
Jul 17, 2024
Supports AI initiatives in terms of predictive analytics
The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.
Arjun Meda - PeerSpot reviewer
Mar 4, 2024
Useful for data visualization and business intelligence
Many of the features in Qlik Sense need to be available and reintroduced in QlikView. I believe many of the features have been added to QlikView after the layout containers were introduced. QlikView used to be a way more customizable tool than Qlik Sense is in the present time. Improvements are required in the hide and unhide functionality that falls under the layout container feature that has been used in my company in recent times. Hiding off the apps in the app overview tab based on the access was a really good feature that needs to be introduced back in the product since I see that, at the moment, there are multiple groups on the tool, owing to which multiple changes on the QMC part is required to handle the solution. Only the person with access to the dashboard in QlikView could have a link to the dashboard through QlikView's hub or access points. With Qlik Sense, one can see whatever is available in the stream. If a user wants to control everything in the product, then there is no need to make multiple changes in the QMC at the individual app level. The aforementioned area can be considered to improve Qlik Sense.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"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 tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"The solution's initial setup process is easy."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"The product is stable."
"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."
"We are able to collaborate on things and get insightful data visualizations."
"I like having the ability to connect Excel files as data inputs."
"I like the flexibility it offers."
"The most effective feature of Microsoft Power BI for data analysis is the ability to use Power Query directly from Excel. Power BI's integration capabilities impacted our data management by allowing us to push all reporting down to the end user, giving them the capability to perform "what if" scenarios and discover and validate their own data without needing to refer to IT. Additionally, it provided insights that we couldn't get from Oracle Cloud. We wrote an extract routine to transfer our Oracle Cloud database to Power BI, which was a game changer in terms of giving people confidence in the finances."
"The most valuable feature of the solution is that it is an easy-to-use tool."
"Its connection to every database: Whatever and wherever it is."
"We use QlikView for its cost-effectiveness and ease of integration with databases."
"The most valuable aspect is its extensive library on Microsoft, providing a robust framework for implementation."
"It is a stable product."
"One of the good thing is that you can integrate different data source technologies. So you can model your environment without having any of our views running."
"Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features."
"If you correctly use the product for your use cases, it provides value for money."
"We can scale it if we need to."
"The search feature: ability to see the related data."
 

Cons

"We need more predictive analytical functions, not only diagnostic or decryptic analytics."
"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."
"The solution's support could be better."
"They should provide improved visual reporting."
"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."
"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."
"I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."
"They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
"I would like to see some AI incorporated into this solution in the future."
"The on-premises version lacks some technical features that are available with the Cloud version."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"There is room for improvement in terms of customization and configuration options, particularly for more advanced users."
"Lacks the ability to copy data from BI into PowerPoint."
"If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlik view's scripting has somewhat of a learning curve."
"There is a challenge on the frontend when it comes to browsing data through QlikView, as it isn't entirely compatible with other platforms we use."
"Sometimes, dealing with complex reports requires more effort, which could be really improved."
"The only thing I would improve about it is the fact that it refreshes all the time, and when it does that, it just deletes all the options you had, all the filters that you had selected, so you need to select them from the beginning."
"Sometimes the filters are disappearing, and I'm not sure why this is happening."
"They could provide a user-friendly analysis process rather than specialized IT resource code."
"I would like to see more advanced features from Qlik Sense integrated into QlikView to keep it competitive and up-to-date."
"Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect."
 

Pricing and Cost Advice

"It's more expensive than similar solutions like Tableau and Power BI."
"It is averagely priced."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"Its pricing is great."
"It is reasonably priced."
"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
"The solution is affordable."
"The pricing is very reasonable compared to any other tool."
"No comment on pricing."
"Power BI is cheaper for smaller groups when comparing to competitors. It requires a monthly per-user subscription."
"Microsoft BI for desktop is free to use, and you can download and use it."
"My firm got the product at a cheap price, but in general, I believe that the product is a bit costly."
"The pricing is too high compared to the other solutions on the market."
"QlikView pricing and licensing is on the high side for a small sized company, but it's competitive among its peers."
"It is quite expensive, rating at around nine out of ten on a cost scale."
"I rate QlikView's pricing a five out of ten."
"QlikView is a reasonably priced solution."
"On a scale of one to ten, where one being low price and ten being high price, I rate pricing a four."
"I rate the product's pricing a three out of ten."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
814,572 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Educational Organization
57%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
40%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
8%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I wou...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize info...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are ...
What do you like most about QlikView?
If you correctly use the product for your use cases, it provides value for money.
What is your experience regarding pricing and costs for QlikView?
QlikView is probably on the pricier side than other BI tools. It's more expensive than the overall implementation of ...
What needs improvement with QlikView?
Creating an out-of-the-box solution for modeling capabilities might be beneficial.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
No data available
 

Learn More

 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Canon, Gatorade, Amcor, Panasonic, Fila, Cambridge University Hospitals, Global Retail Bank, North Yorkshire Police department, Lanoo Group Publishers, and AonGroep Nederland.
Find out what your peers are saying about Microsoft Power BI vs. QlikView and other solutions. Updated: October 2024.
814,572 professionals have used our research since 2012.