O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required