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 usually end up having rather limited applicability due to a lack of features required for real-life tasks. At the same time enterprise Extract-Transform-Load (ETL) systems while powerful (and very expensive) are prohibitively difficult for non-IT audience, as they simply are not designed for it.
Due to multiple optimizations and focus on usability EasyMorph combines simplicity similar to that of data preparation utilities without giving up on the power and flexibility typical for professional ETL tools. EasyMorph is targeted mostly at business users, although it has something to offer to veteran data experts as well.
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 abstract approach to designing transformations in order to bring maximum clarity into calculations, and make authoring simpler:
Here is what it looks like (looped 2-minute animation):
When you change parameters or properties of a transformation EasyMorph smartly recalculates only transformations that are affected by the change. It can do this because, remember, it stores full results of all transformation steps in memory. Therefore it can keep results of unaffected transformations, and recalculate only affected ones. Auto-calculation eliminates the need to re-run everything from the beginning again and again. Meanwhile you can even keep working with the project as the recalculation takes place in the background, and is triggered automatically.
EasyMorph doesn't force you to define data types explicitly for each column of every table, because in EasyMorph values of different types (e.g. numbers and text) can be mixed in the same column, just as in Excel.
Think about data types only when you have to export a table to a database, or to Tableau. Or don't bother at all as EasyMorph will autodetect data types for you when it becomes necessary.
EasyMorph natively supports data formats of popular data analysis applications such as Tableau and Qlik.
Tableau users can automatically generate Tableau Data Extracts and then publish them to Tableau Server (see example).
Qlik users can import and export QVD files, and replace load scripts with visual transformations in EasyMorph (see example).