Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

DataPreparator is a complimentary software application aimed at facilitating various aspects of data preparation, also known as data preprocessing, within the realms of data analysis and mining. This tool provides numerous functionalities to help you explore and ready your data before engaging in analysis or mining activities. It encompasses a range of features including data cleaning, discretization, numerical adjustments, scaling, attribute selection, handling missing values, addressing outliers, conducting statistical analyses, visualizations, balancing, sampling, and selecting specific rows, among other essential tasks. The software allows users to access data from various sources such as text files, relational databases, and Excel spreadsheets. It is capable of managing substantial data volumes effectively, as datasets are not retained in computer memory, except for Excel files and the result sets from certain databases that lack data streaming support. As a standalone tool, it operates independently of other applications, boasting a user-friendly graphical interface. Additionally, it enables operator chaining to form sequences of preprocessing transformations and allows for the creation of a model tree specifically for test or execution data, thereby enhancing the overall data preparation process. Ultimately, DataPreparator serves as a versatile and efficient resource for those engaged in data-related tasks.

Description

Utilize SQL, C#, and VB.NET directly within Excel to manipulate data, develop unique functions, and streamline workbook automation. With features like code completion, syntax highlighting, and error corrections, QueryStorm's integrated development environment makes coding effortless! You can easily share your custom functions and automated spreadsheets with clients and colleagues, who will only need the QueryStorm Runtime to access them. Empower yourself to craft bespoke Excel functions using SQL, C#, or VB.NET, which can be utilized personally or distributed among your peers. Introduce sophisticated business logic into your spreadsheets, enhancing their interactivity through the integration of .NET and SQL code. Take advantage of tailored workbooks and the innovative functions created by your team, alongside valuable Excel extensions contributed by the broader community. Leverage your technical expertise within Excel to effectively manage data, create intelligent workbooks, and collaborate by sharing custom functions with others. By doing so, you will enhance productivity while fostering a more efficient workflow across your projects.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

Microsoft 365 Yes 
Microsoft Excel Yes 

Integrations

Microsoft 365 No 
Microsoft Excel No 

Pricing Details

No price information available.
Free Trial No 
Free Version No 

Pricing Details

$5 per user per month
Free Trial Yes 
Free Version Yes 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Deployment

Web-Based No 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) Yes 
In Person Yes 

Vendor Details

Company Name

DataPreparator

Founded

2010

Country

Australia

Website

www.datapreparator.com/features.html

Vendor Details

Company Name

Stormy Range Software

Founded

2016

Country

Poland

Website

www.querystorm.com

Product Features

Data Preparation

Collaboration Tools No 
Data Access No 
Data Blending No 
Data Cleansing No 
Data Governance No 
Data Mashup No 
Data Modeling No 
Data Transformation No 
Machine Learning No 
Visual User Interface No 

Product Features

Data Analysis

Data Discovery Yes 
Data Visualization Yes 
High Volume Processing Yes 
Predictive Analytics No 
Regression Analysis Yes 
Sentiment Analysis No 
Statistical Modeling Yes 
Text Analytics Yes 

Alternatives

Alternatives

Dose for Excel Reviews

Dose for Excel

Zbrainsoft.com
MyDataModels TADA Reviews

MyDataModels TADA

MyDataModels
Pine BI Reviews

Pine BI

Pinexl
Data Preparer Reviews

Data Preparer

The Data Value Factory