Amazon QuickSight vs. Microsoft Power BI

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon QuickSight
Score 8.0 out of 10
N/A
N/A
$5
per month
Microsoft Power BI
Score 8.4 out of 10
N/A
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
$10
per month per user
Pricing
Amazon QuickSightMicrosoft Power BI
Editions & Modules
Readers
$5.00
per month
Authors
$24.00
per month
No answers on this topic
Offerings
Pricing Offerings
Amazon QuickSightMicrosoft Power BI
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Amazon QuickSightMicrosoft Power BI
Considered Both Products
Amazon QuickSight
Chose Amazon QuickSight
As per our requirement, the Amazon Eco System leads us to use the Amazon Quick Sight platform. It works well with Redshift datasources.
Chose Amazon QuickSight
Due to the fact that our platform infrastructure is mainly based on AWS, it was seamless and effortless for integration. Our second consideration is the operating cost in which QuickSight is reasonably low compared to other tools we had evaluated. From a development …
Microsoft Power BI
Chose Microsoft Power BI
Compared to Amazon QuickSight, if your dataset is coming from Amazon S3, it is much easier to just use QuickSight. However, if you are building a pipeline using prefect to transfer data, MS Power BI would potentially be a good tool to use and visualize the data by some none …
Top Pros
Top Cons
TrustRadius Insights
Amazon QuickSightMicrosoft Power BI
Highlights

TrustRadius
Research Team Insight
Published

Microsoft Power BI and Amazon QuickSight are business intelligence (BI) tools aimed at helping companies interpret and understand business data. Amazon QuickSight is a lightweight solution optimized for as-needed use. In contrast, Microsoft Power BI is designed for dedicated usage across a company, with standard per-user pricing and deep customizability.

Microsoft Power BI is almost equally popular with mid-size businesses as well as enterprise-level corporations, likely due to its per-user licensing and integration with the Microsoft Office 365 suite. Amazon QuickSight is most popular with mid-size companies and larger enterprises as well, although it also has a strong presence among SMB users. This is likely because its pricing model’s pay-as-you-go feature makes it affordable for smaller organizations.

Features

Although both products offer shareable charts and other data visualizations, they have individual strengths that set them apart from each other.

Microsoft Power BI thrives on its variety and customization capability. Its open-source repository contains a broad selection of high-quality user-submitted visualizations, all of which can be individually tweaked by end users. Its sharing features make it easy to show others the visualizations you’ve created, and it integrates well with MS Azure and Office 365.

Amazon QuickSight, as its name suggests, is designed for speed and ease of use. It’s lightweight and runs well even on large datasets with many users. QuickSight’s library of standard charts and visualizations can be quickly applied to various data sources, especially data from other Amazon Web Services (AWS) products. Users without an Amazon QuickSight license can access charts for a small per-usage fee, making it an attractive option for businesses that don’t require regular access to BI software for their employees.

Limitations

Amazon QuickSight and Microsoft Power BI both provide essential BI functionality, but they each have unique drawbacks to consider before purchasing.

Amazon QuickSight can be lightweight to a fault for some users. Its library of graphs and charts is limited when compared to some other BI solutions, and it doesn’t allow for the extensive customization Microsoft Power BI supports. New users report that its UI can be unintuitive at times. Amazon’s active development of the product means new features and improvements, but it can also introduce unexpected bugs and errors for end users.

Microsoft Power BI’s extensive variety, though helpful for many, can cause its own problems. Finding proper documentation for user-submitted visualizations may be difficult, and some may be missing documentation entirely. Some users may face a steep learning curve before they’re able to use the software’s advanced features. Microsoft Power BI can also consume a large amount of computer resources and may run slowly for some users. Finally, its pricing model may be reasonable compared to its competitors, but is less granular than Amazon Quicksight’s model.

Pricing

Amazon Quicksight offers two pricing models for its base product, and an add-on pricing structure for its data anomaly detection service.

Amazon QuickSight’s Standard Edition is $9.00 per user per month with an annual subscription, or $12.00 per user per month for a month-to-month subscription, with 10 GB per user of storage and $0.25 per GB for additional storage.

