What users are saying about

Alteryx Analytics<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
110 Ratings

Microsoft BI<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

600 Ratings

Alteryx Analytics<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
110 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Microsoft BI<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

600 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

It is very well suited for mid-sized data operations. One person working on a project is ideal. I have not used Alteryx in a collaborative project, so can't say for sure. It is quite powerful and compares well with the competitors. If you have data from disparate sources, it helps to have a tool like Alteryx.
Sanket Bharaswadkar 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
7.6
Microsoft BI
7.8
Pixel Perfect reports
Alteryx Analytics
8.0
Microsoft BI
7.6
Customizable dashboards
Alteryx Analytics
5.8
Microsoft BI
8.0
Report Formatting Templates
Alteryx Analytics
9.0
Microsoft BI
7.8

Ad-hoc Reporting

Alteryx Analytics
8.5
Microsoft BI
8.5
Drill-down analysis
Alteryx Analytics
8.1
Microsoft BI
8.4
Formatting capabilities
Alteryx Analytics
8.2
Microsoft BI
8.4
Integration with R or other statistical packages
Alteryx Analytics
9.6
Microsoft BI
8.2
Report sharing and collaboration
Alteryx Analytics
7.9
Microsoft BI
8.8

Report Output and Scheduling

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

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.
  • Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.
  • Macros: have a process that you are consistently running in separate workflows? Build a macro, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
Joe Root profile photo
  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang profile photo

Cons

  • I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.
  • Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.
Joe Root profile photo
  • More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
  • UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
  • Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.
Alexander Lubyansky profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
The product fulfills business needs and it is a pleasure to work with the provider.
Nick Lensing profile photo
Microsoft BI8.0
Based on 25 answers
The primary reason I give this a 10 is because of my previous experience with Microsoft. While I can be effective with other tools and solutions, my experience is primarily focused on the Microsoft solution stack and surrounding tools. Some people are Java-centric, some are C#-centric; I am Microsoft SQL Server-centric. Even with the explosion of "big data" tools, I always seem to gravitate toward the Microsoft solution because I know and understand it better than any other solutions.
Chris Utter profile photo

Usability

Alteryx Analytics10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo
Microsoft BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

Reliability and Availability

Alteryx Analytics10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo
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

Alteryx Analytics9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo
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

Alteryx Analytics10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo
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

Our company kept it contained in the marketing department. Other departments may not understand it.
No photo available
Poorly adopted by users. Mostly caused by project priorities focused on technical aspect and not on reports and dashboards for final users.
Frederic Freyermuth ☁ profile photo

Alternatives Considered

For analytics Alteryx outperforms others.
Nick Lensing profile photo
Microsoft BI is alot more user friendly than SAP and allows for quicker interpretation of Data without having to go deep into the analysis of the data. All in all I would say that Microsoft BI fares far better on in the communication side and also the implementation side. The cost to use Microsoft BI is at an approrpriate level to justify a company's ability to adopt this software.
Brian Caulfield profile photo

Collaboration and Sharing

Alteryx Analytics7.2
Based on 16 answers
Other than being able to load my colleagues modules, I don't really use any other collaborative features in Alteryx.
Darrell Haley Jr. profile photo
Microsoft BI8.1
Based on 29 answers
Microsoft BI has built in security that allows for role based access depending on the needs of the end user. Report distribution works well and the ability to share a link to a visualization report is very handy to quickly disperse information quickly pulled out of a product and displayed through BI.
No photo available

Data Integration

Alteryx Analytics8.9
Based on 16 answers
  • Alteryx supports connectivity to a whole range of RDBMS applications, stand-alone files, and big data solutions
  • It's easy to create an ODBC connection and connect to almost anything available in the market
  • Alteryx has partnered with a range of third-party firms to build macros and customized connectors to products like SAP
  • Alteryx offers a range of data preparation tools like select, filter, join, union etc., that makes data preparation easy for the end users
No photo available
Microsoft BI8.6
Based on 28 answers
Microsoft BI allows for a large number of data sources to be imported and worked with easily. The data can be pulled real time or from a warehouse depending on the customer requirements. We did not pull data from a large number of disparate sources but multiple SQL databases can be connected to easily.
No photo available

Return on Investment

  • It gets the job done fast.
  • It lends itself well for people with a less-technical aptitude to understand the data process.
  • It empower the user to come up with any possible solution to a problem.
Nick Lensing profile photo
  • I would say making work easier for internal marketing reports is a great time saving activity in which Microsoft BI excels. Instead of downloading data manually from various sources, it integrates live data from applications.
Jasmeet S Babra profile photo

Pricing Details

Alteryx Analytics

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No
Alteryx Analytics Editions & Modules
Alteryx Analytics
On-premise Edition
Alteryx Designer
$3,9951
Alteryx Designer with Spatial
$12,9951
Alteryx Designer with Data
$29,9951
Alteryx Server
$45,0002
1. per user, per year
2. per server, per year
SaaS Edition
Alteryx Analytics Gallery
$1,5001
1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

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