What users are saying about

Alteryx Analytics

Top Rated
111 Ratings

Prophix

Top Rated
116 Ratings

Alteryx Analytics

Top Rated
111 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

Prophix

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

Add comparison

Likelihood to Recommend

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.
Cameron Tubbs profile photo

Prophix

Most of these comments deal with the limitations of OLAP (Prophix) databases as compared to SQL (Oracle/SAP) databases. OLAP does a great job in driving management to prioritize those metrics and data they need to run and measure their business. This education leads to a much better understanding of the data being provided. A transaction level database is better suited to detailed analysis, but management (in my experience) does a poor job at trying to manage individual transactions instead of understanding what the aggregated numbers are saying. Also, management can not plan at a highly detailed level because the business is moving too fast. That is where Prophix (OLAP) allows management to create a plan at the right level of detail which can be reported and managed.More well suited:
  • Multiple scenario reporting
  • Excel template generation
  • Finance ownership and management - takes some training but well worth the flexibility
  • Finance, Sales, Operations
Less well suited:
  • Highly detailed reporting outside of Detailed Planning Manager
  • Direct Excel - SSAS data retrieval
  • HR employee management
  • Transaction level detail analysis
Andreas Loeffler profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.6
Prophix
Pixel Perfect reports
Alteryx Analytics
8.0
Prophix
Customizable dashboards
Alteryx Analytics
5.8
Prophix
Report Formatting Templates
Alteryx Analytics
9.0
Prophix

Ad-hoc Reporting

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

Report Output and Scheduling

Alteryx Analytics
8.6
Prophix
Publish to Web
Alteryx Analytics
8.0
Prophix
Publish to PDF
Alteryx Analytics
8.6
Prophix
Report Versioning
Alteryx Analytics
9.0
Prophix
Report Delivery Scheduling
Alteryx Analytics
8.9
Prophix

Data Discovery and Visualization

Alteryx Analytics
8.1
Prophix
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
Prophix
Location Analytics / Geographic Visualization
Alteryx Analytics
7.7
Prophix
Predictive Analytics
Alteryx Analytics
8.7
Prophix

Access Control and Security

Alteryx Analytics
8.3
Prophix
Multi-User Support (named login)
Alteryx Analytics
8.0
Prophix
Role-Based Security Model
Alteryx Analytics
8.0
Prophix
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
Prophix

Mobile Capabilities

Alteryx Analytics
4.0
Prophix
Responsive Design for Web Access
Alteryx Analytics
4.0
Prophix

Budgeting, Planning, and Forecasting

Alteryx Analytics
Prophix
7.9
Long-term financial planning
Alteryx Analytics
Prophix
7.6
Financial budgeting
Alteryx Analytics
Prophix
8.4
Forecasting
Alteryx Analytics
Prophix
7.8
Scenario modeling
Alteryx Analytics
Prophix
7.5
Management reporting
Alteryx Analytics
Prophix
8.1

Consolidation and Close

Alteryx Analytics
Prophix
8.0
Financial data consolidation
Alteryx Analytics
Prophix
8.2
Journal entries and reports
Alteryx Analytics
Prophix
7.5
Multi-currency management
Alteryx Analytics
Prophix
8.1
Intercompany Eliminations
Alteryx Analytics
Prophix
8.3
Minority Ownership
Alteryx Analytics
Prophix
8.4
Local and consolidated reporting
Alteryx Analytics
Prophix
8.3
Detailed Audit Trails
Alteryx Analytics
Prophix
7.4

FInancial Reporting and Compliance

Alteryx Analytics
Prophix
7.8
Financial Statement Reporting
Alteryx Analytics
Prophix
8.4
Management Reporting
Alteryx Analytics
Prophix
8.2
Excel-based Reporting
Alteryx Analytics
Prophix
7.8
Automated board and financial reporting
Alteryx Analytics
Prophix
7.7
XBRL support for regulatory filing
Alteryx Analytics
Prophix
6.7

Analytics

Alteryx Analytics
Prophix
7.6
Personalized dashboards
Alteryx Analytics
Prophix
7.3
Color-coded scorecards
Alteryx Analytics
Prophix
7.3
KPIs
Alteryx Analytics
Prophix
7.6
Cost and profitability analysis
Alteryx Analytics
Prophix
7.5
Key Performance Indicator setting
Alteryx Analytics
Prophix
7.6
Benchmarking with external data
Alteryx Analytics
Prophix
8.0

Integration

Alteryx Analytics
Prophix
8.2
Flat file integration
Alteryx Analytics
Prophix
8.4
Excel data integration
Alteryx Analytics
Prophix
8.2
Direct links to 3rd-party data sources
Alteryx Analytics
Prophix
7.9

Pros

  • Cleaning datasets
  • Preparing data for analyzing
  • Customer data analytics
  • Transforming data from one format to other
Sanket Bharaswadkar profile photo
  • One of the biggest issues we had with our excel budgets was formula's that linked multiple tabs and/or workbooks together either being wrong or getting written over. In Prohpix you write the formula once in the account structure and it cannot be broken by end users.
  • Access rights are granted by users, so we are able to build one sales template for all of our reps to enter budgets and view reports, but they only are able to view the customers assigned to them. This makes updating easy as it all in once place.
  • Prohpix connects direclty through SQL to our ERP data, and thus we are able to schedule automatic nightly imports of that days invoices. Every morning sales can access their updated results on-demand, or we can schedule Prophix to distribute it automatically to those who prefer that.
  • Flexibility in data presentation. Ad-hoc reporting ability allows us to build a data view in Prophix in seconds during a meeting that would take an hour or more to generate all the different reports in our ERP and then consolidate them in excel and still not have the flexibility the cube structure offers.
  • We operate in numerous currencies, Prophix has the ability to create multiple scenarios that we can use a different currency rate on each for our best case vs worst case currency rate analysis to be able to pick one for use on our budget.
