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
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/
|
Reviews/
|
|||||
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 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
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
|
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
|
|||||
|
|
|