Friday, June 30, 2006 8:23 PM
srinathv
Just Released: Architecture and Design Guidelines for BI Apps

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.
About this Release
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 etc)
· This final release includes Data Mining guidelines chapter.
Roadmap
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
Spread the message: Consider using below template (as starting point) to spread the word through blogs, DLs, forums, etc.
The patterns & practices team is please to announce the availability of Architecture and Design Guidelines for Business Intelligence Applications. This exploratory community project 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 on the Microsoft .NET Framework using SQL Server 2005 - Integration Services and Analysis Services. Being an exploratory community project - anticipate gaps and scope for improvement. For more information see: http://codegallery.gotdotnet.com/biguide.
A special thanks to my team
o Dev architect: Chakrapani Kotipalli (Tata Consultancy Services)
o Test: Mohammad Al-Sabt and Balaji Venugopal (Infosys Technologies Ltd)
o Tech writer: Reed Jacobson (Hitachi Consulting)
Thx - Srinath