In this section

Share this page

IBM Certified Associate - SPSS Modeler Data Analysis v2

The TM1 Analyst is responsible for manipulating business data to discover and understand trends and exceptions, and for performing predictive analysis for an IBM Cognos TM1 model.


  • Intermediate/Advanced competency in Microsoft Excel
  • Basic understanding of relational databases
  • Basic understanding of multidimensional data

Recommended Training and Required Exam(s)

 Required Exam Recommended Training 
BAS-012: IBM SPSS Modeler Data Analysis for Business Partners v2
  • Introduction to IBM SPSS Modeler and Data Mining (V14.2) (0A003G)
  • Introduction to IBM SPSS Modeler and Data Mining (V15) (0A004G)
  • Advanced Data Preparation Using IBM SPSS Modeler (V15) (0A054G)

Skills acquired during recommended training

Business Understanding

  • Review the CRISP methodology

General Operations in Modeler

  • Build streams
  • Run streams
  • Read different types of files into Modeler

Data Understanding

  • Extent of missing data
  • Outliers
  • Field distribution and summary statistics
  • Auto checking for missing and out of bounds data
  • Bivariate relationships between variables

Data Preparation

  • Create new variables with the Derive Node
  • Create new variables with the Reclassify Node
  • Combine data files
  • Restructure data
  • Aggregate data
  • Remove duplicates
  • Sampling cases
  • Balance data
  • Data caching
  • Partitione data
  • Missing Value replacement


  • Predictive models
  • Cluster models
  • Association models

NOTE: Business partners who take this exam are only expected to familiar with each class of model and the steps that are necessary to prepare the data prior creating the models in the software.