Practical Business Intelligence book

Our new book Practical Business Intelligence with SQL Server 2005 is now available! You can find the sample files for the book in the Downloads section.  Here is an excerpt from the back cover...

In this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.

Sample chapter

You can now download Chapter 10 of Practical Business Intelligence, which covers Data Mining.  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.

Analyzing data gathered using Groove forms

My latest article in MSDN Magazine, Help Teams Work Together With Web Services And Groove 2007, shows how to gather data from researchers using Groove and load it into a SQL Server database for further analysis.

Reporting Services article

Read my article in MSDN Magazine, Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services.

Blogs

Check my blog for new information on building business intelligence solutions with SQL Server 2005.