Data preparation & work automation for non-technical users
4.5/5 (2 avis)EasyMorph is a self-service, data preparation and transformation tool that helps non-technical business users to increase data analysis productivity by accessing, merging, and manipulating data from multiple data sources. The solution is useful for business users within sales, marketing, financial and operational analysis, helping them transform raw data sets into actionable analysis in less time, and with higher quality than working with spreadsheets. Repetitive data-related tasks can also be automated for increased efficiency.
EasyMorph comes with more than 100 built-in transformations, and stores all intermediate calculation results enabling users to click any transformation step and instantly see its result. Users can load data from databases, files and spreadsheets, and transform it visually by applying various operations, such as filter or join, and export results to files and databases. The automatic documentation feature in EasyMorph enables users to record all data manipulations and calculations to facilitate the tasks of making changes, identifying problems, and keeping track of work history.
EasyMorph’s data transformation capabilities include data preparation for dashboards and reports, over 100 actions for merging, matching, filtering, aggregating, and more, as well as the ability to import and export from and to databases, spreadsheets, and files of various formats. Users are also able to perform advanced non-relational transformations such as regexp, pivot/unpivot, or fuzzy matching, and make use of data quality guards in order to prevent "dirty" or inconsistent data from propagating.
Automation features within EasyMorph allow users to replace VBA macros or various scripts with visual workflows, schedule tasks, and copy/delete/rename/unzip/download files. Users can also receive and send emails with attachments, transfer files over SFTP/SCP, run external programs, and execute batch and PowerShell commands. The solution also supports the ability to create data-aware, rule-based alerts, and arrange conditional if/then/else workflows. EasyMorph offers support for cloud databases hosted at Amazon, Azure, or Google.
Avantages
Feature-rich and cost. It is very economical for what it does. The free version will probably do 90% of what you need and the paid-for version is worth its weight in gold. While we use EasyMorph in my department (IT) as a poor-man's ETL, it does it well and it does it beautifully. Previously, we would spend weeks creating custom scripts in a variety of programming languages, or use SSIS, which is terrible for ETL. We even use EasyMorph Server as a centralized task scheduler to kick off all kinds of batch jobs that might not even perform any sort of ETL. I love this tool and I am slowly but surely sowing the seeds and spreading EasyMorph's adoption throughout my organization.
Inconvénients
Once in a while it may crash if you are importing data from a query, although I haven't seen it crash in the latest version. I also wish it could directly speak with Snowflake, our chosen data warehouse, but through EasyMorph's File Export, Amazon Command, and ODBC Database Command actions, we're able to ingest data into our warehouse without issues.
Avantages
Easy to use. Saves tons of time doing transformations. I was able to build a data-mart in a week, without easy morph it would have taken me at least 3 weeks.
Inconvénients
If you have really large data sets and plan to do a delete and insert it could be very slow and possibly too heavy for easy morph handle.
$750/year or $250 for 3 months. Updates and technical support included. Price is guaranteed to never increase as long as subscription is not interrupted. No vendor lock-in policy (see details on our website).
A time-unlimited free edition with restricted functionality is available. Compare editions on https://easymorph.com/buy.html
Voici quelques-unes des questions fréquentes sur EasyMorph.
Types de licences disponibles pour EasyMorph :
À partir de: 750,00 $US/année
Type de licence: Gratuit, Abonnement
version d'essai gratuite: Disponible
$750/year or $250 for 3 months. Updates and technical support included. Price is guaranteed to never increase as long as subscription is not interrupted. No vendor lock-in policy (see details on our website).
A time-unlimited free edition with restricted functionality is available. Compare editions on https://easymorph.com/buy.html
Fonctionnalités du logiciel EasyMorph :
Utilisateurs habituels du logiciel EasyMorph :
Grandes entreprises, Entreprises de taille moyenne, Non Profit, Administration publique, PME
Langues dans lesquelles EasyMorph est disponible :
anglais
Types de licences disponibles pour EasyMorph:
Gratuit, Abonnement
Nous n'avons pas d'informations sur les appareils pris en charge par EasyMorph.
Applications s'intégrant à EasyMorph :
Microsoft Excel, Qlik Sense, Tableau
Ressources d'aide disponibles pour EasyMorph :
Forum, Support en ligne
Everyone I demo this tool to at my org is amazed how it is quick to learn. Customer support is also very responsive, often responding within an hour. So far all my interactions with support have been with the CEO. He clearly stands by his product. Looking forward to meeting him again at a future Tableau Conference.