Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, Data Mining with SQL Server 2005, by ZhaoHui Tang and Jamie MacLennan, shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets.
Here we offer you Chapter 3, 'Using SQL Server Data Mining,' courtesy of Wiley Publishers.
This chapter will review the Analysis Services toolset and provide techniques to effectively create and analyze mining models. Before reading this chapter, you should understand the concept of a mining model, mining model columns, and case and nested tables. This chapter is designed to help novice users get started and provide experienced users with techniques that will help them get the most out of the toolset. This is not meant to be a substitute or a replacement for the excellent documentation and tutorials found in the product documentation. Rather, it describes and applies the general tools provided with Analysis Services specifically for data mining purposes.
The following table of contents will help you navigate this chapter:
- Using the Business Intelligence Development Studio
- Understanding immediate mode and offline mode
- Creating data mining objects: Data sources
- Working with named calculations
- Working with named queries
- Exploring data
- Using the Data Mining Wizard
- Using the Data Mining Designer
- Using the Mining Accuracy Chart
- Using the Mining Model Prediction Builder
- Creating data mining reports
- Using SQL Server Management Studio
Click to purchase Data Mining with SQL Server 2005.