The task of data transformation is traditionally believed to belong to IT developers while business users are typically left with Excel, or cumbersome Visual Basic and Python scripting. Although there have been attempts to create easy-to-use so-called data preparation utilities, such utilities are suitable only for very simple cases. At the same time enterprise Extract-Transform-Load (ETL) systems while powerful (and very expensive) are prohibitively difficult for a non-IT audience, as they simply are not designed for it.
EasyMorph employs a novel approach that combines simplicity similar to that of data preparation utilities and the power typical for professional ETL systems. It allows business users to design rather complex data transformations without using SQL or scripts, while data experts enjoy simpler and faster ETL development.
For business users
For data experts
Data transformation isn't an easy task. One of its main challenges is having a clear understanding of the transformation logic because it's highly prone to human errors. We walked away from the traditional approach to designing transformations in order to bring more clarity into calculations, and make authoring simpler:
Here is what it looks like (looped 2-minute animation):
A 3-minute overview and demo of EasyMorph that shows querying a database, applying transformations, using expressions and, finally, exporting results back into the database.
EasyMorph can work with many data visualization tools by exporting data into files and databases. It works particularly well with Tableau and Qlik.
With the help of EasyMorph Tableau users can perform complex transformations, automatically generate and publish Tableau Data Extracts.
QlikView and Qlik Sense users can import and export QVD files, and replace entire load scripts with visual transformations in EasyMorph with just 2 lines of script.