Excellent BI Architecture and Design guide from Microsoft

Here is an excellent and well formulated BI Architecture and Design guide from Microsoft (Patterns and Practices group) . Well, this is bit old (targeted for SQL Server 2005 ) but the concepts are explained well in detail and it is worth reading in my opinion.

Download guide from CodePlex:  http://biarchanddesignguide.codeplex.com/

The guide covers the following topics

• BI Framework
• Data Extraction
• Data Staging
• Data Transformations and Data Quality
• Data Loading
• Dimensional Modeling
• Data Partitions
• Online Analytical Processing (OLAP)
• Data Mining

Hope you all will enjoy reading the guide.