What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
137 Ratings

Alteryx Analytics

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
137 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101
196 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

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

Power BI For Office 365

If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
Jeremiah Miller profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.4
Power BI For Office 365
8.6
Pixel Perfect reports
Alteryx Analytics
8.0
Power BI For Office 365
8.3
Customizable dashboards
Alteryx Analytics
5.3
Power BI For Office 365
8.9
Report Formatting Templates
Alteryx Analytics
9.0
Power BI For Office 365
8.7

Ad-hoc Reporting

Alteryx Analytics
7.9
Power BI For Office 365
8.6
Drill-down analysis
Alteryx Analytics
7.4
Power BI For Office 365
7.9
Formatting capabilities
Alteryx Analytics
7.4
Power BI For Office 365
7.9
Integration with R or other statistical packages
Alteryx Analytics
9.1
Power BI For Office 365
10.0
Report sharing and collaboration
Alteryx Analytics
7.7
Power BI For Office 365
8.6

Report Output and Scheduling

Alteryx Analytics
8.1
Power BI For Office 365
8.2
Publish to Web
Alteryx Analytics
8.0
Power BI For Office 365
8.7
Publish to PDF
Alteryx Analytics
7.3
Power BI For Office 365
8.6
Report Versioning
Alteryx Analytics
9.0
Power BI For Office 365
9.0
Report Delivery Scheduling
Alteryx Analytics
8.2
Power BI For Office 365
7.6
Delivery to Remote Servers
Alteryx Analytics
Power BI For Office 365
7.2

Data Discovery and Visualization

Alteryx Analytics
7.8
Power BI For Office 365
8.7
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
Power BI For Office 365
9.0
Location Analytics / Geographic Visualization
Alteryx Analytics
7.4
Power BI For Office 365
8.9
Predictive Analytics
Alteryx Analytics
8.0
Power BI For Office 365
8.3

Access Control and Security

Alteryx Analytics
8.3
Power BI For Office 365
9.0
Multi-User Support (named login)
Alteryx Analytics
8.0
Power BI For Office 365
9.3
Role-Based Security Model
Alteryx Analytics
8.0
Power BI For Office 365
9.3
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
Power BI For Office 365
8.2
Single Sign-On (SSO)
Alteryx Analytics
Power BI For Office 365
9.3

Mobile Capabilities

Alteryx Analytics
4.0
Power BI For Office 365
7.9
Responsive Design for Web Access
Alteryx Analytics
4.0
Power BI For Office 365
8.2
Dedicated iOS Application
Alteryx Analytics
Power BI For Office 365
8.0
Dedicated Android Application
Alteryx Analytics
Power BI For Office 365
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Alteryx Analytics
Power BI For Office 365
7.5

Application Program Interfaces (APIs) / Embedding

Alteryx Analytics
Power BI For Office 365
8.3
REST API
Alteryx Analytics
Power BI For Office 365
6.0
Javascript API
Alteryx Analytics
Power BI For Office 365
9.0
Themeable User Interface (UI)
Alteryx Analytics
Power BI For Office 365
9.0
Customizable Platform (Open Source)
Alteryx Analytics
Power BI For Office 365
9.0

Pros

Alteryx Analytics

  • 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

Power BI For Office 365

  • Beautiful visuals
  • Ease of use
  • Powerful data manipulation language
Richard Lorenz profile photo

Cons

Alteryx Analytics

  • Improve work flow in modules, sometimes buggy when dealing with multiple files
  • On-screen wizard could help demonstrate common best practices
  • Add more tools that could benefit the user without them having to create macros
Darrell Haley Jr. profile photo

Power BI For Office 365

  • I'd like to be able to use visuals based on different data sets in the same page.
  • The visuals are limited - I'd like to see a ribbon plot for example.
  • Would like to be able to use different data representations on the same visual. There's currently an ability to put lines on histograms but no ability to, for example, add points to a histogram or line plot. I understand some of these may be in development but you will never be able to create visuals for each possible combination. You need a way of combining two visuals into one - e.g. line and points.
  • DAX is very powerful but a bit complicated for some users. I think you need to make some of the functionality that's available in DAX exposed at the UI level.
  • The R visual gives the flexibility to plot a lot of stuff but it is limited by only being able to plot what's passed in the dataset.
  • You need a text entry box that you can filter datasets by.
Richard Lorenz profile photo

Likelihood to Renew

Alteryx Analytics

Alteryx Analytics 6.5
Based on 14 answers
I personally have moved to a different position that does not require data analysis tools. I really enjoyed working with Alteryx and think it is a great tool, but have moved to a different organization and role.
Mika Silverman profile photo

Power BI For Office 365

Power BI For Office 365 9.2
Based on 4 answers
It is a cheap way of exploring data and comes with the whole Office 2013 experience, including Sharepoint. For a new company, it is hard to find a better deal.
Eltjo Verweij profile photo

Usability

Alteryx Analytics

Alteryx Analytics 10.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

Power BI For Office 365

No score
No answers yet
No answers on this topic

Reliability and Availability

Alteryx Analytics

Alteryx Analytics 10.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

Power BI For Office 365

No score
No answers yet
No answers on this topic

Support

Alteryx Analytics

Alteryx Analytics 9.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

Power BI For Office 365

No score
No answers yet
No answers on this topic

Implementation

Alteryx Analytics

Alteryx Analytics 10.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

Power BI For Office 365

No score
No answers yet
No answers on this topic

Alternatives Considered

Alteryx Analytics

For analytics Alteryx outperforms others.
Nick Lensing profile photo

Power BI For Office 365

Tableau Desktop is a more mature product with more features but the price is what has stopped me going down this path.
Richard Lorenz profile photo

Return on Investment

Alteryx Analytics

  • The ease of use of this tool allows your data team to get off the ground quickly and efficiently.
No photo available

Power BI For Office 365

  • It's allowed us to better visualize large amounts of data.
  • It's an easy way to tie into an existing SQL database for users that don't know SQL.
No photo available

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.

Power BI For Office 365

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Power BI For Office 365 Editions & Modules

Power BI For Office 365
Additional Pricing Details

Add comparison