IS then assigns a programmer to write a program to produce the report. The report can be created in a few days or, in extreme cases, in over a year. With a warehouse, users create most of their reports themselves. Thus, if a manager needs a report for a meeting in half an hour, they, or their assistant, can create that report in a matter of minutes. Organizations turn to warehouses to answer a limitless variety of questions and in almost all fields.
Many companies make the mistake of trying to put a value on their data warehouse.
The truth is the value of the warehouse stems from the new and changed business processes that it enables. Thus, in developing a warehouse it is extremely important to envision who is going to use the warehouse, how they will use it and why using it will improve upon the current process. It is not unusual for well considered and designed warehouses to generate first year ROIs of 100 to 400 percent. The value of the the new business processes can be determined by comparing the costs with the expected benefits. Warehouses gather and report data that already exists.