W1 Asig Datawarehouse Essay Example | Topics and Well Written Essays - 500 words

W1 Asig Datawarehouse - Essay Example ch, in one’s corporate setting where IT is deemed a crucial source of information and response to inquiries needed by other departments, especially by the marketing department, the apparently slow response could be attributed to the sources of information that needs to be tapped before it could be disseminated to end users. The model below clearly depicts the flow of information from operational systems to end users: From the conceptual framework, it could be deduced that the operational systems undergo a series of processes on the information or data upon solicitation: extraction, integration, cleansing, and transformation. This information is then stored in the organization’s data warehouse to serve varied needs and demands of the users. The cause of delays in soliciting data from the external environment could be diverse: from frequent changes in factors affecting the external environment to the need to update currently available information. As emphasized, â€Å"reports generated in high data volume environments normally take a long time to run. To speed up report generation, many systems use tools that employ a summarization technique to reduce the amount of records by aggregating records together with common characteristics. Problem with this technique includes inherent inflexibility and inability to cope with the constantly changing information needs of manufacturing† (MAIA Intelligence, 2009, p. 4). Overall, the information gathered by the IT department needs to be processed and transformed in the most accurate manner before being transformed and stored to the organization’s data warehouse. As such, the delay should be understandable given the volume of information from the external environment that needs to be summarized and integrated according to the users’ needs. Concurrently, experts in BI has asserted that â€Å"business leaders want to obtain real metrics and near-real-time, linked directly to the business processes, system data and insights