BI Architecture and Design Guidelines

Rating:        Based on 5 ratings
Reviewed:  1 review
Downloads: 83099
Released: Aug 21, 2007
Updated: Aug 22, 2007 by chakpani
Dev status: -not yet defined by owner-

Recommended Download

Source Code 02 - BI Intro and Frame.doc
source code, 137K, uploaded Aug 22, 2007 - 19295 downloads

Other Available Downloads

Documentation 01 - ReadMe-3.0.doc
documentation, 106K, uploaded Aug 22, 2007 - 6817 downloads
Source Code 04 - Data Extraction.doc
source code, 274K, uploaded Aug 22, 2007 - 8093 downloads
Source Code 05 - Data Staging.doc
source code, 108K, uploaded Aug 22, 2007 - 7091 downloads
Source Code 06 - Data Transformations.doc
source code, 580K, uploaded Aug 22, 2007 - 6983 downloads
Source Code 07 - Data Loading.doc
source code, 123K, uploaded Aug 22, 2007 - 6582 downloads
Source Code 08 - Dimensional Modeling.doc
source code, 260K, uploaded Aug 22, 2007 - 7933 downloads
Source Code 09 - Relational Partitions.doc
source code, 175K, uploaded Aug 22, 2007 - 6478 downloads
Source Code 10 - OnlineAnalyticalProcessing_OLAP.doc
source code, 231K, uploaded Aug 22, 2007 - 7199 downloads
Source Code 11 - Data Mining.doc
source code, 247K, uploaded Aug 22, 2007 - 6628 downloads

Release Notes

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)



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.

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

Reviews for this release

     
Where is the examples (code)?
by odeddror on Dec 19, 2008 at 2:36 PM