+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Plauti
    124 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website
  • Denodo
    387 Ratings
    Visit Website
  • PBRS Power BI Reports Distribution
    12 Ratings
    Visit Website
  • DbVisualizer
    585 Ratings
    Visit Website
  • Redlist
    64 Ratings
    Visit Website
  • Okyline
    2 Ratings
    Visit Website

About

DataPreparator is a free software tool designed to assist with common tasks of data preparation (or data preprocessing) in data analysis and data mining. DataPreparator can assist you with exploring and preparing data in various ways prior to data analysis or data mining. It includes operators for cleaning, discretization, numeration, scaling, attribute selection, missing values, outliers, statistics, visualization, balancing, sampling, row selection, and several other tasks. Data access from text files, relational databases, and Excel workbooks. Handling of large volumes of data (since data sets are not stored in the computer memory, with the exception of Excel workbooks and result sets of some databases where database drivers do not support data streaming). Stand alone tool, independent of any other tools. User friendly graphical user interface. Operator chaining to create sequences of preprocessing transformations (operator tree). Creating of model tree for test/execution data.

About

Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources. Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data. Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs—all with an easy to use, engaging, no-code experience. Power Query supports hundreds of data sources with built-in connectors, generic interfaces (such as REST APIs, ODBC, OLE, DB and OData) and the Power Query SDK to build your own connectors.

Platforms Supported

Windows Supported
Mac Supported
Linux Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Companies looking for a software tool designed to assist with common tasks of data preparation in data analysis and data mining

Audience

Businesses that need a data transformation and data preparation engine to improve their data analysis and decision-making

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

DataPreparator
Founded: 2010
Australia
www.datapreparator.com/features.html

Company Information

Microsoft
Founded: 1975
United States
powerquery.microsoft.com/en-us/

Alternatives

Alternatives

Toad Data Point

Toad Data Point

Quest Software
FastQueryBuilder

FastQueryBuilder

Fast Reports
MyDataModels TADA

MyDataModels TADA

MyDataModels
TROCCO

TROCCO

primeNumber Inc
Data Preparer

Data Preparer

The Data Value Factory
CData Sync

CData Sync

CData Software

Categories

Data Preparation Supported

Categories

Data Integration Supported
Data Preparation Supported
ETL Supported

Integrations

Microsoft Excel Supported
Acterys Not Supported
Appfigures Not Supported
Azure Blob Storage Not Supported
Cherwell Software Not Supported
Denodo Not Supported
Dremio Not Supported
GitHub Not Supported
Hadoop Not Supported
Kyligence Not Supported
MariaDB Not Supported
MarkLogic Not Supported
Microsoft Dynamics 365 Not Supported
Palantir Foundry Not Supported
Planview ProjectPlace Not Supported
PostgreSQL Not Supported
SAP HANA Not Supported
Smartsheet Not Supported
Strategy ONE Not Supported
Tableau Prep Not Supported

Integrations

Microsoft Excel Supported
Acterys Supported
Appfigures Supported
Azure Blob Storage Supported
Cherwell Software Supported
Denodo Supported
Dremio Supported
GitHub Supported
Hadoop Supported
Kyligence Supported
MariaDB Supported
MarkLogic Supported
Microsoft Dynamics 365 Supported
Palantir Foundry Supported
Planview ProjectPlace Supported
PostgreSQL Supported
SAP HANA Supported
Smartsheet Supported
Strategy ONE Supported
Tableau Prep Supported
Claim DataPreparator and update features and information
Claim DataPreparator and update features and information
Claim Microsoft Power Query and update features and information
Claim Microsoft Power Query and update features and information