About Y42

Y42 is the only easy yet scalable business intelligence platform for loading, transforming, connecting, visualizing and sharing data, offering both no-code and SQL.

The end-to-end tool can be 100% UI-operated and runs a state-of-the-art data stack (e.g. BigQuery, Airflow) under the hood, enabling savvy business users and engineers alike to set up scalable data pipelines and automated reporting.

Y42 isn't just another data silo; it sits on top of the customer's own BigQuery data warehouse and writes clean code in the background when operated through the user interface.

Drag and drop data modeling and visual data lineage features guarantee that you never have to ask yourself again whether your business went south or just your reporting.

The no-code approach makes Y42 the tool of choice for many growing eCommerce and DTC brands that have to merge and analyze huge amounts of data from various sources without relying on hard-to-find data engineers.

Pricing starting from:

€849.00/month

  • Free Version
  • Free Trial
  • Subscription

Key benefits of Y42

Adapts to your use case
It's easy to measure everything yet learn nothing. We set up Y42 for your data use case and business model, applying industry best practices.

No more leaky data pipelines
Track every number back to its source with one click instead of dissecting SQL code. Never ask yourself again whether your business went south or just your reporting.

Own your data process
Your data is too important an asset to be in the hands of others. Y42 sits on top of your own data warehouse so you remain in control.

Up and running in days
We connect all your data and start building reports without a lengthy IT project. There are no hidden costs.

Devices

Business size

S M L

Markets

Austria, Switzerland, Germany, United Kingdom, Netherlands, United States

Supported Languages

English

Pricing starting from:

€849.00/month

  • Free Version
  • Free Trial
  • Subscription

Images

Y42 Software - Drag & drop data visualization & dashboards
Y42 Software - Unparalleled transparency through data lineage (visualization of data flows)
Y42 Software - Turnkey connectors for > 100 data sources
Y42 Software - Drag & drop data modeling and transformation, writing clean SQL into your own data warehouse
Y42 Software - Out-of-the-box reports tailored to your industry and use case
View 6 more
Y42 video
Y42 video
Y42 video
Y42 video
Y42 video
Y42 Software - Drag & drop data visualization & dashboards Y42 Software - Unparalleled transparency through data lineage (visualization of data flows) Y42 Software - Turnkey connectors for > 100 data sources Y42 Software - Drag & drop data modeling and transformation, writing clean SQL into your own data warehouse Y42 Software - Out-of-the-box reports tailored to your industry and use case

Features

Total features of Y42: 60

  • API
  • Access Controls/Permissions
  • Alerts/Notifications
  • Charting
  • Collaboration Tools
  • Customer Database
  • Customisable Dashboard
  • Customisable Reports
  • Customisable Templates
  • Customization
  • Dashboard
  • Dashboard Creation
  • Data Analysis Tools
  • Data Capture and Transfer
  • Data Connectors
  • Data Discovery
  • Data Extraction
  • Data Import/Export
  • Data Integration
  • Data Management
  • Data Migration
  • Data Quality Control
  • Data Security
  • Data Synchronisation
  • Data Transformation
  • Data Visualisation
  • Database Support
  • Drag & Drop
  • ETL - Extract / Transfer / Load
  • Information Governance
  • Key Performance Indicators
  • Master Data Management
  • Match & Merge
  • Metadata Management
  • Multiple Data Sources
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Publishing / Sharing
  • Query Builder
  • Relational Display
  • Reporting & Statistics
  • Reporting/Analytics
  • Role-Based Permissions
  • SSL Security
  • Scheduled / Automated Reports
  • Search/Filter
  • Secure Data Storage
  • Self Service Data Preparation
  • Self-service Analytics
  • Single Sign On
  • Task Scheduling
  • Third Party Integrations
  • Trend / Problem Indicators
  • Trend Analysis
  • User Management
  • Version Control
  • Visual Analytics
  • Visual Discovery
  • Website Analytics

Alternatives

Funnel

4.6
#1 Alternative to Y42
Funnel takes messy, siloed data from 500+ platforms and automatically make it Business-Ready. Fully harmonized, always...

