[{"innerBlocks":[],"name":"core\/freeform","postId":127357,"blockType":{"name":"core\/freeform","keywords":[],"attributes":{"content":{"type":"string","source":"raw"},"lock":{"type":"object"}},"providesContext":[],"usesContext":[],"selectors":[],"supports":{"className":false,"customClassName":false,"reusable":false},"styles":[],"variations":[],"apiVersion":3,"title":"Classic","description":"Use the classic WordPress editor.","category":"text"},"originalContent":"

19 top data preparation tools<\/h2>
Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

Data preparation is first step to data quality<\/h2>
Data preparation tools have matured from initially being self-service-focused to now supporting data integration, analytics and data science use cases in production, according to research firm Gartner, Inc. Modern data preparation tools now enable data and analytics teams to build agile datasets at an enterprise scale, for a range of distributed content authors. In its latest report, \u201cMarket Guide for Data Preparation Tools,\u201d Gartner analysts Ehtisham Zaidi and Sharat Menon examine 19 of the leading providers of data preparation software.<\/p>

Altair Monarch and Altair Knowledge Hub<\/h2>
\u201cAltair Knowledge Hub is a browser-based data preparation tool that enables visual, code-free data preparation for all sources, including unstructured and semi-structured sources,\u201d according to Gartner. \u201cKnowledge Hub uses machine learning to provide suggestions to the user regarding data enrichment and transformations during the data preparation process. Data can be prepared in a grid-like or flow-based view.\u201d<\/p>

Alteryx Designer<\/h2>
\u201cThe Alteryx Designer is part of the Alteryx Analytics and Data Science Platform, which is a self-service, end-to-end platform for business analysts, data scientists and IT professionals,\u201d Gartner explains. \u201cIt is used to discover, catalog, prepare, blend, analyze and operationalize analytic models in a collaborative and governed environment. The platform is also composed of Alteryx Connect (data catalog), Alteryx Server and Alteryx Promote.\u201d<\/p>

Cambridge Semantics Anzo<\/h2>
\u201cAnzo is an end-to-end platform that provisions a data fabric over existing data infrastructure by applying a semantic layer and an enterprise knowledge graph,\u201d Gartner esplains. \u201cThis graph, built on open standards such as Web Ontology Language (OWL), Resource Description Framework (RDF), and SPARQL Protocol and RDF Query Language (SPARQL), captures a high-resolution twin of every structured and unstructured data source through mappings and ontologies that can be viewed in a dashboarding UI.\u201d<\/p>

Datameer Enterprise<\/h2>
\u201cDatameer Enterprise is a data preparation and data engineering platform that provides a centralized view of data, with comprehensive data security and governance capabilities to build and operationalize data pipelines with minimal coding efforts,\u201d Gartner explains. \u201cDatameer Visual Explorer supports visual exploration on complete datasets. It allows analysts to visually explore the data at any point in the data preparation pipeline, and drill down on any variable or value in the dataset.\u201d<\/p>

Elegant MicroWeb Smarten<\/h2>
\u201cSmarten is an Augmented Analytics tool with an embedded data preparation module\u2014Self Service Data Preparation (SSDP)\u2014that can also be purchased separately,\u201d according to Gartner. \u201cSmarten allows business users to explore, sample, clean, shape, reduce, join and blend data in a browser-based, Microsoft Excellike environment, with ML-based recommendations to help them in the process. The Action Editor saves the sequence of data preparation steps taken by a user, and these can be edited or rolled back at any time.\u201d<\/p>

erwin Metadata Manager, Mapping Manager and CATFx<\/h2>
\u201cThe erwin Mapping Manager is a web-based solution that performs source-target mapping in a drag-and-drop interface, by harvesting technical metadata from systems such as data stores, file connectors, big data platforms, analytics and BI solutions and master data management (MDM) hubs,\u201d according to Gartner. \u201cThese mappings can then be imported to enterprisewide ETL tools, after which erwin Automation can be used for code-automation templates\u2014for generating ETL scripts for these tools.\u201d<\/p>

Infogix Data3Sixty Analyze<\/h2>
\u201cInfogix enters this market through its acquisition of Lavastorm in 2018,\u201d Gartner explains. \u201cData3Sixty comes with prebuilt advanced analytics capabilities such as common regression, clustering and forecast techniques, and the ability to utilize either Python or R code to perform any transformations not possible using the prebuilt components. This is a web-based solution; access is both secured (through SSO, LDAP and AD solutions) and role-based.\u201d<\/p>

Lore IO platform<\/h2>
\u201cLore IO\u2019s data preparation tool creates a data fabric design across the entire enterprise through an ML-optimized workflow to find, prepare and deliver data,\u201d Gartner explains. \u201cLore IO focuses mainly on large enterprises as its target segment. It uses declarative data transformations rather than explicit ETL code, thereby reducing upfront manual ETL and data preparation effort. It uses a recommendation engine that helps business users with their data preparation process by auto-recommended business rules.\u201d<\/p>

Modak Analytics Nabu<\/h2>
\u201cModak Analytics\u2019 Nabu provides stand-alone data preparation, as well as data preparation as a capability for its broader data lake enablement solution,\u201d Gartner explains. \u201cThis data lake enablement solution provides rapid insights from siloed structured and unstructured sources through automated data ingestion and discovery, data lineage, data profiling, data catalog, augmented data preparation and visualization.\u201d<\/p>

Paxata Self-Service Data Preparation<\/h2>
\u201cPaxata Self-Service Data Preparation (SSDP) has a visual, Excel\/Google-like interface that guides the user to explore, clean, standardize and join data using simple clicks,\u201d according to Gartner. \u201cIt is part of the Paxata Adaptive Information Platform, a unified platform with features for data quality, data enrichment, data integration, user collaboration and support for data governance. Paxata is not limited to samples, and allows interacting, profiling and cleaning data at scale.\u201d<\/p>

Rapid Insight Veera Construct<\/h2>
\u201cRapid Insight offers a data preparation platform, Veera Construct, to access data from any source and format, integrate and transform it to produce reports, perform ad hoc analysis or create analytics datasets,\u201d according to Gartner. \u201cVeera jobs can be saved, shared and turned into repeatable processes to be run on-demand or on a scheduled basis. The solution leverages in-database optimization when performing data preparation tasks.\u201d<\/p>

SAP Agile Data Preparation<\/h2>
\u201cSAP Agile Data Preparation is a wizard-driven solution that provides users with the next-best recommendations for their data preparation transformations,\u201d Gartner explains. \u201cIt provides users with automated data cleansing, enriching and deduplication, and seamless integration with the SAP portfolio of data management and analytics tools, and has been designed for business users, data stewards and IT. Trusted data is created and maintained by helping information stewards to define, assess and improve data, and to maintain critical controls over data standards, privacy and security.\u201d<\/p>

SAS Data Loader for Hadoop, SAS Data Preparation<\/h2>
\u201cSAS Data Loader for Hadoop enables data preparation tasks such as profiling, cleansing, matching, merging and deduplicating directly on Hadoop clusters using MapReduce and Spark, through an intuitive user interface without any specialized coding skills,\u201d Gartner explains. \u201cData can be left in place here. SAS Data Preparation, on the other hand, works on tables in SAS\u2019s high-performance SAS Viya Cloud Analytic Services (CAS) in-memory processing environment, where data is loaded into in-memory tables for distributed, parallel execution.\u201d<\/p>

Talend Data Preparation<\/h2>
\u201cTalend offers three data preparation tools: an open-source desktop version, Talend Data Preparation; and commercial versions Talend Data Preparation Cloud (offered as part of the Talend Cloud platform) and Talend Data Preparation (offered as part of the on-premises offering Talend Data Fabric),\u201d according to Gartner. \u201cThese data preparation tools utilize ML algorithms for standardization, cleansing, pattern recognition and reconciliation, and also for offering automated recommendations to guide users through the data preparation process.\u201d<\/p>

Tamr Unify<\/h2>
\u201cTamr Unify differentiates itself by focusing primarily on self-service and enterprise-level data unification use cases,\u201d Gartner explains. \u201cUnify enables the creation of clean, unified datasets through supervised ML, by constructing a probabilistic model that can quickly map, match and classify data from multiple sources.\u201d<\/p>

TMMData Fix Tool, which is part of the TMMData Foundation platform<\/h2>
\u201cTMMData offers a solution for enterprise data preparation as part of its Foundation platform \u2014 the Fix Tool,\u201d Gartner explains. \u201cThe tool provides a non-code-based, point-and-click visual environment to explore, filter, format, sort and visualize data for nontechnical users; it provides access to SQL, Python, R Project, PHP, Perl and others for technical users. Other tools in the Foundation platform provide capabilities for data integration, data storage, data cataloging, visualization, data governance, data lineage, metadata collection, workflow management and so on.\u201d<\/p>

Trifacta Wrangler, Trifacta Wrangler Pro, Trifacta Wrangler Enterprise, Google Cloud Dataprep by Trifacta<\/h2>
\u201cTrifacta Wrangler Enterprise is an enterprise-level data preparation platform supporting various cloud and on-premises computing environments,\u201d Gartner explains. \u201cIts embedded ML capabilities allow it to: recommend data to connect to, infer data structure and schema, recommend joins, define user data access, and automate visualizations for exploration\/data quality. A spreadsheet-style grid makes it easy to use, and the ability for analysts to save data preparation steps in a task-based framework makes the process easily repeatable.\u201d<\/p>

Unifi Data Platform<\/h2>
\u201cThe Unifi Data Platform (UDP) provides AI-assisted data preparation and cataloging in a single platform,\u201d Gartner explains. \u201cThe Unifi Data Catalog, which enables users to find data using natural language queries, is also available as a stand-alone product. Data exploration capabilities include automated data parsing and crawling (using its OneParse capability), automated profiling, cleansing, object indexing, and so on (using its one-click functions), and AI-based recommendations on datasets, join types, filtering, formatting and others (using OneMind).\u201d<\/p>

Yellowfin Data Prep<\/h2>
\u201cYellowfin Data Prep is a stand-alone data preparation tool that provides connectivity to a variety of data sources and output data formats,\u201d Gartner explains. \u201cThe tool enables data preview in real-time to allow users to see their data during the preparation phase. For data profiling, the user can view the visual data shapes for columns, and statistics (min., max., outliers and more) around data distribution and cleanliness. The user also gets automated Suggest Actions to best fix or curate the data.\u201d<\/p>

","saveContent":"

19 top data preparation tools<\/h2>
Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

Data preparation is first step to data quality<\/h2>
Data preparation tools have matured from initially being self-service-focused to now supporting data integration, analytics and data science use cases in production, according to research firm Gartner, Inc. Modern data preparation tools now enable data and analytics teams to build agile datasets at an enterprise scale, for a range of distributed content authors. In its latest report, \u201cMarket Guide for Data Preparation Tools,\u201d Gartner analysts Ehtisham Zaidi and Sharat Menon examine 19 of the leading providers of data preparation software.<\/p>

Altair Monarch and Altair Knowledge Hub<\/h2>
\u201cAltair Knowledge Hub is a browser-based data preparation tool that enables visual, code-free data preparation for all sources, including unstructured and semi-structured sources,\u201d according to Gartner. \u201cKnowledge Hub uses machine learning to provide suggestions to the user regarding data enrichment and transformations during the data preparation process. Data can be prepared in a grid-like or flow-based view.\u201d<\/p>

Alteryx Designer<\/h2>
\u201cThe Alteryx Designer is part of the Alteryx Analytics and Data Science Platform, which is a self-service, end-to-end platform for business analysts, data scientists and IT professionals,\u201d Gartner explains. \u201cIt is used to discover, catalog, prepare, blend, analyze and operationalize analytic models in a collaborative and governed environment. The platform is also composed of Alteryx Connect (data catalog), Alteryx Server and Alteryx Promote.\u201d<\/p>

Cambridge Semantics Anzo<\/h2>
\u201cAnzo is an end-to-end platform that provisions a data fabric over existing data infrastructure by applying a semantic layer and an enterprise knowledge graph,\u201d Gartner esplains. \u201cThis graph, built on open standards such as Web Ontology Language (OWL), Resource Description Framework (RDF), and SPARQL Protocol and RDF Query Language (SPARQL), captures a high-resolution twin of every structured and unstructured data source through mappings and ontologies that can be viewed in a dashboarding UI.\u201d<\/p>

Datameer Enterprise<\/h2>
\u201cDatameer Enterprise is a data preparation and data engineering platform that provides a centralized view of data, with comprehensive data security and governance capabilities to build and operationalize data pipelines with minimal coding efforts,\u201d Gartner explains. \u201cDatameer Visual Explorer supports visual exploration on complete datasets. It allows analysts to visually explore the data at any point in the data preparation pipeline, and drill down on any variable or value in the dataset.\u201d<\/p>

Elegant MicroWeb Smarten<\/h2>
\u201cSmarten is an Augmented Analytics tool with an embedded data preparation module\u2014Self Service Data Preparation (SSDP)\u2014that can also be purchased separately,\u201d according to Gartner. \u201cSmarten allows business users to explore, sample, clean, shape, reduce, join and blend data in a browser-based, Microsoft Excellike environment, with ML-based recommendations to help them in the process. The Action Editor saves the sequence of data preparation steps taken by a user, and these can be edited or rolled back at any time.\u201d<\/p>

erwin Metadata Manager, Mapping Manager and CATFx<\/h2>
\u201cThe erwin Mapping Manager is a web-based solution that performs source-target mapping in a drag-and-drop interface, by harvesting technical metadata from systems such as data stores, file connectors, big data platforms, analytics and BI solutions and master data management (MDM) hubs,\u201d according to Gartner. \u201cThese mappings can then be imported to enterprisewide ETL tools, after which erwin Automation can be used for code-automation templates\u2014for generating ETL scripts for these tools.\u201d<\/p>

Infogix Data3Sixty Analyze<\/h2>
\u201cInfogix enters this market through its acquisition of Lavastorm in 2018,\u201d Gartner explains. \u201cData3Sixty comes with prebuilt advanced analytics capabilities such as common regression, clustering and forecast techniques, and the ability to utilize either Python or R code to perform any transformations not possible using the prebuilt components. This is a web-based solution; access is both secured (through SSO, LDAP and AD solutions) and role-based.\u201d<\/p>

Lore IO platform<\/h2>
\u201cLore IO\u2019s data preparation tool creates a data fabric design across the entire enterprise through an ML-optimized workflow to find, prepare and deliver data,\u201d Gartner explains. \u201cLore IO focuses mainly on large enterprises as its target segment. It uses declarative data transformations rather than explicit ETL code, thereby reducing upfront manual ETL and data preparation effort. It uses a recommendation engine that helps business users with their data preparation process by auto-recommended business rules.\u201d<\/p>

Modak Analytics Nabu<\/h2>
\u201cModak Analytics\u2019 Nabu provides stand-alone data preparation, as well as data preparation as a capability for its broader data lake enablement solution,\u201d Gartner explains. \u201cThis data lake enablement solution provides rapid insights from siloed structured and unstructured sources through automated data ingestion and discovery, data lineage, data profiling, data catalog, augmented data preparation and visualization.\u201d<\/p>

Paxata Self-Service Data Preparation<\/h2>
\u201cPaxata Self-Service Data Preparation (SSDP) has a visual, Excel\/Google-like interface that guides the user to explore, clean, standardize and join data using simple clicks,\u201d according to Gartner. \u201cIt is part of the Paxata Adaptive Information Platform, a unified platform with features for data quality, data enrichment, data integration, user collaboration and support for data governance. Paxata is not limited to samples, and allows interacting, profiling and cleaning data at scale.\u201d<\/p>

Rapid Insight Veera Construct<\/h2>
\u201cRapid Insight offers a data preparation platform, Veera Construct, to access data from any source and format, integrate and transform it to produce reports, perform ad hoc analysis or create analytics datasets,\u201d according to Gartner. \u201cVeera jobs can be saved, shared and turned into repeatable processes to be run on-demand or on a scheduled basis. The solution leverages in-database optimization when performing data preparation tasks.\u201d<\/p>

SAP Agile Data Preparation<\/h2>
\u201cSAP Agile Data Preparation is a wizard-driven solution that provides users with the next-best recommendations for their data preparation transformations,\u201d Gartner explains. \u201cIt provides users with automated data cleansing, enriching and deduplication, and seamless integration with the SAP portfolio of data management and analytics tools, and has been designed for business users, data stewards and IT. Trusted data is created and maintained by helping information stewards to define, assess and improve data, and to maintain critical controls over data standards, privacy and security.\u201d<\/p>

SAS Data Loader for Hadoop, SAS Data Preparation<\/h2>
\u201cSAS Data Loader for Hadoop enables data preparation tasks such as profiling, cleansing, matching, merging and deduplicating directly on Hadoop clusters using MapReduce and Spark, through an intuitive user interface without any specialized coding skills,\u201d Gartner explains. \u201cData can be left in place here. SAS Data Preparation, on the other hand, works on tables in SAS\u2019s high-performance SAS Viya Cloud Analytic Services (CAS) in-memory processing environment, where data is loaded into in-memory tables for distributed, parallel execution.\u201d<\/p>

Talend Data Preparation<\/h2>
\u201cTalend offers three data preparation tools: an open-source desktop version, Talend Data Preparation; and commercial versions Talend Data Preparation Cloud (offered as part of the Talend Cloud platform) and Talend Data Preparation (offered as part of the on-premises offering Talend Data Fabric),\u201d according to Gartner. \u201cThese data preparation tools utilize ML algorithms for standardization, cleansing, pattern recognition and reconciliation, and also for offering automated recommendations to guide users through the data preparation process.\u201d<\/p>

Tamr Unify<\/h2>
\u201cTamr Unify differentiates itself by focusing primarily on self-service and enterprise-level data unification use cases,\u201d Gartner explains. \u201cUnify enables the creation of clean, unified datasets through supervised ML, by constructing a probabilistic model that can quickly map, match and classify data from multiple sources.\u201d<\/p>

TMMData Fix Tool, which is part of the TMMData Foundation platform<\/h2>
\u201cTMMData offers a solution for enterprise data preparation as part of its Foundation platform \u2014 the Fix Tool,\u201d Gartner explains. \u201cThe tool provides a non-code-based, point-and-click visual environment to explore, filter, format, sort and visualize data for nontechnical users; it provides access to SQL, Python, R Project, PHP, Perl and others for technical users. Other tools in the Foundation platform provide capabilities for data integration, data storage, data cataloging, visualization, data governance, data lineage, metadata collection, workflow management and so on.\u201d<\/p>

Trifacta Wrangler, Trifacta Wrangler Pro, Trifacta Wrangler Enterprise, Google Cloud Dataprep by Trifacta<\/h2>
\u201cTrifacta Wrangler Enterprise is an enterprise-level data preparation platform supporting various cloud and on-premises computing environments,\u201d Gartner explains. \u201cIts embedded ML capabilities allow it to: recommend data to connect to, infer data structure and schema, recommend joins, define user data access, and automate visualizations for exploration\/data quality. A spreadsheet-style grid makes it easy to use, and the ability for analysts to save data preparation steps in a task-based framework makes the process easily repeatable.\u201d<\/p>

Unifi Data Platform<\/h2>
\u201cThe Unifi Data Platform (UDP) provides AI-assisted data preparation and cataloging in a single platform,\u201d Gartner explains. \u201cThe Unifi Data Catalog, which enables users to find data using natural language queries, is also available as a stand-alone product. Data exploration capabilities include automated data parsing and crawling (using its OneParse capability), automated profiling, cleansing, object indexing, and so on (using its one-click functions), and AI-based recommendations on datasets, join types, filtering, formatting and others (using OneMind).\u201d<\/p>

Yellowfin Data Prep<\/h2>
\u201cYellowfin Data Prep is a stand-alone data preparation tool that provides connectivity to a variety of data sources and output data formats,\u201d Gartner explains. \u201cThe tool enables data preview in real-time to allow users to see their data during the preparation phase. For data profiling, the user can view the visual data shapes for columns, and statistics (min., max., outliers and more) around data distribution and cleanliness. The user also gets automated Suggest Actions to best fix or curate the data.\u201d<\/p>

","order":0,"get_parent":{},"attributes":[],"attributesType":{"content":{"type":"string","source":"raw"},"lock":{"type":"object"}},"dynamicContent":""}]

19 top data preparation tools<\/h2>Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

19 top data preparation tools<\/h2>Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

19 top data preparation tools<\/h2>
Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

19 top data preparation tools<\/h2>
Alteryx Designer, Cambridge Semantics Anzo and SAP Agile Data Preparation are among the leading products to help organizations prepare data for analysis.<\/p>

19 top data preparation tools

More for you