The data warehouse project plan is a bit of a misnomer, because the data warehouse is really more a service than a project.
There was, however, a considerable amount of up-front work required to get started. This consisted mainly in:
- Identifying and training a database administrator
- Selecting technology platforms to use, and training the data warehouse technical project team in those platforms
- Deploying key supporting infrastructure, such as database servers and data-migration tools
- Identifying an oversight committee, who could assist with prioritization and publicity
- Forming a data management committee
- Creating a data management policy
- Conducting business requirements analysis
- Selecting a first subject area, i.e., a first area of the data warehouse to build
- Selecting a desktop deployment methodology and an initial set of desktop software to give to users
- Initial production of a data dictionary
These steps were completed as of March 1, 2009, although many of them will be revisited and adjusted periodically throughout the lifetime of the data warehouse service. This is particularly true, e.g., for technology selection, training, requirements analysis, and the selection of desktop deployment methodologies.