Stitch Labs

4.5
#2 Alternative to Y42
Stitch is an inventory and order management platform built for modern, high-growth brands.

Fivetran

4.6
#3 Alternative to Y42
Fivetran is a zero-maintenance data pipeline which enables businesses of all sizes to collect and analyze their...

Supermetrics

4.1
#4 Alternative to Y42
All your marketing data, wherever you need it. Supermetrics streamlines the delivery of data from 60+ sales and...

Reviews

Overall rating

4.9 /5
(12)
Value for Money
4.7/5
Features
4.7/5
Ease of Use
4.9/5
Customer Support
4.8/5

Already have Y42?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Write a Review!
Showing 5 reviews of 12
Maximilian E. Maximilian E.
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 2-10 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Impressive speed, scaling abilities and reliability

Reviewed on 07/08/2021

We are using y42 to handle the Data of over one hundred sources. The probability of errors and...

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.

Jonatas S. Jonatas S.
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 2-10 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Great product and support/dev team

Reviewed on 31/08/2021

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.

Alternatives Considered

Funnel and Supermetrics

Reasons for Choosing Y42

Reliability and stability, with Supermetrics, the queries would often take a lot of time to complete and usually fail. With y42, everything is more reliable and faster within both the interface and BigQuery/Data Studio.

Switched From

Supermetrics

Reasons for Switching to Y42

Pricing and functionality.
Arne I. Arne I.
Overall rating
  • Industry: Apparel & Fashion
  • Company size: 11-50 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Super einfach bei der Implementierung und ideal bei der täglichen Nutzung!

Reviewed on 07/10/2021

Ich löse damit alle Datenprobleme, außer die finale Visualisierung und das täglich und mit großer...

Ich löse damit alle Datenprobleme, außer die finale Visualisierung und das täglich und mit großer Effektivität.

Pros

Ich nutze y42 täglich und bin absolut davon überzeugt, dass es aktuell nichts besseres gibt. Von der Integration, über die Modellierung und Orchestrierung bis hin zur Bereitstellung für ein BI Tool funktioniert alles absolut reibungslos. Dazu noch als komplette No-Code Lösung ideal, um nicht von teuren Data Engineers abhängig zu sein.

Cons

Der Visualisierungsteil ist nicht ausgereift genug, um ihn täglich zu nutzen. Da gibt es bisher besseres am Markt.

Alternatives Considered

Fivetran, Stitch Labs and Funnel

Reasons for Switching to Y42

Modellierung ohne ein Zeile Code und all unsere Data Sources werden abgedeckt. Das Gesamtpaket stimmt einfach!
Elisa M. Elisa M.
Overall rating
  • Industry: Food & Beverages
  • Company size: 51-200 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Almost like Plug and Play

Reviewed on 13/09/2021

Very happy with the solution, as an early stage company you need to be mindful where to hire and...

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.

Viet L. Viet L.
Overall rating
  • Industry: Investment Management
  • Company size: 2-10 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

God-sent product

Reviewed on 11/03/2021

It helps me a lot in gathering all financial information gathered from all portfolio companies,...

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

Alternatives Considered

Tableau and Looker

Reasons for Choosing Y42

Visual pipelines and integrations

Switched From

Google Sheets and Google Data Studio
Showing 5 reviews of 12 Read all reviews

Y42 FAQs

Below are some frequently asked questions for Y42.

Y42 offers the following pricing plans:

Pricing based on parameters like # users and data sources. Visit y42.com for an overview of our packages. Startups might be eligible for special discounts and growth plans. Get all your money back after onboarding (~3 months) if Y42 does not deliver according to your expectations.

Y42 has the following typical customers:

11-50, 51-200, 201-500, 501-1,000

Y42 supports the following languages:

English

Y42 supports the following devices:

Y42 integrates with the following applications:

Facebook for Business, Google Analytics, Google Data Studio, Instagram, LinkedIn for Business, MySQL, PayPal, PostgreSQL, Shopify, Stripe, Zendesk

Y42 offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Chat

Related categories

See all software categories found for Y42.