Report Portal

BI Architecture and Design Guidelines

About the Deliverable – The Architecture and Design Guidelines for BI Applications provides prescriptive guidance on how to overcome architectural challenges and design issues when building Business Intelligence solutions using Microsoft platform. This guide is intended for software architects and developers who are developing Business Intelligence applications using SQL Server 2005 - Integration Services and Analysis Services.

This final (and 4th) community release includes the following:

  • 400+ architecture and design guidelines
  • 10 Chapters (covering – Data Extraction, Staging, Transformation, Loading, Data Quality, Dimensional Modeling, Relational Partitioning, OLAP, Data Mining etc)


The patterns & practices team focused on this exploratory community project after speaking with the SQL BI Product Group, SQL Marketing and Field. Being an exploratory community project - we anticipate gaps and scope for improvement. There is still lot of work to be done; our goal was to seed the community with just enough information to raise the excitement level and provide an opportunity to grow. There are no planned updates to this project moving forward.

Content Authors:
Program Manager: Srinath Vasireddy (Microsoft)
Dev Architect: Chakrapani Kotipalli (Microsoft)


Tags: design, partition, dw


2007-2015 VidasSoft Systems Inc.