- Question Completion State Question 36 Case Study: Read the "ABC" case and answer the questions given below marks) ABC Water Corporation ("ABC"), the largest public water uity in USA provides in www.iw states. Until recently. ABC Water's systems and business process were very localized and many of two became increasingly difficult to manage. Mary wysta were not integrated so that running any type of reported to prodon continue heavily manual process. Dat had to be extracted from the systems supporting gach region and the commerce des business process and enterprise-wide reporting. The first step toward achieving this business more Show Management wanted to change the comparvy from a decentralized group of independent IS ERP other was An important step of this project was to migrate the data from ABC Water's old systems to the www pom. The compte syum formats. Each regional business maintained some of his own data in is own systems, and a portion of wis Was wunday cleansing will be required. For example, ABC Water had dala on more than 70.000 vendors in Wevedot asin dan Andrew Claren, NBC W asked business users to define an active vendor and to use that definition to identity which data to migrate Honowe Won Huncionales towards present address data. One of the objectives of ABC Water's data management work was to support an enterpride business Intelligere promueven analytical system and data warehouse would be able to combine data from the SAP ERP System with data from our wurde ding woman asset management systems. That meant that ABC Water's business users had to do a lot of thinking about kinds of reports they want. They have the system provide 200 reports but later reduced that number by hall Business users were waived to get the reports totum. More tried to create their reports using Microsoft Excel spreadsheet software. Over time, however, they wamed to do the same thing wing SAP Business ligeronto the system. SAP Business Intelligence is a set of tools that enables business users to view, sort, and walze business whence and tools to in reports, and interactive dashboards At present, ABC Water is focusing on promoting the idea that data must be clear to be effective and has poured an incredible amount of contents and identifying incomplete, incorrect, inaccurate, and irrelevant pieces of data and then replacing, moodying, or deleting the onda (EQ1) How did implementing a data warehouse help "ABC" Water move toward a more centralized organization? (2 marks (EQ2) Give two simple examples of problems that would have occurred at "ABC Water it ts data were not clean? (1 mark) (EQ3) How did "ABC" Water's data warehouse improve operations and management decision-making? (2 marks) When writing your answer, clearly indicate your question number by stating (EQ1). (EQ2), or (E03). For the toolbar, press ALT+F10 (Por ALTFNF10 (Mach. DAN ANG