Amazon QuickSight’s Enterprise Edition has two separate pricing structures for Authors and Readers. Authors can create and publish data visualizations, while Readers have access to the dashboards created by Authors. For Authors, pricing is $18.00 per user per month for an annual subscription, or $24.00 per user per month for a month-to-month subscription, with 10 GB per user of storage and $0.38 per GB for additional storage. For Readers, pricing can vary from $0.30 to $5.00 per 30-minute session, per user, per month, depending on the number of Readers and how often they use the product. For more details, refer to the vendor’s pricing page.

Microsoft Power BI offers two options for pricing. The Power BI Pro tier is $9.99 monthly per user and includes all of its data visualization and BI features on the cloud, with 10 GB of storage per user and a limitation of 1 GB for each individual dataset. The Power BI Premium tier is $4,995 monthly with no additional per-user fee and adds features aimed at enterprise-level BI, including big data analytics and on-premises deployment. It also expands the storage to 100 TB total, with a 10 GB maximum size per dataset.

Features
Amazon QuickSightMicrosoft Power BI
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Amazon QuickSight
8.0
5 Ratings
2% below category average
Microsoft Power BI
7.1
138 Ratings
14% below category average
Pixel Perfect reports8.04 Ratings6.3118 Ratings
Customizable dashboards8.05 Ratings7.8138 Ratings
Report Formatting Templates8.05 Ratings7.2126 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Amazon QuickSight
7.2
5 Ratings
11% below category average
Microsoft Power BI
7.0
139 Ratings
14% below category average
Drill-down analysis8.05 Ratings7.0138 Ratings
Formatting capabilities8.05 Ratings6.3137 Ratings
Integration with R or other statistical packages6.03 Ratings7.5102 Ratings
Report sharing and collaboration7.05 Ratings6.9134 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Amazon QuickSight
6.9
5 Ratings
19% below category average
Microsoft Power BI
7.7
133 Ratings
8% below category average
Publish to Web8.03 Ratings8.0128 Ratings
Publish to PDF6.32 Ratings8.0121 Ratings
Report Versioning6.04 Ratings7.3101 Ratings
Report Delivery Scheduling7.04 Ratings8.7103 Ratings
Delivery to Remote Servers7.03 Ratings6.573 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Amazon QuickSight
5.8
5 Ratings
32% below category average
Microsoft Power BI
7.4
135 Ratings
8% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)6.05 Ratings7.4130 Ratings
Location Analytics / Geographic Visualization8.04 Ratings7.6121 Ratings
Predictive Analytics3.52 Ratings7.2101 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Amazon QuickSight
8.0
5 Ratings
6% below category average
Microsoft Power BI
8.2
126 Ratings
4% below category average
Multi-User Support (named login)8.05 Ratings8.1120 Ratings
Role-Based Security Model8.05 Ratings8.9102 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.05 Ratings8.5110 Ratings
Single Sign-On (SSO)8.04 Ratings8.594 Ratings
Report-Level Access Control00 Ratings7.01 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Amazon QuickSight
3.9
4 Ratings
69% below category average
Microsoft Power BI
7.9
117 Ratings
1% below category average
Responsive Design for Web Access4.03 Ratings8.0111 Ratings
Mobile Application3.52 Ratings7.493 Ratings
Dashboard / Report / Visualization Interactivity on Mobile3.84 Ratings7.5112 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Amazon QuickSight
6.0
3 Ratings
27% below category average
Microsoft Power BI
8.4
80 Ratings
6% above category average
REST API6.12 Ratings8.172 Ratings
Javascript API6.62 Ratings9.756 Ratings
iFrames7.03 Ratings8.055 Ratings
Java API6.12 Ratings8.046 Ratings
Themeable User Interface (UI)7.03 Ratings8.263 Ratings
Customizable Platform (Open Source)3.03 Ratings8.444 Ratings
Best Alternatives
Amazon QuickSightMicrosoft Power BI
Small Businesses
BrightGauge
BrightGauge
Score 9.0 out of 10
BrightGauge
BrightGauge
Score 9.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
Reveal
Reveal
Score 9.9 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon QuickSightMicrosoft Power BI
Likelihood to Recommend
9.0
(5 ratings)
7.8
(140 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(1 ratings)
Usability
7.0
(1 ratings)
9.0
(56 ratings)
Support Rating
9.0
(1 ratings)
7.7
(52 ratings)
User Testimonials
Amazon QuickSightMicrosoft Power BI
Likelihood to Recommend
Amazon AWS
Amazon Quicksight is a truly cloud-based solution so it works perfectly fine and saves a lot of expense in terms of hardware and maintenance. We can maintain it by ourselves by giving commands on UI. If you have connectivity issues then it can cause headaches because it's a cloud platform and it's a bit costly as compared to other services
Read full review
Microsoft
In operations we use the tool for many different topics, from factory quality systems to high level reviews. We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand. Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.
Read full review
Pros
Amazon AWS
  • Easily to set up for data sources, already supports quite a few of AWS and non-AWS data sources
  • Cost friendly since users are charged only for basis of usage
Read full review
Microsoft
  • Quickly filter and view granular data sets with easily configurable reporting figures.
  • The ability to quickly switch between tabs allows for historical data comparisons and progress tracking.
  • It's helpful to dive into the data and break it down from high levels to small.
  • Achieve actionable insights faster by using real-time data. It's incredible to have online access to reports.
Read full review
Cons
Amazon AWS
  • It is still immature as a cloud-based BI tool.
  • Its functionality is about 40-50% of its competitor's products.
  • Application is still a little buggy and non-intuitive at times.
Read full review
Microsoft
  • The desktop app is great but needs a lot of performance improvements
  • No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs
  • Premium Cloud Version of Power BI is awfully expensive
  • On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription
  • On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises
Read full review
Likelihood to Renew
Amazon AWS
No answers on this topic
Microsoft
I find it helpful and easy to use
Read full review
Usability
Amazon AWS
It is easy to use and set up no need to put in so much effort. Once build, the dashboard can be used with multiple clients with the same domain. It provides multiple connectivity options which makes it a versatile option for reporting.
Read full review
Microsoft
At this point, I think we all know who has taken the lead in the business intelligence and analytics market worldwide. With fresh new updates every other day on top of an already robustly built product with all features that one can dream of is a no brainer, I feel. Microsoft will invariably be synonymous with quality and professionalism.
Read full review
Support Rating
Amazon AWS
They provide proper support when needed. They are always ready to provide the box solution and make things easier for users.
Read full review
Microsoft
I can't really speak to the support overall, [but] I will say that in the almost three years I have used the system, I have only needed to contact their support team once. I think the team was helpful, but it did take some time for us to resolve the issues/ request that they had. I guess the good news is that the system is pretty stable, and I personally have rarely needed to contact their technical support team.
Read full review
Alternatives Considered
Amazon AWS
All of the other reporting platforms my organization has used previously were within our CRM and not a standalone program. In that we were very limited in being able to slice and dice the data the way that we wanted to
Read full review
Microsoft
[Microsoft] Power BI is practical and effective, like a hammer for a nail, it is easy to use and produces very quickly the results that in most cases are urgently required by clients (nice reports to share on the web). To start using [Microsoft] Power BI you need a business email address, with that you create an account in Power BI Service and in less than 1 hour you will have installed Power BI Desktop, a report will have been created and it will have been published on the web .
Read full review
Return on Investment
Amazon AWS
  • Reduce lots of setup and maintenance cost.
  • Latest technology in market.
  • Full eco system provided under on roof.
  • Cost effective.
Read full review
Microsoft
  • It helps us track and achieve company goals.
  • It shows us [our] performance in areas we could not previously track and allows us to see and work on how to improve their performance.
  • Quick easy access for executives to use in helping teams and addressing issues.
Read full review
ScreenShots

Microsoft Power BI Screenshots

Screenshot of Microsoft Power BI - Turns insights into impact for business usersScreenshot of Power BI integrates easily with Microsoft 365Screenshot of Microsoft Power BI - AI-Powered CapabilitiesScreenshot of Microsoft Power BI - Copilot can be used to create reportsScreenshot of Microsoft Power BI - Data HubScreenshot of Microsoft Power BI - Scales as organizational needs grow