What users are saying about
Top Rated
119 Ratings
22 Ratings
Top Rated
119 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
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.
Susan Knolla profile photo

PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.9
PowerCenter
Pixel Perfect reports
Alteryx Analytics
8.0
PowerCenter
Customizable dashboards
Alteryx Analytics
6.7
PowerCenter
Report Formatting Templates
Alteryx Analytics
9.0
PowerCenter

Ad-hoc Reporting

Alteryx Analytics
8.5
PowerCenter
Drill-down analysis
Alteryx Analytics
8.3
PowerCenter
Formatting capabilities
Alteryx Analytics
8.2
PowerCenter
Integration with R or other statistical packages
Alteryx Analytics
9.5
PowerCenter
Report sharing and collaboration
Alteryx Analytics
8.0
PowerCenter

Report Output and Scheduling

Alteryx Analytics
8.7
PowerCenter
Publish to Web
Alteryx Analytics
8.2
PowerCenter
Publish to PDF
Alteryx Analytics
8.5
PowerCenter
Report Versioning
Alteryx Analytics
9.0
PowerCenter
Report Delivery Scheduling
Alteryx Analytics
8.9
PowerCenter

Data Discovery and Visualization

Alteryx Analytics
7.9
PowerCenter
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
PowerCenter
Location Analytics / Geographic Visualization
Alteryx Analytics
7.5
PowerCenter
Predictive Analytics
Alteryx Analytics
8.3
PowerCenter

Access Control and Security

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

Mobile Capabilities

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

Data Source Connection

Alteryx Analytics
PowerCenter
8.3
Connect to traditional data sources
Alteryx Analytics
PowerCenter
8.9
Connecto to Big Data and NoSQL
Alteryx Analytics
PowerCenter
7.6

Data Transformations

Alteryx Analytics
PowerCenter
8.7
Simple transformations
Alteryx Analytics
PowerCenter
8.6
Complex transformations
Alteryx Analytics
PowerCenter
8.9

Data Modeling

Alteryx Analytics
PowerCenter
7.0
Data model creation
Alteryx Analytics
PowerCenter
5.9
Metadata management
Alteryx Analytics
PowerCenter
7.4
Business rules and workflow
Alteryx Analytics
PowerCenter
6.8
Collaboration
Alteryx Analytics
PowerCenter
8.2
Testing and debugging
Alteryx Analytics
PowerCenter
6.9

Data Governance

Alteryx Analytics
PowerCenter
6.6
Integration with data quality tools
Alteryx Analytics
PowerCenter
6.8
Integration with MDM tools
Alteryx Analytics
PowerCenter
6.5

Pros

  • Excellent support for the tools through training/white papers and online support.
  • Ease of use - high common sense factor makes the program easy to learn and apply.
  • Compatibility with everything but specifically with commonly used key programs like Tableau.
Susan Knolla profile photo
  • PowerCenter connects to multiple sources and targets with ease, and at the same time.
  • PowerCenter allows the application of complicated business rule logic with ease through a user friendly interface.
  • PowerCenter logic can be captured and shared in mapplets, enabling reusability.
Brian Randolph profile photo

Cons

  • Cost is a factor - while support and training are "free" the software price is high.
  • It helps to have some good Excel experience to make instant adoption even easier.
  • The trainers tend to go a bit fast so slow learners may need multiple sessions.
Susan Knolla profile photo
  • Not worth doing simple data migration using powercenter.
  • Licensing cost.
  • Handling Blobs and clobs data types.
Sadu Kurahatti profile photo

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.
Mika Silverman profile photo
PowerCenter10.0
Based on 1 answer
It is a good, efficient product. Lots of developers are easily available in the market to perform the work.
Sadu Kurahatti 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
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

Alternatives Considered

I haven't used any other programs nor have I seen any that do this. I think it stands alone as a tool which allows such ease of use in data organizing and cleansing. While formulas or pivot tables in excel can help they are not easily repeatable across a variety of (dirty) data sources whereas Alteryx is.
Susan Knolla profile photo
  1. Powercenter provides lots of features to implement mapping rules.
  2. Very easy to design, develop and maintain ETL code.
  3. Easily integrate with its other products like IDQ and MDM.
Sadu Kurahatti profile photo

Return on Investment

  • Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
  • For visualization purposes I had to move the data to excel for some decent graphs.
  • It can become very expensive.
No photo available
  • It has a high ROI.
  • Overall very happy with the product.
  • Very useful in fulfilling business needs.
Sadu Kurahatti 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.

PowerCenter

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