Amazon QuickSight vs Microsoft Power BI

Amazon QuickSight

Amazon QuickSight is well suited in any organization that is making business decisions based on performance data whether it be Marketing, Sales, Call Center, etc. It is a great tool especially for mature organizations that have a lot of data to work with. Amazon QuickSight may be not as well suited for newer organizations that are just beginning to drive data/performance metrics. The data available becomes more and more valuable to more that you have.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Microsoft Power BI

Power BI is great at dynamically reflecting real time data. It has wonderful views of data and can narrate a story that is powerful and impressive. Decisions can be made on the overall visuals shown. BI can show you where your sales are picking up while showing you areas to focus on. The quality of your BI dashboard tremendously improves with the overall quality of your incoming data. BI has great capability to share results across the organization in a secure and safe way in almost any computer platform. Mobile phones welcome too!

Read full review

Verified User

Employee in Finance and Accounting

Medical Devices Company, 51-200 employees

View all 52 answers on this topic

Feature Rating Comparison

Amazon QuickSight

7.4

Microsoft Power BI

8.1

Pixel Perfect reports

10.0

7.8

Customizable dashboards

6.3

8.5

Report Formatting Templates

5.8

8.0

Amazon QuickSight

6.5

Microsoft Power BI

8.2

Drill-down analysis

7.2

8.4

Formatting capabilities

6.2

8.2

Report sharing and collaboration

6.3

8.3

Integration with R or other statistical packages

—

8.0

Amazon QuickSight

5.5

Microsoft Power BI

7.9

Report Versioning

8.0

7.7

Report Delivery Scheduling

3.0

7.7

Publish to Web

—

8.9

Publish to PDF

—

7.9

Delivery to Remote Servers

—

7.5

Amazon QuickSight

7.9

Microsoft Power BI

8.2

Pre-built visualization formats (heatmaps, scatter plots etc.)

5.8

8.6

Location Analytics / Geographic Visualization

10.0

8.7

Predictive Analytics

—

7.5

Amazon QuickSight

6.4

Microsoft Power BI

8.0

Multi-User Support (named login)

8.1

8.2

Role-Based Security Model

6.7

7.3

Multiple Access Permission Levels (Create, Read, Delete)

6.7

7.9

Single Sign-On (SSO)

4.0

8.4

Amazon QuickSight

9.7

Microsoft Power BI

8.0

Responsive Design for Web Access

10.0

8.1

Dashboard / Report / Visualization Interactivity on Mobile

9.5

8.0

Dedicated iOS Application

—

8.0

Dedicated Android Application

—

8.0

Amazon QuickSight

—

Microsoft Power BI

7.2

REST API

—

7.7

Javascript API

—

7.5

iFrames

—

7.1

Java API

—

6.5

Themeable User Interface (UI)

—

7.4

Customizable Platform (Open Source)

—

6.9

Pros

Amazon QuickSight is a really easy program to learn how to use.
Amazon QuickSight allows our team to customize the data using the various data sets, which makes the available reports incredibly powerful to our organization.
Our organization has the ability continually adjust our reports and build new reports as business needs change.
Even though our organization has different reports built for different departments, each department can still access and understand reports from across the company.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Data blending from several different files is a big hit with our Power BI users. We have so many excel and CSV files and many of them are not clean, so making use of the data cleaning and blending saves us from countless pivots and lookups to just get data worthy of analyzing.
The visualizations are top notch, and available without additional cost. Everything is in vibrant colors and crisp, clear lines that whatever your produce is clearly pleasing to the eye. From mapping down to pie charts, the visuals are well done.
The Beta preview is very helpful, not all software allows you to preview or use things in beta, but Power BI has a wonderful set of tools and visualizations you can add into your work with very little effort or complexity.

Read full review

Verified User

Manager in Finance and Accounting

Consumer Goods Company, 10,001+ employees

View all 52 answers on this topic

Cons

