What users are saying about

Alteryx Analytics Gallery

13 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

602 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
7.8
Pixel Perfect reports
Alteryx Analytics Gallery
Microsoft BI
7.6
Customizable dashboards
Alteryx Analytics Gallery
Microsoft BI
7.9
Report Formatting Templates
Alteryx Analytics Gallery
Microsoft BI
7.8

Ad-hoc Reporting

Alteryx Analytics Gallery
Microsoft BI
8.5
Drill-down analysis
Alteryx Analytics Gallery
Microsoft BI
8.4
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.8

Report Output and Scheduling

Alteryx Analytics Gallery
Microsoft BI
8.4
Publish to Web
Alteryx Analytics Gallery
Microsoft BI
8.5
Publish to PDF
Alteryx Analytics Gallery
Microsoft BI
8.6
Report Versioning
Alteryx Analytics Gallery
Microsoft BI
8.7
Report Delivery Scheduling
Alteryx Analytics Gallery
Microsoft BI
7.9
Delivery to Remote Servers
Alteryx Analytics Gallery
Microsoft BI
8.1

Data Discovery and Visualization

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

Access Control and Security

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

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.6
Dedicated Android Application
Alteryx Analytics Gallery
Microsoft BI
8.2
Dashboard / Report / Visualization Interactivity on Mobile
Alteryx Analytics Gallery
Microsoft BI
8.1

Application Program Interfaces (APIs) / Embedding

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

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
  • The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI.
  • I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training.
  • I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to.
  • Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so.
  • Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI.
  • Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free.
  • Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.
Jason Leidig 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
  • 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
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.
Steve Wake profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky 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
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available

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

Breadth of Deployment

No answers on this topic
I have implemented Microsoft BI in small departments with less than 10 people all the way up to full enterprise deployments with multiple IT groups and 1000's of users. The only difference will be what of the provided Microsoft BI tools will you use and how many servers will it all be installed on. Once it is setup it is very easy to keep up-to-date and even expand in the future. Some of the tools do need more IT involvement to get up and running, but once it is setup and working it can easily go into a hands-off setup and just works. I have been oncall support for an enterprise SSRS deployment that was on multiple servers across multiple data centers and only received calls of issues once or month or less and most of time those were cause by human error and not following the procedures that were established.
Steve Wake 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

Collaboration and Sharing

Alteryx Analytics Gallery9.1
Based on 1 answer
The Gallery excels at sharing capabilities
Michael Wallendjack profile photo
Microsoft BI8.1
Based on 29 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Steve Wake profile photo

Data Integration

Alteryx Analytics Gallery9.1
Based on 1 answer
The Gallery, dependent on the either Alteryx Designer or Server can connect to a large number of data sources.
Michael Wallendjack profile photo
Microsoft BI8.6
Based on 28 answers
We integrate with SQL data and it has been very user-friendly in those aspects.
Jason Shaw profile photo

Return on Investment

No answers on this topic
  • My organization uses Microsoft BI for nearly all of our development. We would not be able to integrate with our clients to deliver our solutions easily without it.
Megan Juell 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