Data & Intelligence

Selecting your Modeling Approach with IBM SPSS Modeler

Coming from a TM1 background (more business than statistics), it is easy to get stated with modeling once you determine your modeling objective, and Modeler can help with that. IBM SPSS Modeler offers an intuitive interface that will appeal to a wide range of users from the non-technical business user to the statistician, data miner or data scientist.

Modeling Objective

IBM SPSS Modeler uses “node definitions” to easily add objects to modeling streams. These nodes include data sources, record and field operations, graphing, output/export and of course, modeling. These many modeling nodes (found on the Modeling palette) can be classified depending on what your modeling objective is.

SPSS categorizes modeling objectives into three main – Classification, Segmentation and Association.

Classification

With a classification model, you are trying to predict a field, using one or more predictors. Examples would include trying to predict which telecommunications customers are liable to drop their plan and go to another provider and in banking, predicting if a customer might fail on paying back a loan.

Segmentation

With a Segmentation model, grouping records (using one or more fields) is the idea.  For example a marketing group may “cluster” customers based upon RFM (Recency, Frequency and Monetary values) and insurance companies may cluster claims and look for unusual cases within the groups to detect fraud.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

Association

Association models look for relationships between fields to try to find the “rules of the format”, for example: a certain percentage of customers have purchased both products “A” and product “B” and those customers also have purchased product “C”.

Once you determine which type of model you ar interested in you are ready to being modeling (with the assistance of SPSS).

Help

The SPSS Modeling palette can be organized by selecting one of the three objectives. When you make a selection, Modeler will “suggest” the modeling nodes that are applicable to that selection – which is great for us TM1 guys new to modeling with SPSS Modeler!

zz1

 

 

 

Conclusion

Once you have determined where your objective “fits” you’ll see that more than just one model “type”
can be used. Keep in mind that the business context (objective) will be the first decider in the choice of a model type, but other factors will also influence the decision such as:

  • How missing values should be handled
  • How categorical predictors should be handled
  • How continuous predictors should be handled
  • How will a particular model score data?

But in the end, it is always the business user, balancing all pros and cons, who will decide which model, should be used.

About the Author

Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up