Alteryx Analytics vs Power BI For Office 365

Likelihood to Recommend

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.

Read full review

Sanket Bharaswadkar

Process Analyst

HoneywellWarehousing, 10,001+ employees

View all 37 answers on this topic

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.

Read full review

Jeremiah Miller

Associate Director IT Infrastructure

Mennonite Central CommitteeNon-Profit Organization Management, 1001-5000 employees

View all 14 answers on this topic

Feature Rating Comparison

Alteryx Analytics

7.4

Power BI For Office 365

8.6

Pixel Perfect reports

8.0

8.3

Customizable dashboards

5.3

8.9

Report Formatting Templates

9.0

8.7

Alteryx Analytics

7.9

Power BI For Office 365

8.6

Drill-down analysis

7.4

7.9

Formatting capabilities

7.4

7.9

Integration with R or other statistical packages

9.1

10.0

Report sharing and collaboration

7.7

8.6

Alteryx Analytics

8.1

Power BI For Office 365

8.2

Publish to Web

8.0

8.7

Publish to PDF

7.3

8.6

Report Versioning

9.0

Report Delivery Scheduling

8.2

7.6

Delivery to Remote Servers

—

7.2

Alteryx Analytics

7.8

Power BI For Office 365

8.7

Pre-built visualization formats (heatmaps, scatter plots etc.)

8.0

9.0

Location Analytics / Geographic Visualization

7.4

8.9

Predictive Analytics

8.0

8.3

Alteryx Analytics

8.3

Power BI For Office 365

9.0

Multi-User Support (named login)

8.0

9.3

Role-Based Security Model

8.0

9.3

Multiple Access Permission Levels (Create, Read, Delete)

9.0

8.2

Single Sign-On (SSO)

—

9.3

Alteryx Analytics

4.0

Power BI For Office 365

7.9

Responsive Design for Web Access

4.0

8.2

Dedicated iOS Application

—

8.0

Dedicated Android Application

—

8.0

Dashboard / Report / Visualization Interactivity on Mobile

—

7.5

Alteryx Analytics

—

Power BI For Office 365

8.3

REST API

—

6.0

Javascript API

—

9.0

Themeable User Interface (UI)

—

9.0

Customizable Platform (Open Source)

—

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

Read full review

Joe Root

Marketing Technology & Intelligence Program Manager

Cradlepoint, Inc.Computer Networking, 501-1000 employees

View all 37 answers on this topic

Beautiful visuals
Ease of use
Powerful data manipulation language

Read full review

Richard Lorenz

Manager of Compliance and Business Performance

Computershare AustraliaFinancial Services, 10,001+ employees

View all 14 answers on this topic

Cons

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

Read full review

Darrell Haley Jr.

Associate Program Manager

IDM, Inc.Marketing and Advertising, 51-200 employees

View all 37 answers on this topic

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.

Read full review

Richard Lorenz

Manager of Compliance and Business Performance

Computershare AustraliaFinancial Services, 10,001+ employees

View all 14 answers on this topic

Likelihood to Renew

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.

Read full review

Mika Silverman

Consultant

MarineXchange SoftwareInformation Technology and Services, 11-50 employees

View all 14 answers on this topic

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.

Read full review

Eltjo Verweij

Data Analyst

Vierzicht.nlLogistics and Supply Chain, 51-200 employees

View all 4 answers on this topic

Usability

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.

Read full review

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Reliability and Availability

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.

Read full review

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Support

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

Read full review

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Implementation

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.

Read full review

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Alternatives Considered

For analytics Alteryx outperforms others.

Read full review

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

View all 37 answers on this topic

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

Read full review

Richard Lorenz

Manager of Compliance and Business Performance

Computershare AustraliaFinancial Services, 10,001+ employees

View all 14 answers on this topic

Return on Investment

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

Read full review

Verified User

Technician in Information Technology

Marketing and Advertising Company, 51-200 employees

View all 37 answers on this topic

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.

Read full review

Verified User

Project Manager in Corporate

Transportation/Trucking/Railroad Company, 51-200 employees

View all 14 answers on this topic

Likelihood to Recommend