Data transformation isn't easy. One of its main challenges is it's highly prone to human errors and data quality issues. To address this challenge, we've rethought data transformation from the ground up. As a result, EasyMorph makes authoring fast, easy, and suitable for non-technical people.
Here is what it looks like (looped 2-minute animation):
EasyMorph has been created by people with many years of practical experience in data transformation. This, plus continuous improvement based on the analysis of hundreds of cases, has made EasyMorph a very capable and versatile tool suitable for the vast majority of real-life scenarios.
No matter if you need to perform an advanced calculation, merge datasets, or apply a complex business rule, you will be able to do this in a fast and visual way by using one or several transforms from more than 150 available actions in EasyMorph.
Unlike traditional ETL tools, EasyMorph makes data analysis and profiling effortless. The EasyMorph's ultra-fast calculation engine keeps all data in memory and makes the full result (not just the top few hundred rows) of every transformation step instantly available for analysis, even if it's millions of rows. This provides an excellent insight into calculation logic, minimizes human errors, and reduces time spent on designing and debugging workflows.
The vast majority of data transformation applications treat numeric values as 64-bit floating-point numbers. This leads to calculation errors, most of which remain unnoticed and end up in reports and databases. For instance, the condition 0.1 + 0.2 = 0.3 in many data tools incorrectly returns FALSE because they use 64-bit floats.
EasyMorph processes numbers as 128-bit fixed-point decimals instead of 64-bit floats. Fixed-point decimals completely avoid the type of errors caused by floating-point arithmetics. The condition mentioned above correctly returns TRUE in EasyMorph. In addition, double precision significantly reduces or entirely eliminates rounding and roll-up errors in business and finance calculations.
Documentation of ETL processes tends to be always outdated as it requires constant manual updating, which is a time-consuming and tedious duty. However, EasyMorph users are spared of this inconvenience because EasyMorph automatically generates a human-readable description of workflow in plain English (see example). The documentation has a permanent URL and can be linked from Business Intelligence reports and dashboards.
Business users from finance, manufacturing, consumer products, technology, and other industries use EasyMorph for self-service data preparation without relying on IT specialists. Here are just a few examples of what our customers do with EasyMorph: