No more typing reviews! Try our Samantha, our new voice AI agent.

Amazon QuickSight vs Looker Studio 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

BI (Business Intelligence) Tools Mindshare Distribution
ProductMindshare (%)
Amazon QuickSight3.7%
Microsoft Power BI9.3%
Tableau Enterprise6.7%
Other80.3%
BI (Business Intelligence) Tools
Reporting Mindshare Distribution
ProductMindshare (%)
Looker Studio2.6%
Microsoft Power BI17.4%
Tableau Enterprise16.5%
Other63.5%
Reporting
BI (Business Intelligence) Tools Mindshare Distribution
ProductMindshare (%)
Microsoft Power BI9.3%
Tableau Enterprise6.7%
Amazon QuickSight3.7%
Other80.3%
BI (Business Intelligence) Tools
 

Featured Reviews

SN
IT Infrastructure Support Specialist at Olam Agri
Can always access reports through intuitive dashboards that support diverse data connections
I can't specifically say how Amazon QuickSight could be improved since I focus more on using it and leveraging its functionalities. However, I could invest additional time to explore possible feedback from customers regarding their challenges. As cloud engineers, our capacity to improve is limited since AWS manages the services, but I would be open to feedback. I'm aware there are minor details that AWS could enhance, such as optimizing costs for beginners or small startups, which can be steep when trying to take Amazon QuickSight into production. Many have noticed that AWS services greatly benefit well-established companies, while startups struggle with costs as they transition data out of AWS. Understanding how AWS charges for Amazon QuickSight usage is critical for all users wanting to visualize their data effectively.
Heron Ziegel - PeerSpot reviewer
Project Engineer at Quartz Consulting Group
Has supported quick dashboard creation and data sharing but lacks tools for managing multiple reports efficiently
We integrated Looker Studio with other platforms in our data ecosystem; we tried integrating with Sheets, and that went okay, but it could have been better. It could have been better because it needed a very specific format to read the data, so we had to reformat the sheet file. Looker Studio was mostly just helpful in that it provided live updating charts for tracking performance indicators in the organization. Integrating with a database was very difficult because there wasn't a lot of feedback for what was going wrong with the connection. I don't remember if we reached out to support. I didn't personally reach out, but my boss may have. I didn't reach out to support, so I do not have experience with it to rate it. We worked with the free version of Looker Studio initially, and we upgraded at some point to the pro version; I don't remember if we actually paid for it or if it was just a free trial. The pricing was reasonable. I remember doing a price comparison, and it was pretty reasonable, but it did have fewer features than a lot of other software, which was okay for a comparable price but a little cheaper.
Antonio Flor - PeerSpot reviewer
Lead Anaplanner at Chaucer Group
Data integration has improved reserving and expense control while collaboration drives fast dashboards
Regarding drawbacks or weak points in Microsoft Power BI, it may not be directly related to the tool itself, but with our architecture, as we couldn't get a service account, which is an email address that has no relationship with the employees, just to establish the connection with Anaplan. We couldn't get it to work on SSO, so we use an employee account which could be a point of weakness, meaning if the person leaves, that connection will break. If the person goes on holiday and we need to refresh, we have to change the connection as well, but we have to live with that since we're not using SSO on the service account. Regarding the natural language processing feature, we're trying to avoid using it too much because it can slow down the connection, so as much as possible, we try to build the logic and any transformation in Anaplan, and then deliver an end product to Microsoft Power BI.

Quotes from Members

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

Pros

"The ease with which it integrates with different data sources is most valuable, especially when everything is on AWS, it is easy to connect to the data source and organize different dashboards."
"Interactive dashboards do help with data analysis."
"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 most valuable feature of this solution is the user interface."
"The most valuable feature of Amazon QuickSight is its connectivity with other Amazon services."
"What I do like about QuickSight is that it gives a relative beginner the ability to really start seeing results quickly."
"The integration is very seamless. We stored our result CSV files in S3 and connected directly from there."
"It works well with the AWS ecosystem."
"I would rate this solution eight or nine out of ten."
"The integration with Excel and Google Sheets is a valuable feature, making it easy to access and visualize data."
"The most valuable features of this solution are its ease of use and the plethora of query sources."
"The best thing about the tool is that it allows you to share information easily and dashboards with colleagues and teammates because it's all online. No matter where you are, as long as you have the Internet, you can connect and use these dashboards. Google made good documentation for this tool. There are many examples of how to use and create dashboards and videos on YouTube. So, I think it's easy to learn."
"The ability to integrate with a great variety of data sources."
"The integration with Excel and Google Sheets is a valuable feature, making it easy to access and visualize data."
"The company dashboard is useful because we could share it via a link as a reminder for everyone to check it weekly. We observed the progress of our portfolio from last week to the current week, allowing us to compare revenues."
"This is a great tool if your organization leverages other sets of Google tools and needs some quick ideas that are a prettier and more interactive than Google Analytics."
"Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data."
"Microsoft BI stack is very easy to use and most of the developer versions are free such as Power BI, DAX, SQL Server Development Edition, which helped us with quick prototyping to generate value from data resting in silos."
"The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information."
"The ability to create dashboard presentations for various sectors is a valuable feature."
"The user experience is easy. Users get familiar with it quickly."
"So far, this product has met our needs pretty well."
"It is a powerful tool that helps our data analysis processes."
"The solution makes it easy for me to develop reports and publish them."
 

