27-07-2012, 04:35 PM
ware house components
Warehouse Components.ppt (Size: 136.5 KB / Downloads: 23)
The Business Dimensional Lifecycle
Project Planning Early Critical Tasks
definition
scope
readiness assessment
business justification
Remaining Tasks
Resource requirements and identification
Schedule construction and integrations
Deployment
The integration of all the pieces of the puzzle.
The best warehouse will fail if deployment is not properly planned
Plan required prior to deployment are:
education
user support
feedback
enhancement/maintenance
Project Planning & Management
Who Wants the Warehouse?
A single visionary user
desirable because the focus remains manageable
requires political leverage to make it work
the need must have broad and definable impacts to show worth
Multiple demands
Many organizations want a data mart or warehouse
Focus is spread, therefore politics and planning play a vital role
Develop the Initial Scope (cont)
Document the scope definition and success indicators
Acknowledge that the scope will likely change
Develop a plan to manage the change
Collecting the Requirements
This is a difficult process for many reasons.
Key people may feel threatened and are not willing to cooperate.
The informal decision process is typically not well documented and is dispersed.
People have a difficult time thinking “out of the box”
Terminology associated to warehousing often creates confusion and/or misinformation
The Bus
Look at the entire enterprise as you design and build the data marts
A high level architecture must be defined that explains the entire structure
A detailed architecture must be developed to support each data mart as they are confronted