Master Data Table

From Open Risk Manual

Definition

In the context of Model Development, Master Data Table is a data table (stored e.g. in a spreadsheet or a database) that captures the definitive collection of historical data that will be used for the development of a Risk Model

A master data table is the outcome of any Data Quality processes applied to input Risk Data

Examples

  • In the context of building a credit scorecard the master data table will contain all required data for estimating a model in suitably formatted table
   1   6   4  12   5   5   3   4   1  67   3   2   1   2   1   0   0   1   0   0   1   0   0   1   1 
   2  48   2  60   1   3   2   2   1  22   3   1   1   1   1   0   0   1   0   0   1   0   0   1   2 
   4  12   4  21   1   4   3   3   1  49   3   1   2   1   1   0   0   1   0   0   1   0   1   0   1 
   1  42   2  79   1   4   3   4   2  45   3   1   2   1   1   0   0   0   0   0   0   0   0   1   1 
   1  24   3  49   1   3   3   4   4  53   3   2   2   1   1   1   0   1   0   0   0   0   0   1   2 
   4  36   2  91   5   3   3   4   4  35   3   1   2   2   1   0   0   1   0   0   0   0   1   0   1 
   4  24   2  28   3   5   3   4   2  53   3   1   1   1   1   0   0   1   0   0   1   0   0   1   1 

Issues and Challenges

  • In modern big data environments the concept of a single data table may not be adequate

See Also