Transform

While Pipelines in Hevo address the Extract and Load steps in our Extract-Load-Transform (ELT) approach of moving your data from the Source to the Destination warehouse, the Transform step is achieved using Models and Workflows.

The most important benefit of the ELT approach is that you can transform your Source data in any manner, and any number of times. You can also transform only the data you need for a particular business analysis. To enable this, Hevo offers the intuitive and easy-to-use Models interface, where you can apply transformations on the data till you reach the final data model that is required for your business reporting and intelligence needs. Using the Query Builder in Models, you can design and test standard SQL queries that can aggregate data from one or more systems and transform it for analysis and reporting and work closely with the Destination schema. You can also create SQL Join clauses that can combine data from multiple tables, and write the query results into a new table.

Workflows further extend the functionality offered by Models and provide you with a powerful way to derive insights of your business. Workflows allow you to join multiple Models, whereby the output from one Model can form the input to one or more Models. This allows you to perform deeper analysis, and gather powerful data inputs for your reporting and BI needs.

You can schedule the Models and Workflows to run at specific times and frequency, giving you further independence and control in analyzing your data.


Last updated on 11 Mar 2022