One of the primary challenges I've had with Amazon QuickSight so far is that some of the reports I want to build use data from different data sets. Instead of being able to put all of the information I want to see into one report.
Some of our Amazon QuickSight reports only update every 24 hours. It would be great to see that data in real-time.
I would remove the various time zones from Amazon QuickSight and only use the time zone we are in.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Connectivity with non-Microsoft tools: Power BI is great to integrate with other MS tools, but if you want to connect it with statistical or machine learning tools (R, Python, Mathlab, JMP, etc.) you might get in trouble. Tableau, for example, has an easy integration with R and Python.
Not all features are available in the online version: If you want to use more advanced features, you will probably need to download the desktop version of Power BI.
No desktop version for Mac: So, I use a Mac and I needed to use some extra features on Power BI. When I tried to download the more complete desktop version, I realized that there's no desktop version of Power BI for Mac! I had to borrow a PC from a colleague to run the analysis I wanted.

Read full review

Gabriel Chiararia

Marketing Consultant

Brigham Young University Marriott School of BusinessConsumer Electronics, 201-500 employees

View all 52 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

Ask the community to sound off

Microsoft Power BI10.0

Based on 1 answer

I find it helpful and easy to use

Read full review

jim paroly

Freelance Photographer

j. paroly photoGraphic Design, 1-10 employees

View all 1 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Ask the community to sound off

Microsoft Power BI8.8

Based on 3 answers

PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts

Read full review

Rohit Acharya

Business Intelligence Manager

ZALORA GroupInternet, 1001-5000 employees

View all 3 answers on this topic

Alternatives Considered

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

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Power BI is usually the cheapest solution and most user-friendly for most people (since we are all used to the Microsoft Suite). However the connectivity to non-Microsoft soft tools (databases and data analysis tools) are somewhat limited, especially when compared to its biggest competitor: Tableau.

Read full review

Gabriel Chiararia

Marketing Consultant

Brigham Young University Marriott School of BusinessConsumer Electronics, 201-500 employees

View all 52 answers on this topic

Amazon QuickSight5.8

Based on 2 answers

There are many members across my organization that use the QuickSight reports throughout each business day. There are various reports built for various departments as well as reports that cross over to all departments. There have not been any issues across the various departments with viewing the reports and using unique filters to look at the reports differently. Our IT department is the only department within the organization that has the necessary permissions to create new reports and/or make changes to existing reports

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Microsoft Power BI8.2

Based on 49 answers

Microsoft Power BI needs to develop a dedicated portal like Tableau Online to host different dashboards. All users need to login to access the dashboard, data level security needs to be implemented on a more robust scale. Downloading of data from the dashboard is difficult. PBI offers iframe code which can easily be hosted on an internal portal for everyone to access. However, the data needs to be public and if security is needed then we would have to implement SSO based security or any other form of security on our own (this will prevent logging in to PBI to view reports)

Read full review

Rohit Acharya

Business Intelligence Manager

ZALORA GroupInternet, 1001-5000 employees

View all 49 answers on this topic

Data Integration

Amazon QuickSight7.5

Based on 2 answers

All of the data that feeds into Amazon QuickSight comes from our CRM, Clarity. We do not have data coming in from any other sources. Some of the data that comes in is in real-time and some of the data only updates every 24 hours. Overall, the API feed of data seems to be very seamless and there have not been any hiccups in the feed.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 2 answers on this topic

Microsoft Power BI8.3

Based on 48 answers

Microsoft Power BI can connect to most prominent databases such as Amazon Redshift, MySQL, Oracle, Teradata etc. The live data streams are still not robust and face lags and breakdowns frequently especially with redshift. Power BI and excel go hand in hand and offer interoperability. Flat files and other text file sources can easily be connected. PBI distinguishes itself from other tools by connecting to online service apps like Salesforce, SharePoint, QuickBooks and other services.

Read full review

Rohit Acharya

Business Intelligence Manager

ZALORA GroupInternet, 1001-5000 employees

View all 48 answers on this topic

Return on Investment

No answers on this topic

Ask the community to sound off

It's a good start for setting up customized dashboards.
Available for all users based on Office 365 platform we have in place.
Doesn't really allow depth of report - specifically customization of visual displays.

Read full review

Mark Metz

Enterprise Services Consultant

Bristol-Myers SquibbPharmaceuticals, 10,001+ employees

View all 52 answers on this topic