Trevor Booth profile photo

Cons

  • Poor documentation
  • Costly
  • Overkill for simple tasks
  • Not many options for data visualization
Sanket Bharaswadkar profile photo
  • Drill Across to transaction detail is dependent on the customer's technical ability and capacity to export from ERP to tables. Prophix Consulting should invest in an expertise and service offering to make Drill Across work by fetching transactions directly from the ERP tables themselves. We have a wide user group that views Drill Across Journal Line detail, but must move into inadequate ERP functionality in order to see further into transactions.
  • There should be what if Organization hierarchies for Planning and Forecasting (Alternate Hierarchies based on update of individual member properties is too hard to maintain) .
  • Work Flow Activities and underlying Tasks should be movable by drag and drop and the Task due dates should, optionally be set as business days before or after the start of the month. Without that the due dates are requiring review and refinement each month to allow for weekend and holidays.
  • Rolling 12 month Time Perspective member should come standard.
  • Prophix Consulting has advised that a combination of sales by product and customer is just too much to handle. This is an important dimension combination not to have in the model.
Carl Evans profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
I will likely continue to use Alteryx because it allows quick, customizable data analysis. Often, I will be given a business question, which I might not know how to answer, but after getting into Alteryx, dragging and dropping some tools, I can formulate the answer. At the same time, this is definitely a niche software (not something that would ever be adopted by my entire company), which makes it a bit less appealing to some.
No photo available
Prophix10.0
Based on 16 answers
  • Ease of use
  • Dimension hierarchy flexibility
  • Responsive and personalized customer support
  • Ad Hoc ability
Carl Evans 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
Prophix8.4
Based on 13 answers
Easy to learn the basic functionality including reporting and hierarchy maintenance.
Rob Strothkamp profile photo

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
Prophix8.5
Based on 6 answers
We rarely encounter application errors or outages
Rob Strothkamp profile photo

Performance

No score
No answers yet
No answers on this topic
Prophix7.7
Based on 6 answers
Prophix continues to improve upon the performance of its product with reports and processes running more efficiently with all new releases.
Joel P. Goldstein 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
Prophix7.9
Based on 54 answers
Support is responsive and can typically help to resolve issues.
Kendra Graves profile photo

Online Training

No score
No answers yet
No answers on this topic
Prophix7.3
Based on 2 answers
Online training not company specific
Rob Strothkamp 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
Prophix8.8
Based on 8 answers
Very professional, took their time to understand the company and the business requirements
Brett Newsome profile photo

Breadth of Deployment

Our company kept it contained in the marketing department. Other departments may not understand it.
No photo available
No answers on this topic

Alternatives Considered

Although microstrategy is a good tool, Alteryx is a unique tool in terms of providing such capabilities.
Rishi Bavishi, CSSGB, CAPM profile photo
Prophix modeling is more flexible and customer support is more responsive. End users are empowered with ease of functionality that is lacking in the bigger brands. Design is more attentive to user feedback.
Carl Evans profile photo

Collaboration and Sharing

Alteryx Analytics7.2
Based on 16 answers
There are some formats that need to be worked on in Alteryx for example using "%" in reporting as you have to go through few extra steps to build such special characters and it makes it a little annoying. It also needs a small fix on when you share data in emails to make it better visualized.
Rishi Bavishi, CSSGB, CAPM profile photo
No score
No answers yet
No answers on this topic

Data Integration

Alteryx Analytics8.9
Based on 16 answers
Merging data is easiest among any platform I’ve used. The data sources available is broad and I understand Alteryx is constantly adding to the sources of data used by their customers. I particularly like the ability to schedule reports out of Alteryx. This makes it valuable as tool to do research and ad hoc analysis but also reduce the time spent actually running and delivering reports pre-built
Spencer Lewis profile photo
No score
No answers yet
No answers on this topic

Scalability

No score
No answers yet
No answers on this topic
Prophix8.0
Based on 4 answers
We are a medium sized company, but the structure of Prophix would seemingly adapt to whatever sized organization you have. It also can be applied in any area of an enterprise that needs performance management, whether it involves financial data or not. The potential for application within the enterprise is really only limited by you imagination.
Kevin Warnick profile photo

Return on Investment

  • Faster data processes (appending various data)
  • Non-gis people have been able to to geocode/build trade areas (this is positive and negative)
  • Quickly generate a standardized way of research processes
No photo available
  • Pushing back department budget due dates since managers enter data directly to the database and the time to manually accumulate data is eliminated
  • All users are using the same data eliminating opportunity for differing assumptions
  • Prophix provided a platform to easily create reports and share data used to make decisions
  • Multiple users have access to information, understand models and can analyze their own data
  • Users are more self-sufficient and do not have to rely on the accounting department to obtain information
Kendra Graves 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.

Alteryx Analytics More Information

Prophix

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
Prophix Editions & Modules
Prophix
Additional Pricing Details

Prophix More Information