Some slide material taken from: Groth, Han and Kamber, SAS Institute

1. Data Mining A special presentation for BCIS 4660 Spring 2012 Dr. Nick Evangelopoulos, ITDS Dept. Some slide material taken from: Groth, Han and Kamber, SAS Institute

2. Overview of this Presentation • Introduction to Data Mining • Examples of Data Mining applications • The SEMMA Methodology • SAS EM Demo: The Home Equity Loan Case Logistic Regression Decision Trees Neural Networks

3. Introduction to DM “It is a capital mistake to theorize before one has data. Insensibly one begins to twist facts to suit theories, instead of theories to suit facts.” Sir Arthur Conan Doyle: Sherlock Holmes, "A Scandal in Bohemia"

4. What Is Data Mining? • Data mining (knowledge discovery in databases): • A process of identifying hidden patterns and relationships within data (Groth) • Data mining: • Extraction of interesting (non-trivial,implicit, previously unknown and potentially useful)information or patterns from data in large databases

5. Multidisciplinary Statistics Pattern Recognition Neurocomputing Machine Learning AI Data Mining Databases KDD

6. Architecture of a Typical Data Mining System Graphical user interface Pattern evaluation Data mining engine Knowledge-base Database or data warehouse server Filtering Data cleaning & data integration Data Warehouse Databases

7. A Data Mining example:The Home Equity Loan Case • The analytic goal is to determine who should be approved for a home equity loan. • The target variable is a binary variable that indicates whether an applicant eventually defaulted on the loan. • The input variables are variables such as the amount of the loan, amount due on the existing mortgage, the value of the property, and the number of recent credit inquiries.

8. HMEQ case overview • The consumer credit department of a bank wants to automate the decision-making process for approval of home equity lines of credit. To do this, they will follow the recommendations of the Equal Credit Opportunity Act to create an empirically derived and statistically sound credit scoring model. The model will be based on data collected from recent applicants granted credit through the current process of loan underwriting. The model will be built from predictive modeling tools, but the created model must be sufficiently interpretable so as to provide a reason for any adverse actions (rejections). • The HMEQ data set contains baseline and loan performance information for 5,960 recent home equity loans. The target (BAD) is a binary variable that indicates if an applicant eventually defaulted or was seriously delinquent. This adverse outcome occurred in 1,189 cases (20%). For each applicant, 12 input variables were recorded.

9. The HMEQ Loan process • An applicant comes forward with a specific property and a reason for the loan (Home-Improvement, Debt-Consolidation) • Background info related to job and credit history is collected • The loan gets approved or rejected • Upon approval, the Applicant becomes a Customer • Information related to how the loan is serviced is maintained, including the Status of the loan (Current, Delinquent, Defaulted, Paid-Off)

10. Loan Status Balance Reason MonthlyPayment Approval Date Applies for HMEQ Loan on… using… APPLICANT PROPERTY becomes OFFICER ACCOUNT CUSTOMER has HISTORY The HMEQ LoanTransactional Database • Entity Relationship Diagram (ERD), Logical Design:

11. HMEQLoanApplication Applicant Property Account History OFFICERID APPLICANTID PROPERTYID LOAN REASON DATE APPROVAL APPLICANTID NAME JOB DEBTINC YOJ DEROG CLNO DELINQ CLAGE NINQ PROPERTYID ADDRESS VALUE MORTDUE ACCOUNTID CUSTOMERID PROPERTYID ADDRESS BALANCE MONTHLYPAYMENT STATUS HISTORYID ACCOUNTID PAYMENT DATE Customer Officer CUSTOMERID APPLICANTID NAME ADDRESS OFFICERID OFFICERNAME PHONE FAX HMEQ Transactional database:the relations • Entity Relationship Diagram (ERD), Physical Design:

12. The HMEQ LoanData Warehouse Design • We have some slowly changing attributes: HMEQLoanApplication: Loan, Reason, Date Applicant: Job and Credit Score related attributes Property: Value, Mortgage, Balance • An applicant may reapply for a loan, then some of these attributes may have changed. • Need to introduce “Key” attributes and make them primary keys

