Alteryx Designer Cloud vs. Paxata

For doing ETL and data transformations where your data is already in a cloud environment Alteryx Designer Cloud is ideal. It allows for the continued democratisation of data and analytics to permeate more extensively throughout a business, particularly those that are already in the cloud or have cloud services in place and are comfortable with procurement and consumption of these systems over and above desktop software. The ETL processing for data validation and wrangling uses machine learning to enable highly efficient data manipulation which saves lots of time and this is a distinct advantage over the desktop software. The expansion and integration of other Alteryx cloud services such as ML, Metrics Store and App builder will only strengthen this position

Paxata can be highly useful to someone who doesn't like/have any experience with writing codes to treat data before using it as input into BI dashboards. Paxata can accelerate data cleaning in environments where a large amount of unclean data is generated and business decisions on the go are required. It performs really well while dealing with natural language.

Incentivized

• Gives automatic options for code.
• Allows for notes on code.
• Duplicates work and allows for repurposing work.

Incentivized

• Visualize distributions in large data sets effectively which enable the user to quickly spot outliers and treat them appropriately
• Provides recommendation to merge datasets based on matching column values
• The cluster and edit feature in my opinion is its most powerful feature and reduces cardinality in column with text

Incentivized

• Hadoop source data tables are presented in a flat searchable list but I would rather see them in the native hierarchy.
• Web interface can be flaky. We often need to refresh the page.

Incentivized

• Doesn't provide recommendation on how to impute values
• There is a lag quite often
• We can say whether a column has errors or quality issues in the first look

Incentivized

Our IT group presented Trifacta to me. They picked it out and among the crowd for me. This was way beyond ETL tools, SQL, or any programming language. It's just much faster and because it's sitting on Hadoop you bypass some of the slowdowns typically faced with RDBMS.

Incentivized

Paxata is a much better tool when it comes to handling natural language but Talend provides recommendations on how to impute missing values and outliers. Paxata provides recommendations on dataset tie-ups and joins but Talend doesn't provide any such recommendations. In paxata you can visualize distribution of data in a column and filter them by dragging and selecting the section you'd like to retain

Incentivized

• Increased productvity by 5x
• Reduced costs of running and patching desktop and server based software entirely

• It saves time to clean data
• It reduces the requirement of too many data engineer/stewards and hence adds positive impact on the return of the business

Incentivized