Description:
Your in-depth guide to using the new Microsoft(r) data mining standard to solve today's business problems
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, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects.
You'll learn:
- The principal concepts of data mining
- How to work with the data mining algorithms included in SQL Server data mining
- How to use DMX-the data mining query language
- The XML for Analysis API
- The architecture of the SQL Server 2005 data mining component
- How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms
- How to implement a data mining project using SQL Server Integration Services
- How to mine an OLAP cube
- How to build an online retail site with cross-selling features
- How to access SQL Server 2005 data mining features programmatically
Table of Contents:
About the Authors.
Credits.
Foreword.
Chapter 1: Introduction to Data Mining.
Chapter 2: OLE DB for Data Mining.
Chapter 3: Using SQL Server Data Mining.
Chapter 4: Microsoft Naïve Bayes.
Chapter 5: Microsoft Decision Trees.
Chapter 6: Microsoft Time Series.
Chapter 7: Microsoft Clustering.
Chapter 8: Microsoft Sequence Clustering.
Chapter 9: Microsoft Association Rules.
Chapter 10: Microsoft Neural Network.
Chapter 11: Mining OLAP Cubes.
Chapter 12: Data Mining with SQL Server Integration Services.
Chapter 13: SQL Server Data Mining Architecture.
Chapter 14: Programming SQL Server Data Mining.
Chapter 15: Implementing a Web Cross-Selling Application.
Chapter 16: Advanced Forecasting Using Microsoft Excel.
Chapter 17: Extending SQL Server Data Mining.
Chapter 18: Conclusion and Additional Resources.
Appendix A: Importing Datasets.
Appendix B: Supported VBA and Excel Functions.
Index.