Impressive speed, scaling abilities and reliability

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

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.

Great product and great support

Pros

Being able to easily organize and stitch together multiple data sources. Also being able to automate scripts for updating data and to export data to a google sheet!

Cons

The UI-building and querying interface is daunting at first but after being familiarized with is very easy to use!

God-sent product

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