Emerson Process Management, a global supplier of measurement, analytical, and monitoring instruments and services based in Austin, Texas, had a new data warehouse designed for analyzing customer activity to improve service and marketing. However, the data warehouse was full of inaccurate and redundant data. The data in the warehouse came from numerous transaction processing systems in Europe, Asia, and other locations around the world. The team that designed the warehouse had assumed that sales groups in all these areas would enter customer names and addresses the same way. In fact, companies in different countries were using multiple ways of entering quote, billing, shipping, and other data.
Assess the potential business impact of these data quality problems.
Copy the following questions and respond by writing, at a minimum, one or two well-developed paragraphs for each question. Be sure to cite the text to support your responses by integrating evidence through quotations, paraphrases, or summaries.
1) What decisions have to be made to reach a solution?
2) What steps must be taken?