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>
629 Ratings
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.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>
629 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

Alteryx Analytics Gallery

Alteryx Analytics Gallery is perhaps less suited if you need an immediate answer to a problem. Each use case requires some understanding of the workflow to implement.
Michael Wallendjack profile photo

Microsoft BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics Gallery
Microsoft BI
8.0
Pixel Perfect reports
Alteryx Analytics Gallery
Microsoft BI
7.9
Customizable dashboards
Alteryx Analytics Gallery
Microsoft BI
7.9
Report Formatting Templates
Alteryx Analytics Gallery
Microsoft BI
8.2

Ad-hoc Reporting

Alteryx Analytics Gallery
Microsoft BI
8.4
Drill-down analysis
Alteryx Analytics Gallery
Microsoft BI
8.2
Formatting capabilities
Alteryx Analytics Gallery
Microsoft BI
8.4
Integration with R or other statistical packages
Alteryx Analytics Gallery
Microsoft BI
8.2
Report sharing and collaboration
Alteryx Analytics Gallery
Microsoft BI
8.9

Report Output and Scheduling

Alteryx Analytics Gallery
Microsoft BI
8.2
Publish to Web
Alteryx Analytics Gallery
Microsoft BI
8.3
Publish to PDF
Alteryx Analytics Gallery
Microsoft BI
8.8
Report Versioning
Alteryx Analytics Gallery
Microsoft BI
8.2
Report Delivery Scheduling
Alteryx Analytics Gallery
Microsoft BI
7.6
Delivery to Remote Servers
Alteryx Analytics Gallery
Microsoft BI
8.2

Data Discovery and Visualization

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

Access Control and Security

Alteryx Analytics Gallery
Microsoft BI
8.4
Multi-User Support (named login)
Alteryx Analytics Gallery
Microsoft BI
8.4
Role-Based Security Model
Alteryx Analytics Gallery
Microsoft BI
8.2
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics Gallery
Microsoft BI
8.6
Single Sign-On (SSO)
Alteryx Analytics Gallery
Microsoft BI
8.4

Mobile Capabilities

Alteryx Analytics Gallery
Microsoft BI
8.3
Responsive Design for Web Access
Alteryx Analytics Gallery
Microsoft BI
8.2
Dedicated iOS Application
Alteryx Analytics Gallery
Microsoft BI
8.4
Dedicated Android Application
Alteryx Analytics Gallery
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
Alteryx Analytics Gallery
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Allows users to implement new ideas and workflows
  • Allows users to share solutions to business problems
  • Aides in knowledge transfer and thought leadership
Michael Wallendjack profile photo
  • Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
  • Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
  • Collaboration (via SharePoint only, before the release of Power BI Designer)
  • Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
  • Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
Lee Cullom profile photo

Cons

  • Due to the popularity of the Gallery, finding the exact solution to a problem may be difficult if the solution [isn't] titled correctly.
Michael Wallendjack profile photo
  • SQL Server Data Integration (also knows as SSIS) seems to provide most functionality you would expect from an ETL tool. However, when you start using it you quickly find out that most transformations perform slower than equivalent functionality when coded directly in SQL. So you go ahead with creating joins, using case statements and data type conversions directly in SQL input statements and potentially end up with a huge piece of code that performs nicely but is hardly maintainable in the future.
  • The development environment takes quite a while to get used to. Once you are all set up and doing your development work it is all fine but if you accidentally close some window or 'pane' just figuring out how to get it back can take quite some time.
Julia Gusman profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft BI8.0
Based on 25 answers
Microsoft is widely adopted and it does get the job done. For legal reasons, support perspective and resourcing it is often the tool of choice and, of course, the technology is there to support the day-to-day business.
Julia Gusman profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman 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
We are not currently utilizing Microsoft's technical support.
Robert Goodman 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
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

Alternatives Considered

No answers on this topic
Microsoft is a distant me too in a world that is crowded and drowning in BI Me too products. Visualizations 5/10. Micro Strategy, ClickView, Domo, BOBJ etc will kill this product. The issue is cost and speed to implementation. The cost is far less than any of the previously mentioned items. The implementation time could be a fraction of those products. The implementation of this product can be as simple as connecting Excel to the database (Create the relationships that you can do in the dbase or the query in Excel) and pushing to the Cloud. From the cloud based app you simply launch the gateway. The gateway is a breeze for anyone to connect with. The gateway only needs path back and its a breeze. No IT guys needed, no professional services, no firewalls or routing tables to configure. Just plug and play. This feature alone is the key product differentiation in my review. We already had the tables developed and ETL be damned, they all push from the MS-SQL dbase directly to cloud. Is this going to be big and fast in an environment with Data Universe's, API's to other products, and true Enterprise class features. I dont think so. Is it good enough for most small to medium companies or departments? Yes
Sean Warren 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

Alteryx Analytics Gallery

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Alteryx Analytics Gallery Editions & Modules
Alteryx Analytics Gallery
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