Friday, October 29, 2010

Documenting a DW & BI project - End to End

Just wanted to put my template somewhere, so that i can use it, when i need and someday someone else might find this useful.
When i find time, i should eloborate this..

I call this the proposal, the idea is to sell value and get a go ahead from the customer and get into the next phase, which is the requirements solicitation process. Assuming the presales part is done and we know a little about the customer and his pain and what will satisfy his BI appetite.

1. Background – About the customer
2. Current state of affairs – State his statements
3. Pain points / Restrictions – Elicit, Probe
4. Proposed Solution - Formulate
Data Warehousing and Business Intelligence Architecture
Technology – Choices / Alternates
Reporting, AdHoc Reporting, Dashboarding and other BI delivery mechanisms
5. THE VALUE to the customer after the implementation
6. Future state, extendability and scalability