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

Amazon QuickSight vs Knowage vs Microsoft Power BI comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Mindshare comparison

As of July 2025, in the BI (Business Intelligence) Tools category, the mindshare of Amazon QuickSight is 6.3%, down from 9.4% compared to the previous year. The mindshare of Knowage is 0.5%, down from 0.5% compared to the previous year. The mindshare of Microsoft Power BI is 20.7%, down from 21.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Mohd Farhan - PeerSpot reviewer
Has seamless data filtering and visualization for client satisfaction
One area for improvement is the cost, as it's a bit expensive. The caching mechanism also charges too much if I need to cache any data. Sometimes it takes time to display data, suggesting a need for enhancement in data visualization speed. Additionally, the role-level security is challenging to implement, and it could be improved to allow access control per department more easily.
AM
Easy to customize, cross-platform capable, and very stable
The only challenge here is that it's a Java-based platform. It requires very high technical skills. When we come to the integration with the single sign-on facilities, that part is very challenging. In Power BI and other tools, it's very easy to integrate with active directory and single sign-on, and identity management is very easy in other business intelligence tools. However, when it comes to Knowage, it's a bit heavy, it's time-consuming sometimes, it's not very fast, and definitely not as fast as other business intelligence tools in terms of getting graphical reports. The solution could be cheaper.
Shoury Priyanshu - PeerSpot reviewer
Facilitates seamless data aggregation with some outdated visual elements hindering user appeal
Real-time data integration is an area for improvement. Although I've worked on several solutions involving real-time integration, it's not very user-friendly and often lags, especially with over a million data rows. This makes Power BI difficult to manage as loading times can reach one or two minutes, which is problematic today. There are challenges with scalability, requiring multiple pages in dashboards to manage these issues. Visualization could be improved as it appears outdated. Users, especially newcomers, find it unappealing and not user-friendly.

Quotes from Members

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

Pros

"I like that with Amazon QuickSight, you don't need to install an app to use its services. With other BI tools, you need to install the app, so Amazon QuickSight is better for me in this area."
"Efficiency has definitely improved, and the speed of developing analytics and insights has increased by at least twenty percent."
"The integration is very seamless. We stored our result CSV files in S3 and connected directly from there."
"Amazon QuickSight has introduced a new functionality called Q bar, which allows the user to do natural language queries and get additional insights using some built-in generative capabilities."
"The most valuable feature of this solution is the user interface."
"Compared to other reporting tools, it is very effective but does require an understanding of certain concepts in QuickSight. This understanding is crucial for creating dimensions, changing metrics, and visualizing reports."
"The product is easy to learn."
"It is notably fast in handling large data set refreshes, making it efficient for data analysis."
"The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice."
"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage."
"The embedding feature is great."
"We can easily do our own customizations."
"The solution is easy to set up and implement."
"It provides easy integration with Office tools."
"The standard BI visualization capabilities are great."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"Ease of development and maintenance."
"The ROI is high for small teams or basic use cases with limited datasets."
"My favorite feature is the power query editor, where it can do the data transformations."
"Users already using Excel can generate new reports and dashboards within minutes."
 

Cons

"One area is that integrating data from different sources into QuickSight can be a bit tricky, especially with Amazon Connect. To get data flowing, you need to use two additional services and configure them correctly."
"There is room for improvement in terms of the number of visualizations and dashboards that are available."
"One area for improvement is the cost, as it's a bit expensive."
"Lacked connectivity with other third-party tools and data sources."
"The number of features in the product is limited in comparison with the other tools in the market, like Power BI."
"The setup process falls somewhere in the middle. It is not straightforward, nor is it complex, but there is a significant amount of work needed on the back end to make it function."
"The product is quite expensive because the price is too close to QlikView's prices but it does not ring as well as QlikView."
"An area for improvement in Amazon QuickSight is storage. Data cleanup also needs improvement because I'm experiencing errors when cleaning the data. Amazon QuickSight needs video tutorials showing its different functions and purposes."
"It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products."
"The only challenge here is that it's a Java-based platform. It requires very high technical skills."
"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"The dashboard components could be better."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"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."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
 

Pricing and Cost Advice

"The solution's pricing is cheaper than the other products in the market."
"A highly affordable cost structure with fixed membership and timeframe basis options."
"It is simpler and cheaper than other solutions."
"I rate the price of Amazon QuickSight a four on a scale of one to ten, where one is a low price, and ten is a high price."
"Amazon QuickSight you subscribe and you use the service."
"I wouldn't say that it is an expensive product, but to stay competitive they would need to bring down the prices."
"The Amazon QuickSight licensing model my company's on is pay-as-you-go, but I wouldn't be able to give the figures because that's handled by the finance department."
"The standard edition is free to use for exploration purposes while the enterprise edition needs to be paid for. The pricing for this solution is very reasonable."
"Knowage is open-source, and an enterprise edition is also available."
"It allows the implementation of an effective reporting system using internal skills at a limited upfront cost."
"The solution is affordable."
"The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users."
"Licensing fees are paid on a yearly basis."
"The only other cost, besides the licensing fee, would be to cover support."
"There is room for at least 45% discount as compared to the initial price."
"They have a free Power BI Desktop version, but it has limitations."
"It would be better if the price was cheaper."
"My company needs to make monthly payments towards the licensing costs attached to the product."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
862,514 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
Financial Services Firm
15%
Computer Software Company
14%
Manufacturing Company
9%
Government
6%
Government
16%
Real Estate/Law Firm
11%
Hospitality Company
11%
Insurance Company
10%
Financial Services Firm
12%
Educational Organization
10%
Computer Software Company
9%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Amazon QuickSight?
The integration is very seamless. We stored our result CSV files in S3 and connected directly from there.
What is your experience regarding pricing and costs for Amazon QuickSight?
Amazon QuickSight charges $250 per user, which becomes expensive when managing multiple departments. However, this co...
What needs improvement with Amazon QuickSight?
One area for improvement is the cost, as it's a bit expensive. The caching mechanism also charges too much if I need ...
Ask a question
Earn 20 points
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 ...
 

Also Known As

QuickSight
SpagoBI
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Overview

 

Sample Customers

MLB Advanced Media, Infor, HotelBeds, Gemini, Jivochat, Edmunds.com
FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
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
Find out what your peers are saying about Microsoft, Salesforce, SAP and others in BI (Business Intelligence) Tools. Updated: July 2025.
862,514 professionals have used our research since 2012.