Building analytical models with standardized virtual flat files

摘要

A system and method for creating virtual flat customer records derived from database customer data that may be used as standardized input for analytical models. A Customer Analytic Record (“CAR”) application may be created as a database object to extract, transform, and format all of the customer data needed for customer segmentation and predictive modeling. The CAR may be a set of database views that are defined using virtual stored queries The CAR application may dynamically calculate additional variables using predetermined transformations, including custom transformations of an underlying behavior. The CAR is preferably a dynamic view of the customer record that changes whenever any update is made to the database. The definition of the CAR provides documentation of each data element available for use in models and analytics.