BI Architecture and Design Guidelines

Rating:        Based on 5 ratings
Reviewed:  1 review
Downloads: 82852
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 - 19259 downloads

Other Available Downloads

Documentation 01 - ReadMe-3.0.doc
documentation, 106K, uploaded Aug 22, 2007 - 6795 downloads
Source Code 04 - Data Extraction.doc
source code, 274K, uploaded Aug 22, 2007 - 8065 downloads
Source Code 05 - Data Staging.doc
source code, 108K, uploaded Aug 22, 2007 - 7064 downloads
Source Code 06 - Data Transformations.doc
source code, 580K, uploaded Aug 22, 2007 - 6959 downloads
Source Code 07 - Data Loading.doc
source code, 123K, uploaded Aug 22, 2007 - 6557 downloads
Source Code 08 - Dimensional Modeling.doc
source code, 260K, uploaded Aug 22, 2007 - 7911 downloads
Source Code 09 - Relational Partitions.doc
source code, 175K, uploaded Aug 22, 2007 - 6456 downloads
Source Code 10 - OnlineAnalyticalProcessing_OLAP.doc
source code, 231K, uploaded Aug 22, 2007 - 7178 downloads
Source Code 11 - Data Mining.doc
source code, 247K, uploaded Aug 22, 2007 - 6608 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