SSIS and Advanced Analytics

In this chapter, we will cover the following recipes:

• Splitting a dataset into a training and test set
• Testing the randomness of the split with a SSAS decision tree model
• Preparing a Naive Bayes SSAS data mining model
• Querying the SSAS data mining model with the data mining query transformation
• Creating an R data mining model
• Using the R data mining model in SSIS
• Text mining with term extraction and term lookup transformations