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

Course Outline

1: Using functions to cleanse and enrich dataUse date functionsUse conversion functionsUse string functionsUse statistical functionsUse missing value functions

2: Using additional field transformationsReplace values with the Filler nodeRecode continuous fields with the Binning nodeChange a field’s distribution with the Transform node

3: Working with sequence dataUse sequence functionsCount an event across recordsExpand a continuous field into a series of continuous fields with the Restructure nodeUse geospatial and time data with the Space-Time-Boxes node

4: Sampling, partitioning and balancing dataDraw simple and complex samples with the Sample nodeCreate a training set and testing set with the Partition nodeReduce or boost the number of records with the Balance node

5:  Improving efficiencyUse database scalability by SQL pushbackProcess outliers and missing values with the Data Audit nodeUse the Set Globals nodeUse parametersUse looping and conditional execution

Objective

Using functions to cleanse and enrich data

Using additional field transformations

Working with sequence data

Sampling, partitioning and balancing data

Improving efficiency