Chapter 18. SSIS and Data Mining
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Data mining is the most advanced part of a BI solution. Data mining should actually stand for the “I” in “BI.” With data mining algorithms, you can automatically discover previously unknown patterns and rules in your data. Microsoft SQL Server Integration Services (SSIS) can use predictive models through the Data Mining Query task and transformation in the control flow or data flow of a package. You can add predictions from the mining model to your data. In addition, SSIS implements text mining through the Term Extraction and Term Lookup transformations.
In order to create a good mining model, you need to work on data preparation. You can ...
Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
