Whether you are a marketing analyst, a data engineer,
or a manager, in the next minutes
I will show you how you can set up a scalable data pipeline,
from connecting your data sources over modeling your data
to automating your dashboards.
Y42 removes the complexity of stitching together
a data infrastructure.
Hey, my name is Rebecca, and I have helped leading startups
and e-commerce companies to set up their data stack in no time.
Let's get started.
On the left, you can see the different modules
that you need to run a fully-automated, scalable data
platform.
Integrate, model, visualize, and orchestrate.
Right now we are within visualize.
Now assume we are an e-commerce looking
to track our ad spend by channel and month,
updating near real-time.
I will show you how to get this dashboard up
and running from start to finish.
First things first, let's go to integrate
to connect our data sources.
You can select one of over 100 plug and play connectors.
For instance, here we have connected to Facebook ads,
where you can pick what tables and columns you
want to automatically load.
Let's go with ads insights, click on Import, and boom,
we are done!
All of the raw data has been loaded and stored
on your data warehouse for you.
See here, all you data is there.
Y42 helps you to set up or connect to an existing data
warehouse.
It takes care of your configuration and maintenance.
For this product tour, I've gone ahead
and connect both Google Ads and Facebook Ads data.
The next step is to go to Y42 modeling
to transform and merge the two data sources.
You have the choice between no-code modeling
or SQL-based modeling.
For now, let's jump into the no-code option.
What you can see here on the left are modeling nodes.
With them, you can do everything that's possible in SQL.
For our use case, we are pulling in data from Google Ads.
We then pass the date into a proper format.
In the next steps, you will see that Google Ads ad spend data
is provided in a weird unit.
Therefore, we will have to divide
the ad spend by 1 million, which you can easily
do using our functions node that works just
like Excel functions.
We do the respective cleaning for Facebook ads and then union
the data to create the final output table.
That's it, we are done with the modeling step.
And just to show you, you could easily
pick up on the output table we just created
and use SQL to further transform your data.
I will create a SQL model here, and now I
can write some standard SQL to further aggregate the data.
All right, now that we have merged
the Google and the Facebook ads data,
simply go to visualize, select the output table you want,
and build your dashboard.
At this point, you've got your dashboard.
However, you could even go one step beyond,
using our Automate feature to send
your data back to your marketing or CRM tools. Like you see here.
With all these amazing pipelines and automations,
it's easy to lose track of everything.
Exactly for that reason, we have built our data lineage,
where you can effortless trace where your data comes from
and how everything is connected.
But now, the final step after integrating and modeling
your data is to automate the whole pipeline.
Via orchestrate, you can easily have Y42 autogenerate
the entire path of how your data flows,
and then you can set a near real-time update schedule.
No need to write any scripts and waste precious engineering
time. Et
voila. This is truly the beauty of Y42.
It didn't even take us five minutes
to set up a fully-automated data platform,
and it didn't even have to touch a single line of code.
Would you mind getting a scalable data platform
that anyone can run?
Reach out, and we are happy to discuss your setup with you!