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

  • Tuition USD $825
  • Reviews star_rate star_rate star_rate star_rate star_half 1172 Ratings
  • Course Code 0A058G
  • Duration 1 day
  • Available Formats Classroom, Virtual
This course is available in other formats
Advanced Data Preparation Using IBM SPSS Modeler (v18.1.1) SPVC (0E058G-SPVC)

This course covers advanced topics to aid in the preparation of data for a successful data science project. You will learn how to use functions, deal with missing values, use advanced field operations, handle sequence data, apply advanced sampling methods, and improve efficiency.

Skills Gained

Using functions to cleanse and enrich data

Using additional field transformations

Working with sequence data

Sampling, partitioning and balancing data

Improving efficiency

Who Can Benefit

This advanced course is intended for anyone who wants to become familiar with the full range of techniques available in IBM SPSS Modeler for data preparation.


- Experience using IBM SPSS Modeler including familiarity with the Modeler environment, creating streams, reading data files, exploring data, setting the unit of analysis, combining datasets, deriving and reclassifying fields, and basic knowledge of modeling.
- Prior completion of the Introduction to IBM SPSS Modeler and Data Science course is recommended.

Course Details

Course Outline

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 field- s 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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great instruction on AWS DevOps, even added more to the presentation for better understanding. The teacher was well informed and technically savvy to assist students on the fly through hiccups.

need to work on your evantage digital book, you can't get to individual pages without scrolling through entire book.

I thought the labs and content were helpful in understanding the services associated with devops

The course material and instructor were very good. easy to follow, lab was setup nicely and was able to complete most of the lab material.
The Koretex App is absolute garbage and very cumbersome to use on a tablet/ipad. A PDF file would be 100 times better than that atrocious app.
As a recommendation this class should be 5 days instead of 4 as some chapters had to be rushed.

The course is perfectly designed with material and labs to get hands on experience on AWS, nicely done!

1 options available

  • Jan 29, 2021 Jan 29, 2021 (1 day)
    9:30AM 5:30PM EST
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward