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 adds self-service data transformation capabilities where they are missing, eliminates tedious scripting.
Tableau users design complex transformations without help of IT staff, generate TDEs, publish data sources to Tableau Server.
Qlik users replace entire load scripts with visual transformations in EasyMorph, generate QVD files.
Excel users design error-proof data transformation processes visually, instead of writing VBA macros.