Microsoft Power QueryMicrosoft
|
||||||
Related Products
|
||||||
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
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
Platforms Supported
Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
|||||
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
24/7 Live Support
Online
|
Support
Phone Support
24/7 Live Support
Online
|
|||||
API
Offers API
|
API
Offers API
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
No information available.
Free Version
Free Trial
|
Pricing
No information available.
Free Version
Free Trial
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Webinars
Live Online
In Person
|
Training
Documentation
Webinars
Live Online
In Person
|
|||||
Company InformationDataPreparator
Founded: 2010
Australia
www.datapreparator.com/features.html
|
Company InformationMicrosoft
Founded: 1975
United States
powerquery.microsoft.com/en-us/
|
|||||
Alternatives |
Alternatives |
|||||
|
|
||||||
|
|
|
|||||
|
|
|
|||||
|
|
||||||
Categories |
Categories |
|||||
Integrations
Microsoft Excel
Acterys
Active Directory
AtScale
Azure Cosmos DB
Azure SQL Database
CData Connect
Data Virtuality
Exasol
FactSet
|
Integrations
Microsoft Excel
Acterys
Active Directory
AtScale
Azure Cosmos DB
Azure SQL Database
CData Connect
Data Virtuality
Exasol
FactSet
|
|||||
|
|
|