Databases Reference
In-Depth Information
Write up interviews and review with interviewees
Consolidate interview results
Review data requirements
Develop User Requirements Definition Document
Develop Dimensional Data Model Tasks
The Develop Dimensional Data Model task consists of a number of subtasks directed
at defining the end user's view of the data. This Dimensional Data Model is used as
the foundation for both designing the logical database and configuring Business
Intelligence Tool Metadata. The following subtasks are included:
Analyze business data elements from two data sources.
Identify the business dimensions and attributes.
Determine the relationships between attributes within each dimension.
Identify business facts needed.
Determine dimensionality of fact columns.
Document Dimensional Data Model.
Project Completion Criteria
This project will be complete when all of the following deliverables have been completed
and approved by the Business Executive Sponsor and the IT sponsor.
<Insert the list of deliverables listed in the project charter. Update the list
if additional deliverables have been identified.>
Statement of Work Approval
Executive Business Sponsor
IT Sponsor
Figure 5-3
(continued)
The first step in developing a statement of work is determining what tasks
need to be included. The second step is estimating the effort and cost to
complete this work. This must be done prior to gaining full approval for the
project.
How Much Will It Cost?
Data warehousing is not cheap. It requires the investment of many resources,
especially key individuals across the organization. Without leveraging the
appropriate business staff, the organization may never see a return on the
investment spent on hardware and software. Don't just buy things; you must
invest time and energy participating in the project. The work involved is
described throughout the rest of the topic.
If this is your first data warehouse project, the technical foundation must be
put in place. The investment in hardware and software must be made to get
started. The platforms and technologies selected need to support growth and
