SQL Server Data Mining

Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio

This article—SQL Server Data Mining—is from Practical Business Intelligence with SQL Server 2005, by John C. Hancock, Roger Toren. Copyright © 2007 Pearson Education, Inc. All rights reserved. Reproduced by permission. This article has been edited especially for C# Online.NET.  Read the book review!

This sample chapter looks at how to use some of the data mining features in SQL Server Analysis Services 2005 to perform tasks such as customer segmentation and market basket analysis. The data mining results are presented in the form of new dimensions in cubes and are used in Web applications.

Data Mining

As you have seen, Analysis Services enables you to build powerful Business Intelligence (BI) solutions that enable users to really understand the business. However, many business problems rely on the ability to spot patterns and trends across data sets that are far too large or complex for human analysts. Data mining can be used to explore your data and find these patterns, allowing you to begin to ask why things happen and to predict what will happen in the future.

In this chapter, we look at how to use some of the data mining features in Analysis Services 2005 to perform tasks such as customer segmentation and market basket analysis. The data mining results are presented in the form of new dimensions in cubes and are used in Web applications.