Data Warehouse Solution

Every one of the past attempts at providing strategic information to decision makers was unsatisfactory. The cycle of strategic information provision in the past always revolve in these phases :

1. User needs information
2. User requests reports from IT
3. IT places request on backlog
4. IT creates ad hoc queries
5. IT sends requested reports
6. User hopes to find the right answer, if not then return to #1

Here are some of the factors relating to the inability to provide strategic information:

• IT receives too many ad hoc requests, resulting in a large overload. With limited resources, IT is unable to respond to the numerous requests in a timely fashion.
• Requests are not only too numerous, they also keep changing all the time. The users need more reports to expand and understand the earlier reports.
• The users find that they get into the spiral of asking for more and more supplementary reports, so they sometimes adapt by asking for every possible combination, which only increases the IT load even further.
• The users have to depend on IT to provide the information. They are not able to access the information themselves interactively.
• The information environment ideally suited for making strategic decision making has to be very flexible and conducive for analysis. IT has been unable to provide such an environment.

Similar Posts:

• The Compelling Need For Data Warehousing
• Defining Features Of Data Warehouse
• Six Sigma in Data Warehouse
• What is ETL in Data Warehouse?