This is an excerpt from one of the business intelligence chapters I wrote for the SharePoint Server 2007 Best Practices book, original reference is at: -