13. The HMEQ LoanData Warehouse Design STAR 1 – Loan Application facts • Fact Table: HMEQApplicationFact • Dimensions: Applicant, Property, Officer, Time STAR 2 – Loan Payment facts • Fact Table: HMEQPaymentFact • Dimensions: Customer, Property, Account, Time

14. HMEQApplicationFact Applicant Property APPLICANTKEY PROPERTYKEY OFFICERKEY TIMEKEY LOAN REASON APPROVAL APPLICANTKEY APPLICANTID NAME JOB DEBTINC YOJ DEROG CLNO DELINQ CLAGE NINQ PROPERTYKEY PROPERTYID ADDRESS VALUE MORTDUE HMEQPaymentFact Account Time Customer Officer CUSTOMERKEY PROPERTYKEY ACCOUNTKEY TIMEKEY BALANCE PAYMENT STATUS ACCOUNTKEY LOAN MATURITYDATE MONTHLYPAYMENT OFFICERKEY OFFICERID OFFICERNAME PHONE FAX CUSTOMERKEY CUSTOMERID APPLICANTID NAME ADDRESS TIMEKEY DATE MONTH YEAR Two Star Schemas for HMEQ Loans

15. The HMEQ Loan DW:Questions asked by management • How many applications were filed each month during the last year? What percentage of them were approved each month? • How has the monthly average loan amount been fluctuating during the last year? Is there a trend? • Which customers were delinquent in their loan payment during the month of September? • How many loans have defaulted each month during the last year? Is there an increasing or decreasing trend? • How many defaulting loans were approved last year by each loan officer? Who are the officers with the largest number of defaulting loans?

16. The HMEQ Loan DW:Some more involved questions • Are there any patterns suggesting which applicants are more likely to default on their loan after it is approved? • Can we relate loan defaults to applicant job and credit history? Can we estimate probabilities to default based on applicant attributes at the time of application? Are there applicant segments with higher probability? • Can we look at relevant data and build a predictive model that will estimate such probability to default on the HMEQ loan? If we make such a model part of our business policy, can we decrease the percentage of loans that eventually default by applying more stringent loan approval criteria?

17. Property Applicant PROPERTYKEY PROPERTYID ADDRESS VALUE MORTDUE APPLICANTKEY APPLICANTID NAME JOB DEBTINC YOJ DEROG CLNO DELINQ CLAGE NINQ HMEQPaymentFact HMEQApplicationFact CUSTOMERKEY PROPERTYKEY ACCOUNTKEY TIMEKEY BALANCE PAYMENT STATUS APPLICANTKEY PROPERTYKEY OFFICERKEY TIMEKEY LOAN REASON APPROVAL Officer Account Customer OFFICERKEY OFFICERID OFFICERNAME PHONE FAX CUSTOMERKEY CUSTOMERID APPLICANTID NAME ADDRESS ACCOUNTKEY LOAN MATURITYDATE MONTHLYPAYMENT Time TIMEKEY DATE MONTH YEAR Selecting Task-relevant attributes

18. HMEQ final task-relevant data file

19. HMEQ: Modeling Goal • The credit scoring model should compute the probability of a given loan applicant to default on loan repayment. A threshold is to be selected such that all applicants whose probability of default is in excess of the threshold are recommended for rejection. • Using the HMEQ task-relevant data file, three competing models will be built: A logistic Regression model, a Decision Tree, and a Neural Network • Model assessment will allow us to select the best of the three alternative models

20. Predictive Modeling Inputs Target ... ... ... ... ... ... Cases ... ... ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...

21. IntroducingSAS Enterprise Miner (EM)

22. The SEMMA Methodology • Introduced By SAS Institute • Implemented in SAS Enterprise Miner (EM) • Organizes a DM effort into 5 activity groups: Sample Explore Modify Model Assess

23. Input Data Source Sampling Data Partition Sample

24. Distribution Explorer Multiplot Insight Association Variable Selection Link Analysis Explore

25. Data Set Attributes Transform Variables Filter Outliers Replacement Clustering Self-Organized Maps Kohonen Networks Time Series Modify

26. Regression Tree Neural Network Princomp/ Dmneural User Defined Model Ensemble Memory Based Reasoning Two-Stage Model Model

27. Assessment Reporter Assess

28. SAS EM Demo: HMEQ Case