Book Image

IBM SPSS Modeler Essentials

By : Jesus Salcedo, Keith McCormick
Book Image

IBM SPSS Modeler Essentials

By: Jesus Salcedo, Keith McCormick

Overview of this book

IBM SPSS Modeler allows users to quickly and efficiently use predictive analytics and gain insights from your data. With almost 25 years of history, Modeler is the most established and comprehensive Data Mining workbench available. Since it is popular in corporate settings, widely available in university settings, and highly compatible with all the latest technologies, it is the perfect way to start your Data Science and Machine Learning journey. This book takes a detailed, step-by-step approach to introducing data mining using the de facto standard process, CRISP-DM, and Modeler’s easy to learn “visual programming” style. You will learn how to read data into Modeler, assess data quality, prepare your data for modeling, find interesting patterns and relationships within your data, and export your predictions. Using a single case study throughout, this intentionally short and focused book sticks to the essentials. The authors have drawn upon their decades of teaching thousands of new users, to choose those aspects of Modeler that you should learn first, so that you get off to a good start using proven best practices. This book provides an overview of various popular data modeling techniques and presents a detailed case study of how to use CHAID, a decision tree model. Assessing a model’s performance is as important as building it; this book will also show you how to do that. Finally, you will see how you can score new data and export your predictions. By the end of this book, you will have a firm understanding of the basics of data mining and how to effectively use Modeler to build predictive models.
Table of Contents (19 chapters)
Title Page
About the Authors
About the Reviewer
Customer Feedback

Derive – Flag

Deriving a field as a flag is similar to deriving a field as a formula except that the expression you create will ultimately result in one of two categorical values. One of the most common methods of deriving a field as a flag is to identify whether something of interest has occurred (for example, purchasing a product, visiting a website, and so on). In this example, we will take the Stock_numbers field and collapse it into those people who have an investment and those that do not:

  1. Place a Derive node onto the canvas.
  2. Connect the Stock_numbers node to the new Derive node.
  3. Edit the new Derive node.
  4. Type Investment in the Derive field textbox.
  5. Click Flag on the Derive as drop-down list.
  6. Click the Expression Builder button.
  7. Double-click on Stock_numbers in the Fields list box.
  8. Click the greater than (>) button.
  9. Type 0.
  1. Click OK:

This equation is saying that if someone has a value greater than zero on the field Stock_numbers, the Investment field will be assigned the value T, otherwise...