Cons

"There isn't much support available. We had an issue and when we tried to get support, they made it clear that they can't give any support, and what is lost is lost."
"The solution must be more user-friendly."
"Currently, auto-reporting is limited to some 30 times a day. As it is, if you want to set a data set to get it refreshed every half an hour, you cannot achieve it."
"The product has some storage and SPICE data issues."
"You can't tell a data story as well in QuickSight as you can on others, especially in TIBCO Spotfire."
"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."
"I just want a few more features to be added."
"I would appreciate improvements in the data modeling features, as it's not straightforward, and it's not what people in analytics are used to."
"The challenges with Google Data Studio are associated with the security part, making it an area where improvements are required."
"There are issues with integration and I encountered limits and warnings, especially with my pivot table size."
"When you physically install a product on one machine instead of the cloud, you have a better visibility, best icon quality, etc.. It's more of an issue with how we are adapting to the transition. We are still in the early moments of using this tool, and we need to go deeper to discover some improvements."
"From the perspective of infrastructure, I cannot provide a valuable opinion on the ease of use and customization options of Looker Studio."
"When you physically install a product on one machine instead of the cloud, you have a better visibility, best icon quality, etc.. It's more of an issue with how we are adapting to the transition."
"There is a significant degree of sophistication required to compete with Tableau or Cognos."
"Looker Studio did not fit our needs for scalability."
"Integrating it with the physics build model or the engineering model should be included."
"It needs a wizard that covers all its options."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
"While support is okay, they need to improve it a lot."
"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."
"Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy."
 

Pricing and Cost Advice

"I'm using a paid version of Amazon QuickSight, paying about $22 monthly. As I have yet to learn about the pricing for other tools, such as Power BI, I won't be able to compare."
"Amazon QuickSight charges $250 per user, which becomes expensive when managing multiple departments."
"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 solution's pricing is cheaper than the other products in the market."
"The product pricing is better than other vendors."
"A highly affordable cost structure with fixed membership and timeframe basis options."
"The pricing is cost-effective with a good plan."
"The solution is not affordable."
"The solution is free but the Google Looker is expensive."
"The product is available for free."
"I think the tool is cheap because you don't need to pay anything for using the tool. However, when connecting and analyzing other data sources, you should consider where to analyze this information because Google Data Studio doesn't handle much data well. You must also consider how you will connect this data to it. In this case, you might need to hire DevOps or a data team to help with these issues."
"The tool is free."
"The cost is quite affordable based on feature analysis."
"They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices."
"From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money."
"It is based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it."
"We have a professional license for Microsoft BI and the price is fair."
"The only other cost, besides the licensing fee, would be to cover support."
"Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost."
"I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage."
"The solution’s pricing is reasonable."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
885,728 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Senior Manager - BI Head with 5,001-10,000 employees
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%
Manufacturing Company
12%
Computer Software Company
10%
University
6%
Computer Software Company
10%
Financial Services Firm
9%
Manufacturing Company
9%
Comms Service Provider
7%
Financial Services Firm
11%
Manufacturing Company
9%
Government
8%
Computer Software Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise10
Large Enterprise16
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise3
Large Enterprise6
By reviewers
Company SizeCount
Small Business135
Midsize Enterprise58
Large Enterprise166
 

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?
I don't want to hypothetically say about the effectiveness of Amazon QuickSight in terms of machine learning, so I ne...
What do you like most about Google Data Studio?
The company dashboard is useful because we could share it via a link as a reminder for everyone to check it weekly. W...
What needs improvement with Google Data Studio?
I would appreciate improvements in the data modeling features, as it's not straightforward, and it's not what people ...
What is your primary use case for Google Data Studio?
I used Looker Studio mainly for reporting, where I created multiple dashboards on it. I wouldn't say I made the most ...
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
Data Studio
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
Genesys, Shueisha
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, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: March 2026.
885,728 professionals have used our research since 2012.