Question

1. How did implementing a data warehouse help American Water move toward a more centralized organization?
2. Give some examples of problems that would have occurred at American Water if its data were not "clean"?
3. How did American Water's data warehouse improve operations and management decision making?

Answer 1

1. Enterprise resource planning (ERP) framework intended to supplant unique frameworks with a solitary coordinated software platform. Data warehouse enables the organization to institutionalize the data and dispose of the defective data. All data relating to materials utilized by the organization were institutionalized to make the data warehouse progressively effective and to give a combined view over all specialty units. Institutionalized data gave the organization a superior picture of how it was performing and simpler to comprehend rather than untidy data which isn't institutionalize and it may cause misjudging and issue of low exactness.

2. On the off chance that the data are not spotless, it makes the data warehouse a lot bigger than would normally be appropriate. For example, a specific sort of material may have a few distinct data depictions. Examinations and union of the data are progressively hard to make when there are more than one portrayal and meaning of every datum thing. It might confound the clients and cause the issue of low exactness of data.

3. American Water is concentrating on advancing that data must be "perfect" to be successful and has poured a staggering measure of exertion into its data purifying work by recognizing deficient, mistaken, off base, and superfluous bits of data and afterward supplanting, altering, or erasing the "messy" data. By having clean data in a solitary data warehouse that is effectively open and reports are anything but difficult to create, management and clients can settle on better choices because the data are progressively finished. Clean data gives a vastly improved image of the association and a more clear heading for management. Data mining is a lot simpler and increasingly complete with clean data. By executing the data warehouse, the entire organization and its auxiliaries had the option to institutionalize their business forms with the goal that they were all entering data similarly thus the work can be progressively solid and making more qualities to the organization.