What is a data transformation?

Rational ProjectConsole Designer Help

Data transformation is an operation that aggregates and normalizes the data you collect to make your metrics displays more meaningful and useful. To create a data transformation, you write a script using the Perl or Visual Basic scripting language.

Rational ProjectConsole supports two types of data transformation:
  1. Data cleansing: The process of checking data for adherence to standards, consistency, and integrity.
  2. Data derivation: Derived data are measures that are not directly available through simple data collection, but are calculated after collection. Examples of derived data include standard deviations, total lines of code in source files, and earned values.

After Rational ProjectConsole loads your raw data in the repository, it can convert the data into useful information. Examples include calculating the logarithmic value, the area under a curve or the standard deviation, aggregating data over repeated time intervals, or including a lookup table that converts user names based on known quantities, such as Bob Brown and Robert Brown being one and the same user.