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

W1 Asig Datawarehouse - Essay Examplech, in ones corporate setting where IT is deemed a life-or-death source of information and response to inquiries collected by other departments, especially by the marketing department, the apparently slow response could be attributed to the sources of information that of necessity 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 usersFrom the conceptual framework, it could be deduced that the operational systems abide a series of processes on the information or data upon solicitation extraction, integration, cleansing, and transformation. This information is then stored in the organizations data warehouse to armed service 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 avai lable 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 indispensable 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 modify in the most accurate manner before being transformed and stored to the organizations data warehouse. As such, the delay should be understandable given(p) 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 start real metrics and near-real-time, linked directly to the bu siness processes, system data and insights