Databases Reference
In-Depth Information
include the responsibility to advocate, implement, and help others work
toward enterprise data warehousing goals. There are several different ways
that this can be handled organizationally. This section shares two examples.
The Centralized Enterprise Data Warehouse Team
With this structure, the enterprise data warehouse personnel report directly to
an enterprise group. While the staff members belong to the enterprise team,
each person is assigned to and works on specific data warehouse projects. This
ensures that they have a continued role in actively developing and delivering
value to the organization. It also enables each to leverage his or her experience
and mentor the project team while keeping an eye on what is best for the
overall data warehouse initiatives across the organization. Figure 13-1 shows
how the centralized data warehouse team is organized.
Standard
Organizational
Reporting Structure
Project A
Project B
Project C
Project D
Project E
Project F
Figure 13-1
Centralized enterprise DW team structure
The Virtual Enterprise Data Warehouse Team
The virtual enterprise data warehouse team is similar in function to a central-
ized team but it is organized differently. The highly skilled data warehouse
staff members are full-time members of project teams and have the same man-
agement chain as all other project team members. These key data warehouse
people have dotted-line responsibility to the enterprise data warehouse team.
Highly skilled data warehouse resources are leveraged on each project. A por-
tion of their time must be allocated to enterprise data warehouse work. This
work must not be pushed aside. Figure 13-2 shows how the virtual enterprise
data warehouse team is organized.
