What users are saying about

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
630 Ratings
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 6 out of 101

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
630 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

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.
Megan Sullivan profile photo

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

Feature Rating Comparison

BI Standard Reporting

Amazon QuickSight
7.5
Microsoft BI
8.0
Pixel Perfect reports
Amazon QuickSight
10.0
Microsoft BI
7.9
Customizable dashboards
Amazon QuickSight
6.5
Microsoft BI
7.9
Report Formatting Templates
Amazon QuickSight
6.1
Microsoft BI
8.2

Ad-hoc Reporting

Amazon QuickSight
6.7
Microsoft BI
8.4
Drill-down analysis
Amazon QuickSight
7.3
Microsoft BI
8.2
Formatting capabilities
Amazon QuickSight
6.3
Microsoft BI
8.4
Report sharing and collaboration
Amazon QuickSight
6.5
Microsoft BI
8.9
Integration with R or other statistical packages
Amazon QuickSight
Microsoft BI
8.2

Report Output and Scheduling

Amazon QuickSight
5.5
Microsoft BI
8.2
Report Versioning
Amazon QuickSight
8.0
Microsoft BI
8.2
Report Delivery Scheduling
Amazon QuickSight
3.0
Microsoft BI
7.6
Publish to Web
Amazon QuickSight
Microsoft BI
8.3
Publish to PDF
Amazon QuickSight
Microsoft BI
8.8
Delivery to Remote Servers
Amazon QuickSight
Microsoft BI
8.2

Data Discovery and Visualization

Amazon QuickSight
8.0
Microsoft BI
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Amazon QuickSight
6.1
Microsoft BI
8.5
Location Analytics / Geographic Visualization
Amazon QuickSight
10.0
Microsoft BI
8.0
Predictive Analytics
Amazon QuickSight
Microsoft BI
8.1

Access Control and Security

Amazon QuickSight
6.5
Microsoft BI
8.4
Multi-User Support (named login)
Amazon QuickSight
8.2
Microsoft BI
8.4
Role-Based Security Model
Amazon QuickSight
6.9
Microsoft BI
8.1
Multiple Access Permission Levels (Create, Read, Delete)
Amazon QuickSight
6.9
Microsoft BI
8.6
Single Sign-On (SSO)
Amazon QuickSight
4.0
Microsoft BI
8.4

Mobile Capabilities

Amazon QuickSight
9.7
Microsoft BI
8.3
Responsive Design for Web Access
Amazon QuickSight
10.0
Microsoft BI
8.2
Dashboard / Report / Visualization Interactivity on Mobile
Amazon QuickSight
9.4
Microsoft BI
8.2
Dedicated iOS Application
Amazon QuickSight
Microsoft BI
8.4
Dedicated Android Application
Amazon QuickSight
Microsoft BI
8.1

Application Program Interfaces (APIs) / Embedding

Amazon QuickSight
Microsoft BI
7.9
REST API
Amazon QuickSight
Microsoft BI
7.9
Javascript API
Amazon QuickSight
Microsoft BI
8.3
iFrames
Amazon QuickSight
Microsoft BI
7.8
Java API
Amazon QuickSight
Microsoft BI
7.6
Themeable User Interface (UI)
Amazon QuickSight
Microsoft BI
7.9
Customizable Platform (Open Source)
Amazon QuickSight
Microsoft BI
7.6

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.
Megan Sullivan profile photo
  • EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
  • FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
  • FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.
Alexander Lubyansky profile photo

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.
Megan Sullivan profile photo
  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft BI8.0
Based on 25 answers
It is the best fit BI solution for a Microsoft shop - nobody else is even close on integration capabilities, feature set, and price at this point.
Sean Brady profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries. 2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI. It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend
Sean Warren profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

No score
No answers yet
No answers on this topic
Microsoft BI7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.
Sean Brady profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

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
Megan Sullivan profile photo
Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo

Return on Investment

No answers on this topic
  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

Pricing Details

Amazon QuickSight

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Amazon QuickSight Editions & Modules
Amazon QuickSight
Additional Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details