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.
EasyMorph employs a novel, non-traditional approach that makes data transformation easier. It combines simplicity similar to that of data preparation utilities, and the power typical for professional ETL tools. Having the best of both worlds makes EasyMorph suitable for business users as well as for veteran data experts.
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):
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.
Also when exporting data into a database table or Tableau extract you don't have to deal with low level data types (e.g. VARCHAR or DECIMAL). Regardless of the target database you operate with only three simple data types — Text, Number and Date. Or don't bother about data types at all as EasyMorph will autodetect them for you when it becomes necessary.
EasyMorph natively supports data formats of popular data analysis applications such as Tableau and Qlik.
With the help of EasyMorph Tableau users can perform complex transformations, export data to databases and automatically generate Tableau Data Extracts. Read more...
Qlik users can import and export QVD files, and replace load scripts with visual transformations in EasyMorph. See example...