Alteryx Designer Cloud vs. Tableau Prep

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

If your data sets are coming in without much stewardship then Tableau Prep can help to clean the data before you start trying to create visualizations for your end users. You will save a lot of time this way - rather than seeing problems once you are creating dashboards. If you don't have large data sets or your data is relatively simple, then Tableau Prep may not be needed.

Incentivized

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

Incentivized

• Display the raw data coming in from the data warehouse
• Point out situations that might be erroneous
• Show the distribution of raw data figures

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

• Use of Macros within Workflow (and more types of automation)
• Join Editor also giving a SQL Update Query
• More types of visuals

Incentivized

It is a valuable tool for generating and cleaning files for multiple purposes.

Incentivized

It works well and is user friendly for the basics but needs more options for bring in data (using SQL queries for example) and export format options.

Incentivized

I have not really had to reach out for any kind of customer support for Tableau Prep, so I can't really say. However, the support that Tableau has given for their other products has been great, so I would assume it would be the same here. They are also constantly adding new features and providing software updates, and that is always a plus.

Incentivized

Live connections to cloud services (Google Sheets for example) and cloud hosted databases (cloud hosted SIS for example) for scheduled flows are not supported

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

Before Prep, we had to do all the data joining and connecting in a Tableau Workbook. Not only did this cause workbooks connected with live data to run frustratingly slowly, a new connection and set-up had to be established every time a new workbook as created, even if you were working with the same data. The extracts produced by Prep allow several workbooks to be working from the same data set-up without any additional work, saving time and stress.

Incentivized

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

• Quicker data sets for online reports
• More efficient data cleaning Ad Hoc reports
• Costly if using data management to schedule data pull and cleaning (priced per viewer accounts not creator accounts)

Incentivized