Ease of use and ability to manipulate information. Use is fairly intuitive and and training video's give you ability to begin using pretty quickly. Have used to combine data sets remove duplicate information and extract needed data. The join capabilities of the product are effective and easy to use but you do need to be careful about how/what you are joining. It is easy to see the preliminary results and adjust as needed. Review collected by and hosted on G2.com.

Have had some problems with time outs in free version. Possibly could be related however to types of joins being performed. Unfortunately product goes off and runs for an extended period of time before informing you that the job has failed. Would be good if you received notification earlier in process that the job will fail. however you can tell pretty quickly when it is likely to fail after a few uses. Review collected by and hosted on G2.com.

I enjoy the accessibility, ease of use, modern graphic user interface, toolkit and how quickly it loads. It's really nice that the toolkit is done in plain english -- without too many formulas. I do wish it suggested some fixes here and there to the data -- I'd love to be able to preview if fuzzy matching worked before I added it as a step. I LOVE the dataset storage and clear dates -- sometimes I think it's easier to find uploads in Trifacta than it is to find them on my own computer. Joining is my favorite step process, I like the carnality being so easy to determine with estimates of matches being provided. Really love the graph previews in the table form. Likewise, I love that this is a cloud product I can log into from anywhere. Review collected by and hosted on G2.com.

Sometimes I feel the sales individuals are a bit spammy -- but it's not too terrible. I also dislike that sometimes jobs take quite sometime to complete for download / export, and then sometimes they fail entirely. Also, as a weird note, I find I am very lazy with naming conventions in the tool, and it makes me feel a bit disorganized when I open it up compared to other software tools as everything is just "flow 1", "flow 2" etc. I also dislike that I'm not even sure of it's full capabilities, I bet if I learned it better I'd use it a lot more. I don't really like that the job thing is a whole separate screen to monitor, I wish when the recipe was done, we could just export immediately. I'd definitely suggest that it'd be great if it recognized personal private information (like emails,) and offered to fuzz it or hex it immediately upon upload. Review collected by and hosted on G2.com.

Accordingly to specific our company, we worked with a lot of ETL's tools, include Trifacta.

The best features that we like here:

1) you can try to create transformation through small sample of data in 15 minutes

2) Trifacta will suggest best joins/unions/split, etc

3) After you get result you can easily replace data source and it will work Review collected by and hosted on G2.com.

It's not clear about how some functions operating, documentation is massive and very unclear.

High price, that's why we choose a different vendor in the end Review collected by and hosted on G2.com.

* easiness of complex data transformations

* smart suggestions that really help

* working with regex \ wrangle - is amazingly easy and fast

* parsing long natural language texts

* I like property grid Review collected by and hosted on G2.com.

* it is not always easy to find functions

* long onboarding with no suggestions in the UI

* some operations require too many mouse clicks, could be made more optimal Review collected by and hosted on G2.com.

The advanced text manipulation tools and the almost turing completeness Review collected by and hosted on G2.com.

while a great tool, the user story to go from data exploration to production could use additional development Review collected by and hosted on G2.com.

I appreciate that, although Trifacta requires some time to get to know it is user friendly to people who do not code as a profession. It has helped me to become comfortable with simple coding. Review collected by and hosted on G2.com.

I dislike the resample option. You are unable to see your entire dataset in trifacta and when looking at the summary of your columns often options are left unseen because they do not appear in your sample. Review collected by and hosted on G2.com.

In general I like the easiness of preparing data.

Formatting, Transforming or calculating data has never been easier.

Without even knowing programming languages, you are able to set up data transformations. Review collected by and hosted on G2.com.

I miss some connectors on Google Cloud platform for Dataprep.

Seeing the new updates, I believe there is being a lot of effort done on it at the moment Review collected by and hosted on G2.com.

Dataprep has a great user interface that makes it easy to inspect the data and to transform it. Pipelines are easy to set up and to understand thanks to the Flows UI. Easy to use for everyone, no programming skills needed. I also like the fact that pipelines are reusable and can be invoked via an API. Review collected by and hosted on G2.com.

Working with dates and international date formats in Dataprep is still a nightmare, e.g. if you want to convert date formats or check whether a date format is correct. I wish they used ISO date formats as a standard. Also, working with and switching between multiple accounts (on Google Cloud) is not well supported. Review collected by and hosted on G2.com.

Sleek interface, wonderful to be able to visualize the data and the changes made, easy to use and intuitive. Hints are super helpful and with a few clicks you can manipulate the data so easily. No more hidden data surprises. Review collected by and hosted on G2.com.

Honestly, there is nothing I don't like about this tool! It will be my number one choice for data prep every time! Review collected by and hosted on G2.com.

The tool is easy to use, without having to code, and without having to read a lot of documentation. Everything is quite intuitive.

Most of the needs for splicing, transformation, standardization are covered. Review collected by and hosted on G2.com.

Sometimes the tool is a little slow. Also the price model is likely to evolve towards something much less affordable. Review collected by and hosted on G2.com.