This matrix will be used in the Linear Regression and Factor Analysis Tutorials in subsequent chapters.
-
Parameterize a Matrix analysis as follows:
-
Selected Table and Columns
- TWM_CUSTOMER_ANALYSIS.income
- TWM_CUSTOMER_ANALYSIS.age
- TWM_CUSTOMER_ANALYSIS.years_with_bank
- TWM_CUSTOMER_ANALYSIS.nbr_children
- TWM_CUSTOMER_ANALYSIS.marital_status
- TWM_CUSTOMER_ANALYSIS.female
- TWM_CUSTOMER_ANALYSIS.single
- TWM_CUSTOMER_ANALYSIS.married
- TWM_CUSTOMER_ANALYSIS.separated
- TWM_CUSTOMER_ANALYSIS.ccacct
- TWM_CUSTOMER_ANALYSIS.ckacct
- TWM_CUSTOMER_ANALYSIS.svacct
- TWM_CUSTOMER_ANALYSIS.avg_cc_bal
- TWM_CUSTOMER_ANALYSIS.avg_ck_bal
- TWM_CUSTOMER_ANALYSIS.avg_sv_bal
- TWM_CUSTOMER_ANALYSIS.avg_cc_tran_amt
- TWM_CUSTOMER_ANALYSIS.avg_cc_tran_cnt
- TWM_CUSTOMER_ANALYSIS.avg_ck_tran_amt
- TWM_CUSTOMER_ANALYSIS.avg_ck_tran_cnt
- TWM_CUSTOMER_ANALYSIS.avg_sv_tran_amt
- TWM_CUSTOMER_ANALYSIS.avg_sv_tran_cnt
- TWM_CUSTOMER_ANALYSIS.cc_rev
- Analysis Name — Customer_Analysis_Matrix
There are no viewable results generated as a result of executing the Matrix analysis. The results will be viewed via the Export Matrix analysis tutorial. For more information, see Tutorial - Export Matrix Analysis (Teradata Database).
-
Selected Table and Columns
- Save the Matrix analysis with the above mentioned name "Customer_Analysis_Matrix” for use in the Linear Regression and Factor analysis tutorials.