Alteryx Analytics vs Power BI For Office 365

Alteryx Analytics

More often than not, Alteryx can handle any situation or scenario thrown at it. Some may take a little more "trickery" along the way, but for the most part it is fairly easy to get from point A (data) to point B (results/report). And the nice thing is is that there is more than one way to produce the same result - two people with two different mindsets can ultimately create the same thing, but do so in a way that is better suited for their skill level.

Read full review

Cameron Tubbs

Senior Predictive Analyst

BuxtonMarket Research, 51-200 employees

View all 33 answers on this topic

Power BI For Office 365

We frequently use the mapping feature to overlay areas in which we have strong operations and areas in which our customers have needs to quickly visualize opportunities to new and existing clients. We are also beginning to develop internal scorecards with it. One downside is we haven't discovered a way to automate a data refresh from the SQL connection, so you have to remember to refresh the data (which can take a little while depending on how much data your looking for) every time.

Read full review

Verified User

Project Manager in Corporate

Transportation/Trucking/Railroad Company, 51-200 employees

View all 13 answers on this topic

Feature Rating Comparison

Alteryx Analytics

7.9

Power BI For Office 365

8.1

Pixel Perfect reports

8.0

Customizable dashboards

6.8

8.3

Report Formatting Templates

9.0

7.9

Alteryx Analytics

8.5

Power BI For Office 365

7.6

Drill-down analysis

8.3

7.3

Formatting capabilities

8.2

7.3

Integration with R or other statistical packages

9.5

7.9

Report sharing and collaboration

8.0

7.7

Alteryx Analytics

8.7

Power BI For Office 365

7.0

Publish to Web

8.2

8.4

Publish to PDF

8.5

8.0

Report Versioning

9.0

6.5

Report Delivery Scheduling

8.9

6.0

Delivery to Remote Servers

—

6.0

Alteryx Analytics

7.9

Power BI For Office 365

8.3

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

8.0

8.5

Location Analytics / Geographic Visualization

7.4

8.7

Predictive Analytics

8.2

7.9

Alteryx Analytics

8.3

Power BI For Office 365

8.5

Multi-User Support (named login)

8.0

8.7

Role-Based Security Model

8.0

8.7

Multiple Access Permission Levels (Create, Read, Delete)

9.0

7.7

Single Sign-On (SSO)

—

8.7

Alteryx Analytics

4.0

Power BI For Office 365

7.9

Responsive Design for Web Access

4.0

8.0

Dedicated iOS Application

—

8.0

Dedicated Android Application

—

8.0

Dashboard / Report / Visualization Interactivity on Mobile

—

7.4

Alteryx Analytics

—

Power BI For Office 365

6.0

REST API

—

6.0

Pros

User-friendly interface - the tool structure and general workspace are very easy to pick up on. Short learning curve from "no experience" to "beginner user".
Standardization - modules/wizards allow a single tool to generate results for multiple clients, all through the use of a few actions/inputs.
Analytics - wide range of statistical analytics tools makes it easy for a user to look at data and provide simple summary statistics, while also having the ability to build advanced regression models.

Read full review

Cameron Tubbs

Senior Predictive Analyst

BuxtonMarket Research, 51-200 employees

View all 33 answers on this topic

Ease of data import
Easy to learn the basic operation of the software

Read full review

Verified User

Project Manager in Corporate

Transportation/Trucking/Railroad Company, 51-200 employees

View all 13 answers on this topic

Cons

The visualization that Alteryx provides can be improved much more than where it stands tonight.
It doesn't seem to be able to process Big Data as efficiently as I would have liked.
There are a lot of things that you need to learn.

Read full review

Verified User

Engineer in Research & Development

Education Management Company, 11-50 employees

View all 33 answers on this topic

Like many Microsoft products, you can get by with a small understanding of the product, but to truly realize the entire potential does take a while to learn.
Hooking up SQL databases to the cloud version is a more complex than just querying right into the database from the desktop version.

Read full review

Verified User

Project Manager in Corporate

Transportation/Trucking/Railroad Company, 51-200 employees

View all 13 answers on this topic

Likelihood to Renew

Alteryx Analytics6.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 3659.2

Based on 4 answers

If I were a small business owner, I would likely use Power BI for Office 365 for the sheer fact that I would get the Office licensing I need, along with powerful capabilities. As a Microsoft Partner, we continue to see Microsoft invest heavily in the Power BI capabilities, and will continue to implement and support BI solutions around this product, as we believe this is in the best interest of our clients.

Read full review

Ken Raetz

Manager, DW/BI Services

LBMC Technologies, LLCInformation Technology and Services, 11-50 employees

View all 4 answers on this topic

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.

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

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

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

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

It has much more data connections and flexibility but writing queries manually is typically more flexible. It stacks up very high. Good data, Alteryx and Tableau, and a user can be prepared for an impromptu meeting and make a big impact. I haven't used anything like Alteryx for a direct comparison since they have a pretty unique piece of the market.

Read full review

Spencer Lewis

EDI Analyst

HID GlobalRetail, 5001-10,000 employees

View all 33 answers on this topic

Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible

Read full review

Daniel J. Lewis

System Administrator

vdiscoveryInformation Technology and Services, 51-200 employees

View all 13 answers on this topic

Return on Investment

Definitely, an increase in employee efficiency. With the right tools and hardware, Alteryx can reduce the processing time significantly.
Automation and/or automatic report scheduling frees up a lot of time that can be used elsewhere.
Licensing updates are somewhat not handled easily and quite often create issues with modules to run slowly and/or not being active.

Read full review

Verified User

Analyst in Other

Retail Company, 10,001+ employees

View all 33 answers on this topic