MultiRate Data Tools

 

MultiRate contains several tools to manipulate the SQL data directly within MultiRate. All of these manipulations could also be done in SQL Server Management Studio, but using the MultiRate Tools is usually much easier.

 

SQL Import Tool

Import flat file, Excel, or Access data into SQL

 

Data Filter

Apply a filter to designate a subset of the training or test data to be used in the analysis

 

Add Random Characteristics

Create new fields in the training and test datasets that are randomly TRUE or FALSE

 

Transform Variables

Truncate or apply a log transformation to numeric fields

 

Interaction Effect Fields

Create new fields in the training dataset to capture interaction effects between two existing fields