Y42

Impressive speed, scaling abilities and reliability

Comments: We are using y42 to handle the Data of over one hundred sources. The probability of errors and failures happening in our processes of transforming and cleaning data is relatively high and there have been many issues with other tools we used for this task before. With y42, there were no system issues or bugs that stopped our pipelines from working. This is really the game-changer for us.

Pros:

Speed: The tool is incredibly fast, since it is running on BigQuery Data and Data previews are calculated with a sample. Most previews are ready in less than 10 seconds. I was also able to build the above flow while traveling by train, using only my iPhone hotspot. Quality of Data: The Data I am getting for Facebook Ads is exactly what Facebook provides. So I can just use the Facebook documentation and also got access to a lot of information that Supermetrics e.g. does not provide. Although this information is not critical, it is quite nice. Really easy handling of JSON Objects: They even got an integrated JSON visualizer so you don’t need to copy and paste the Objects somewhere. Also there is a JSON flattening option for the Import and a really handy way of extracting and transforming Information from JSON Objects.

Cons:

Since the software is being developed so fast, there are some minor bugs from time to time. However, none of those caused the data to be off, because most of them were only happening in the user interface. This makes y42 one of the most reliable tools that I have ever used in this area.

Great product and support/dev team

Pros:

Brilliant and ongoing support from the team, who is always interested and on top of any requests. The tool itself is quick to set up, update, and refresh. Although I'm familiar with data, y42 made the process of integrating, modelling, and visualising data a lot easier and faster.

Cons:

Some integrations for our specific needs were missing - but the support team was brilliant and implemented promptly. Also, we had one or two glitches, but these never caused the data to be off as they happened in the user interface. It would be good to have more case studies and pre-built models.

Almost like Plug and Play

Comments: Very happy with the solution, as an early stage company you need to be mindful where to hire and with Y42 we have a good solution to start right away with data modelling and can skipt the part where we look for an full time engineer to programm all connectors.

Pros:

Easy to set up data connectors and import various sources. As a total beginner to modelling and ETLs it was super easy to create the first joins and multiple transformations. The support is helpful and responding quickly.

Cons:

Some nodes and features still need some finetuning when it comes to namings and how to's (eg. unpivot). Really looking forward to more alerting options for data quality checks and auto exports to email or gdrive. This is so far still rather manual.

highly flexible data lake tool with great customer service

Pros:

broad & easy integration of various data sources, data cleaning, modeling, analysis & automation. Customer Service goes above and beyond to help!

Cons:

visualization and output works well but is still limited in terms of capabilities

God-sent product

Comments: It helps me a lot in gathering all financial information gathered from all portfolio companies, normalize them, and put them in one place

Pros:

They had all the integrations I needed to craft my financial reports. Furthermore, I had a visual workflow tool that could display where my data come from, get transformed, and then sent to, which helped me a lot in building pipelines and debugging.

Cons:

I wish they had more application where I can send some alerts too, especially Slack triggering was missing