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
Reviews Sentiment
6.8
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
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
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
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

"Even while a user is using a cube for reporting, there will not be a situation as ' Cube file locked; unable to build or deploy'."
"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."
"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."
"The basic platform comes with several meta-modelling tools."
"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"Power BI pricing is generally considered more affordable than Tableau."
"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"The interface is very easy to use."
"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."
"It's a straightforward setup."
"Ease of development and maintenance."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"You can do a lot of things on the back end which are not possible in the other solutions on the market."
"You can switch views easily."
"E-T-L, The Extract, Transform, and Loading capabilities of QlikView make it a highly sophisticated self-service business intelligence tool for developers and analysts."
"Scripting as per a customer's need, which is a pretty cool feature and not available in other tools."
"The language support is very good."
"QlikView is one of the strongest tools, I would say. Also, it has a very vast capability to process the data"
"This is a very cool application with endless options of creativity and visuals."
"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
 

Cons

"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"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."
"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"The solution's support could be better."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"The dashboards lack a user-friendly appearance."
"We need more integration capabilities."
"Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today."
"I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."
"The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
"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 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."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
"Enhancing user-friendliness would be highly beneficial."
"The pricing is high."
"It needs work with visualization."
"Error handling."
"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."
"They could improve the speed."
"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."
"I really wish the application was easier to use in the development phase."
 

Pricing and Cost Advice

"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"Pricing should be improved."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"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."
"It is pretty expensive."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"It's more expensive than similar solutions like Tableau and Power BI."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"All of the licenses are on an annual basis, but Microsoft will amortize it to an extent. If it's five years, they'll include the possible interest they might have the following year. Ideally, their licensing scheme is an annual license, but they make it easier for some of our clients to take a five-year license but package everything inside for them to buy the license for five years."
"The solution is priced well for what they offer. However, the premium version is very expensive."
"Pricing, that's where Microsoft beats Tableau. It is priced much cheaper."
"We pay for users who are publishing on the cloud. The desktop version is free. Its licensing is on a yearly basis."
"Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"The Report Server is pretty expensive on-premise. But as long companies are happy to use the cloud version, that's very cost effective."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"The platform's pricing is considered quite expensive, particularly given the dollar-based pricing."
"It is not very expensive. I think it it is on par with other similar products on the market."
"Pricing is a bit too high and I think licenses should be unlimited."
"On a scale of one to ten, where one being low price and ten being high price, I rate pricing a four."
"It has an annual license. It is expensive as compared to other competitive tools that do more for less. In South African rands, we pay about 100,000 to 200,000 a year."
"QlikView pricing and licensing is on the high side for a small sized company, but it's competitive among its peers."
"QlikView is a reasonably priced solution."
"It is quite expensive, rating at around nine out of ten on a cost scale."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
7%
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.
816,406 professionals have used our research since 2012.