TD_POWERTRANSFORM Function | Teradata Vantage - TD_POWERTRANSFORM - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
lifecycle
latest

TD_POWERTRANSFORM takes a time series or spatial series and applies a power transform equation (log, invert, and so on) to the series to produce a transformed result series. The single input source contains univariate or multivariate series instances. A typical use cases for this function are following situations:

  • Heteroscedasticity: Variance of the residuals of a regression model is not constant over time. Use TD_POWERTRANSFORM to stabilize the variance of the data and make it more homoscedastic, which can improve the performance of regression models.
  • Nonlinear trends: Time series has trends, such as exponential or quadratic growth or decay. Use TD_POWERTRANSFORM to linearize the trend and improve the accuracy of the forecasting models.
  • Skewed distributions: Time series data exhibits skewed distributions that result in biased forecasts. Use TD_POWERTRANSFORM to make the distribution more symmetric and reduce skewness.

You then use the transformed result to build an ARIMA forecasting model.

The following procedure is an example of how to process and then forecast heteroscedastic time series using TD_POWERTRANSFORM:
  1. Apply TD_POWERTRANSFORM to the heteroscedastic time series to transform it into a homoscedastic time series.
  2. Use the resulting homoscedastic time series to build an ARIMA forecasting model.
  3. Use the model to produce the initial forecast of the homoscedastic time series.
  4. Use the backward transform on the initial forecast to extract the forecast values for the heteroscedastic time series.