0A058G - Advanced Data Preparation Using IBM SPSS Modeler (v18.1.1)

1: Using functions to cleanse and enrich data

• Use date functions
• Use conversion functions
• Use string functions
• Use statistical functions
• Use missing value functions

2: Using additional field transformations

• Replace values with the Filler node
• Recode continuous fields with the Binning node
• Change a fields distribution with the Transform node

3: Working with sequence data

• Use sequence functions
• Count an event across records
• Expand a continuous field into a series of continuous fields with the Restructure node
• Use geospatial and time data with the Space-Time-Boxes node

4: Sampling, partitioning and balancing data

• Draw simple and complex samples with the Sample node
• Create a training set and testing set with the Partition node
• Reduce or boost the number of records with the Balance node

5: Improving efficiency

• Use database scalability by SQL pushback
• Process outliers and missing values with the Data Audit node
• Use the Set Globals node
• Use parameters
• Use looping and conditional execution