EasyMorph is a powerful data transformation tool. Optimized for business users. A free edition available.

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.


data transformationFor business users

  • Transform data visually instead of writing VBA macros, Python scripts or SQL.
  • Merge, filter, aggregate data from databases, spreadsheets, and files.
  • Prepare data for visualization (e.g. in Tableau) or online reporting.
  • Convert text files to spreadsheets and vice versa.
  • Create simple PDF reports.

data transformationFor data experts

  • Medium-volume ETL tool perfect for particularly complex transformation logic.
  • Fast data quality assessment and ETL prototyping.
  • Quick one-off data manipulations.
  • Powerful non-relational transformations (e.g. Pivot/Unpivot, Fill down, Shift column).
  • Extracting data from loosely structured spreadsheets.

More visual, simpler design of calculations

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:


  • The full result of every transformation step is stored in memory and is therefore instantly visible when you click a transformation. You can easily trace back to the point where a calculation went wrong.
  • You can manipulate data in a manner typical for data preparation utilities (e.g. pick commands from a context menu). In this case, EasyMoprh creates necessary transformations for you, on the fly.
  • EasyMorph automatically re-calculates dependent transformation steps in the background, instantly after a transformation was added or edited. You can immediately see how a change affects the final result.

Here is what it looks like (looped 2-minute animation):

animated demo

Video

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.

Screenshots

Example: US Census 2012
Example: Inc5000
Database Query Editor

For Tableau, Excel and Qlik users

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.


Start with the free edition. See if it works for you.

Learn more   Download