{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Technical support complaints and age of the equipment

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: age of the equipment. You can import data sources from a variety of formats including SAS tables, relational databases, and Microsoft Office Excel spreadsheets. Figure 1. Churn Modeling Table SAS Rapid Predictive Modeler is included in SAS Enterprise Guide and SAS Add-In for Microsoft Office not only because these are common interfaces for business analysts who are not experienced SAS programmers but also because these products include a complementary set of data preparation, summarization, exploration and reporting tasks to support the SAS Rapid Predictive Modeler analysis. Before you build a SAS Rapid Predictive Modeler model, you might want to use tasks such as Characterize Data and Scatter Plot to summarize and explore your data to understand trends and anomalies. Often in data mining the target variable contains a rare event; for example, if only 5% of your customers churn for a new offer, you want to make sure that you have a significant number of these customers in your data set. You might want to oversample your data to make sure you select all customers who churned and an equal number of customers who did not churn. Oversampling makes it easier for the model to find a stable solution. Figure 2 displays the results of the One-Way Frequencies task, which indicate that the proportion of churners to non-churners is about equal. Because the data have been oversampled, you want to specify prior probabilities in the task as described in the next section of this analysis. 3 SAS Global Forum 2010 Customer Intelligence Figure 2. One-Way Frequencies for the Target Churn BUILDING A CHURN CLASSIFICATION MODEL SAS Rapid Predictive Modeler can be executed from within SAS Enterprise Guide or the SAS Add-In for Microsoft Office. The task is identical in either product and requires a SAS Enterprise Miner license. Figure 3 shows that the SAS Rapid Predictive Modeler task is organized along with the model scoring task within the Data Mining group. Many business analysts prefer to work directly in Microsoft Office Excel. One benefit of using SAS Enterprise Guide is that it provides project-based storage for your analyses along with a process flow diagram to manage the steps in your analysis. Figure 3. Invoking the SAS Rapid Predictive Modeler Task within SAS Enterprise Guide 4 SAS Global Forum 2010 Customer Intelligence SAS Rapid Predictive Modeler prompts you for the input data source if an active data set is not already defined. Figure 4 shows the Data panel of the SAS Rapid Predictive Modeler task. You assign modeling roles by dragging them from the Inputs Variables list to the appropriate Modeling Roles list. You are only required to specify the dependent variable (target) from your table that represents the value that you want to predict. The SAS Rapid Predictive Modeler automatically decides whether variables are continuous or categorical. The SAS Rapid Predictive Modeler automatically sets all variables as input variables (predictors), which is very co...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online