Data Warehousing Processes


Data Warehousing > Processes

After the tools and team personnel selections are made, the data warehouse project can begin. The following are the typical processes involved in the datawarehousing project cycle.

Each page listed below represents a typical data warehouse phase, and has several sections:

  • Task Description: This section describes what typically needs to be accomplished during this particular data warehouse phase.
  • Time Requirement: A rough estimate of the amount of time this particular data warehouse task takes.
  • Deliverables: Typically at the end of each data warehouse task, one or more documents are produced that fully describe the steps and results of that particular task. This is especially important for consultants to communicate their results to the clients.
  • Possible Pitfalls: Things to watch out for. Some of them obvious, some of them not so obvious. However, all of them are real.

The Additional Observations section contains my own observations on data warehouse processes not included in any of the step.

Feel free to contact me about additional information regarding data warehousing that I should include.

Data Warehousing Home Page Next Section: Requirement Gathering