American Water Keeps Data Flowing (Page 275)

1.Discuss the role of information policy, data administration, and efforts to ensure data quality in improving data management at American Water.
(1)In the rebuilding procedure of America Water business forms, especially it included three noteworthy exercises by which every one of them had given critical contribution(s) in building up valid information administration.
(2)In particular data strategy, information organization and (business) endeavors are the basic exercises, which had empowered the creation and fuse of solid information administration of American Water.
(3)On the one hand, the development of new data approach where administration chose to modify association's business forms from decentralized into unified structure was crucial in building establishment of tried and true information administration.
(4)As of its present data framework was confining programmed information sharing from one territorial business to others and headquarter, in this way the choice to modify information administration's structure have been considered to be proper and lined up with its prime objective(s) that is, to enhance business efficiencies, give standard vast business procedures and venture wide revealing (dispose of excess and irregularity of information) and in addition acknowledging marketable strategy of Initial Public Offering (IPO).
(5)On the other hand, information organization had additionally taken considerable part in enhancing information administration of American Water. Truth be told, the development of existing information into the new information administration framework was not just performed through minor information exchange; rather it required extra attempt(s) by data authorities and intensive examination of business clients.
(6)Dynamic engagement of data experts and business clients were getting to be basic as of information have not yet been institutionalized. Before the way that the configuration of information put away in old information administration was not being composed in like manner, consequently it involved data authorities to perform information audit, information purifying and so forth., while business clients were required to distinguish and decide the tenets and principles for overseeing information in the new information administration. This thusly, expanding the obligation and significance of information (by organization data authorities and business clients) in helping American Water to plan heavenly information administration framework, which would serve inner/or outer user(s) with predictable business information(s).
(7)Consequently, the effort(s) in which American Water dedicated to understand its objective(s) was by contributing and incorporating data framework that is, Enterprise Resource Planning to supplant its old information administration.
(8)With the reconciliation of common business insight, it empowered American Water to view, sort and dissect business knowledge information into institutionalized organization. Subsequently, it disposes of the presence of repetition, incorrect, insignificant and irregularity of information put away in new information administration framework.

2.Describe roles played by information systems specialists and end users in American Water’s systems transformation project.
With standardised data, reports were easier to generate and gave a more complete picture of operations. It made comparisons among operating units easier and allowed business units to review best practices more easily than before.
Besides, replenishing inventories could be less efficient if more than one data entry per item were used in the database. The database could reflect that a particular item is out of stock based on one data entry while in reality it is in full supply but under a different data entry.

Management made the business users responsible for the data but not just a responsibility of the information systems department on doing this thing. The business “owns” the data and it is business needs that determine the rules and standards for managing the data.

Business users were required to inventory and review all the pieces of data in the systems to determine which need to be migrated from the old system to the new system and which would be left behind as they are the one who clear on this as they are the users for the data. Business users were also required to review the data to make sure they were accurate and consistent and redundant data were eliminated.SAP Business Objects Web Intelligence enables business users to view, sort and analyse business intelligence data. It includes generating queries, reports and interactive dashboards.

3.Why was the participation of business users so important? If they didn’t play this role, what would have happened?
The participation of business users is important because business users are the ones who primarily will use the data, it should be the way they want it and the way it works best for them. Users are the ones who know best what they need and what they want. The business users know what kind of data should be migrated and what should not be.

Imagine if someone else beside the business users to determine which data to migrate, which data to leave behind, or how the data should be constructed it may simply end up a failure and not meet the business users’ needs and it would cause low work efficiency.

4.How did implementing a data warehouse help American Water move toward a more centralized organization?
(1)Evidently, information distribution center that is, fused by American Water is known as Enterprise Resource Planning (ERP).
(2)Specifically, Enterprise Resource Planning (ERP) is a data framework, which permitting different information from various inner sources to be put away and shared among business function(s) in headquarter and local business office(s).
(3)Preceding the mix of Enterprise Resource Planning (ERP) into its business forms, American Water end up ready to change itself from decentralized into brought together association as it is presently skilled to get and produce important business information from different territorial organizations without the need to ask for composed report(s).

5.Give some examples of problems that would have occurred at American Water if its data were not “clean”?
If the data are not clean, it makes the data warehouse much larger than necessary. For instance, a particular type of material may have two to three different data descriptions. Comparisons and consolidation of the data are more difficult to make when there is more than one description and definition of each data item. It may confuse the users and cause the issue of low accuracy of data.

6.How did American Water’s data warehouse improve operations and management decision making?
The water group is committed to the promotion of data must be "effective concept of clean", and through the recognition of incomplete, incorrect, inaccurate and relevant data fragments for data cleaning work into a lot of energy, and then replace, modify, or delete the "dirty" data. By providing clean data and generating reports in an easy access single data warehouse, managers and users can make better decisions, because data is more complete. Clean data can better understand the organization and provide a clearer direction for management. Using clean data, data mining is easier and more complete. By implementing data warehouse, the whole company and its subsidiaries can standardize their business processes, so as to input data in the same way, so as to make the work more reliable and create more value for the company.


Comments