December 2012
Beginner to intermediate
845 pages
23h 33m
English
book
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
by Dejan Sarka, Grega Jerkic, Matija Lah
Content preview from Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...