You use warehouse transformers to perform basic data transformations, including cleaning data, generating key columns, generating period tables, inverting data, and pivoting data.

The statistical transformers perform the following functions: calculation of basic statistics, calculation of subtotals, calculation of moving averages, chi-square test, chi-square goodness-of-fit test, correlation analysis, regression, and analysis of variance (ANOVA).

User-defined functions give you the ability to easily define and reuse your own transformers.